mysql批量插值

将查询结果集插入到表中(适用批量插值)

将结果集插入 不需要添加VALUES

INSERT INTO `erp`.`role_menu` (`ROLEUUID`, `MENUUUID`) (SELECT '1',MENUID FROM menu); 

 具体的数据需要添加VALUES

INSERT INTO orderdetail (
	goodsname,
	goodsuuid,
	money,
	num,
	ordersuuid,
	price,
	state
)VALUES('java',2,1456.00,112,8,13.00,'0'),('java',2,1456.00,112,8,13.00,'0')

 

转载于:https://www.cnblogs.com/covet/p/10154465.html