MySQL

做最专业的DBA

【MySQL 帮助】帮朋友优化SQL的过程-->从4S到0.011秒

这个sql运行很慢,4秒钟 SELECT (op.cash_payment+op.pos_payment+op.online_payment+op.charge_card_payment) AS real_payment,op.* FROM db_order.`order_payment...

2013-12-19 21:21:28

阅读数:2433

评论数:0

[MySQL 写SQL]吃饭中被call起,帮她解决一个SQL的过程,

正吃饭中被大学同学call起,帮他同事解决一个复杂的SQL问题   1 SHE第一封email: select distinct Test.Name,Test.ID,Plan_Device.ID from Test,Plan_Device where Test.ID in(select Te...

2013-12-05 11:24:31

阅读数:2770

评论数:2

提示
确定要删除当前文章?
取消 删除
关闭
关闭