csdn_mx的博客

1.ORACLE没有LIMIT，只能使用ROWNUM 例如 SELECT COUNT(1) FROM table_name WHERE ROWNUM <= 10; 2.ORACLE将字符串转换为日期格式：TO_DATE('2019-07-10 00:00:00', 'yyyy-MM-dd HH24:mi:ss') 3.ORACLE创建触发器： CREATE OR REPLACE TRI...

001.You can't specify target table 'table_name' for update in FROM clause MYSQL在执行 DELETE FROM table_name WHERE column_a IN ( SELECT column_a FROM table_name WHERE column_b = value_a) 时报错，MYSQL官方说这是考...