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)

 

点赞

Leave a Reply

Your email address will not be published. Required fields are marked *