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)