MySQL数据库
p@ssword
这个作者很懒,什么都没留下…
展开
-
1292 - Truncated incorrect DOUBLE value: ‘NIL‘
1292 - Truncated incorrect DOUBLE value: 'NIL'原创 2022-10-27 11:06:28 · 353 阅读 · 0 评论 -
1442 - Can't update table 'table_name' in stored function/trigger because it is already used by stat
对本表触发,解决方式在最后面解决对订单详情表插入数据之前通过t_goods.price(单价)和t_orderdetail.amount(购买数量)字段计算出orderdetail.sum的值(求总价)表结构t_goods(货物表)t_orderdetail(订单表)根据我自己的想法做了两次没成功第一次:CREATE TRIGGER t_insertsumprice BEFOR...原创 2019-03-30 18:22:30 · 7682 阅读 · 1 评论 -
数据库那些不知道的细节
联表查询inner join…on比where效率高,为什么我这inner join查询时间更长?select t_orders.id ordersid,t_orders.employeeid employee, t_orders.customerid customer,t_orders.ordertime, t_employee.id eid,t_employee.name e...原创 2019-03-30 18:23:50 · 300 阅读 · 0 评论