SQL

Mysql

+---------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | |  sname | varchar(10) | NO | | | | | gender | char(1) | NO | | | | | company | varchar(20) | NO | | | | | salary | 0.00 | NO decimal (6, 2) | | | | | fanbu | smallint (6) | NO | | 0 | | +---------+--------------+------+-----+---------+----------------+Copy the code