1、我们先建一个表user
mysql> create table user(
-> id int(4) primary key auto_increment,
-> username varchar(20),
-> password varchar(20));
Query OK, 0 rows affected (0.08 sec)
2、我们先插入一条数据:
mysql> insert into user values (null,'admin',300000);
Query OK, 1 row affected (0.09 sec)
3、我们插入的主键值为null,可还是插入成功了。查看该表的值:
mysql> select * from user;
+----+----------+----------+
| id | username | password |
+----+----------+----------......
阅读全文