文章目录
新增数据
1、语法 :
INSERT INTO 表名 (列名1,列名2,列名3…)VALUES(值1,值2,值3…)
案例演示
INSERT INTO users(Id,`Name`,Address,
Phone,Mail,UserStateId,
LoginId,LoginPwd,
UserRoleId,Gender
)VALUES(4,'测试姓名','测试地址',
'15300000000','15300000000@163.com',1,
'ceshi','123456',1,1);
2、语法 :
INSERT INTO 表名 (列名1,列名2,列名3…)VALUES(值1,值2,值3…),(值1,值2,值3…),(值1,值2,值3…),…
INSERT INTO users(Id,`Name`,Address,
Phone,Mail,UserStateId,
LoginId,LoginPwd,
UserRoleId,Gender
)VALUES(5,'测试姓名B','测试地址B',
'15300000000','15300000000@163.com',1,
'ceshi','123456',1,1),
(6,'测试