Archive:PHP and MySQL Programming/Creating a Table: Difference between revisions
wikademia>Darklama m Programming:PHP and MySQL:Creating a Table moved to Programming:PHP and MySQL/Creating a Table: fixing copy+paste move |
wikademia>Wikademia m moved PHP and MySQL Programming/Creating a Table to Archive:PHP and MySQL Programming/Creating a Table over redirect |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
== Introduction == | == Introduction == | ||
{{?}} | |||
Before creating a table, please read the previous section on [[Programming:PHP and MySQL:Creating a Database|Creating a Database]]. | Before creating a table, please read the previous section on [[Programming:PHP and MySQL:Creating a Database|Creating a Database]]. | ||
| Line 18: | Line 14: | ||
+------------+--------------+------------------------------+------+ | +------------+--------------+------------------------------+------+ | ||
As you can see, We have rows (horizontal collection of fields), as well as columns (the vertical | As you can see, We have rows (horizontal collection of fields), as well as columns (the vertical attributes and values). | ||
== Creating a Table == | == Creating a Table == | ||
| Line 74: | Line 70: | ||
1 row in set (0.05 sec) | 1 row in set (0.05 sec) | ||
And then to show the same information, in a | And then to show the same information, in a tabulated format : | ||
mysql> DESCRIBE `books`; | mysql> DESCRIBE `books`; | ||
| Line 90: | Line 86: | ||
4 rows in set (0.18 sec) | 4 rows in set (0.18 sec) | ||
[[ | [[../Creating a Database/|Previous: Creating a Database]] | [[../|TOC]] | [[../Basic Queries/|Next: Basic Queries]] | ||
[[Category:MySQL]] | |||
[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]] | |||