Exemple 2-1: Structure d'une table (demo1) et des champs qui la définissent:
Database: demo Table: demo1 Rows: 1
+----------+-----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------+------+-----+---------+----------------+
| id | int(10) | | PRI | 0 | auto_increment |
| login | char(10) | | MUL | | |
| password | char(100) | YES | | | |
| fullname | char(40) | | | | |
| url | char(60) | | | | |
| food | int(11) | | | 0 | |
| work | int(11) | | | 0 | |
| love | int(11) | | | 0 | |
| leisure | int(11) | | | 0 | |
| sports | int(11) | | | 0 | |
+----------+-----------+------+-----+---------+----------------+