Oracle和MySQL删除语句的一个区别

Oracle:

DELETE * FROM 表;   OK

DELETE FROM 表;     OK

DELETE 表1,表2 FROM 表1,表2;     WRONG

MySQL:

DELETE * FROM 表;  WRONG  

DELETE FROM 表;     OK

DELETE 表1,表2 FROM 表1,表2;     OK

posted @ 2018-09-30 14:57  JAVA之家TY  阅读(774)  评论(0编辑  收藏  举报