自增的主键id
方式一:
insert into t_user (id,username,password,age,sex,email) values(null ,"jerry","123",22,"女","123@qq.com");
或
insert into t_user values(null ,"jerry","123",22,"女","123@qq.com");
插入一条语句时,id对应的地方写null
方式二:
insert into t_user (username,password,age,sex,email) values("jerry","123",22,"女","123@qq.com");
不写id
表结构: