Mysql批量添加数据

方法一：建一个存储过程

方法二：会话变量

set @varname = value;
insert into tbl_name(col1,col2,col3,col_varname) values(val1,val2,val3,@varname),(val21,val22,val23,@varname),(val31,val32,val33,@varname)

 

转载于:https://www.cnblogs.com/aeolian/p/10628583.html