-------------- ------------- ------ ----- --------- ------- Field Type

1
2
3
4
5
6
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| product_name | varchar(10) | YES | | NULL | |
| supplier | int(10) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+