![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql数据库
枕边姝
这个作者很懒,什么都没留下…
展开
-
mysql 有权限,不能增删改 SET SQL_SAFE_UPDATES=0;
SET SQL_SAFE_UPDATES=0; 执行完这一句之后便可以增删改原创 2016-11-16 09:48:43 · 7916 阅读 · 0 评论 -
查看数据库表之间问题SQL
select * from ( select t1.id,t1.product_name_cd,t1.batch_num,t1.weight as w1,t2.weight as w2,IFNULL(t1.weight,0)-IFNULL(t2.weight,0) as diff from ( select id,product_name_cd,batch_num, sum( weight原创 2016-11-16 10:02:10 · 287 阅读 · 0 评论