摘要:
1093 - You can't specify target table 'table_name' for update in FROM clause;不能先select出同一表中的某些值,再update这个表(在同一语句中) 原语句: delete from i_user where b_cod 阅读全文
摘要:
select DISTINCT(left(created_on, 10)) createDate from record where plan_id = '123456789' order by created_on desc; 报错信息: Expression #1 of ORDER BY cla 阅读全文
摘要:
1. not in的结果集中出现null则查询结果为null; select * from device where code not in ('A', 'B', null); 上面查询结果为 null,查不出想要的结果 2、in的结果集中出现null不影响; select * from devic 阅读全文