当创建好数据表之后,
mysql> SHOW COLUMNS FROM tb1;
+----------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| username | varchar(20) | YES | | NULL | |
| age | tinyint(3) unsigned | YES | | NULL | |
| salary | float(8,2) unsigned | YES | | NULL | |
+----------+---------------------+------+-----+---------+-------+
3 rows in set (0.04 sec)
插入记录、字段
INSERT tb1 VALUES('TOM',25,7863.25);
不写列的数据项时,在values不够,会出现不匹配的报错
mysql> INSERT tb1 VALUES('TOM',25);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
给指定的数据项添加记录
mysql> INSERT tb1(username,salary) VALUES('TOM',25);Query OK, 1 row affected (0.21 sec)
查看已经插入数据的表mysql> SELECT * FROM tb1;
+----------+------+---------+
| username | age | salary |
+----------+------+---------+
| TOM | 25 | 7863.25 |
| TOM | NULL | 25.00 |
+----------+------+---------+
2 rows in set (0.03 sec)