个人记事_insert into 的简单使用
上一篇 /
下一篇 2019-01-13 21:48:01
/ 个人分类：mysql
insert into 3种简单使用方式：
insert into pre_common_menber (uid,username,password) values (1,'hailan','123465');
2. 插入批量记录
insert into pre_common_menber (uid,username,password)
values
(1,'hailan','123465'),
(2,'hailan','123465'),
(3,'hailan','123465'),
(4,'hailan','123465'),
(5,'hailan','123465');
3.插入批量，插入列的顺序和表中列的顺序一致，还可以省去列名的定义
insert into pre_common_menber
values
(1,'hailan','123465'),
(2,'hailan','123465'),
(3,'hailan','123465'),
(4,'hailan','123465'),
(5,'hailan','123465');
收藏
举报
TAG:
