a289676449的博客

Subquery returns more than 1 row表示子查询返回了多行数据例如:select * from table1 where table1.colums=(select columns from table2)解决方法select * from table1 wheretable1.colums=any(select columns from table2)...

写入数据库是记得把/** **/全部删除，不然会保存不了begin/**event body**/TRUNCATE table b_temp;/**清空临时表**/set @now_time = now();/**获取当前时间**/INSERT INTO b_temp(pid,proKuanshi,proNum) select * from (select...