Archive:PHP and MySQL Programming/Creating a Table: Difference between revisions
wikademia>Ralfe No edit summary |
wikademia>Wikademia m moved PHP and MySQL Programming/Creating a Table to Archive:PHP and MySQL Programming/Creating a Table over redirect |
||
| (12 intermediate revisions by 4 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 16: | 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 72: | 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 87: | Line 85: | ||
+--------+--------------+------+-----+---------+-------+ | +--------+--------------+------+-----+---------+-------+ | ||
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:PHP and MySQL Programming|{{SUBPAGENAME}}]] | |||