mybatis对于自增的主键sql语句写法

102 阅读1分钟

自增的主键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


表结构:

image.png