MySQL或者SQL Server执行DELETE语句为表起别名需要注意的问题
执行DELETE语句为表起别名,不同的数据库支持的情况不同,需要注意
(ORACLE适用) DELETE FROM TABLEA A WHERE A.FIELD1=10
(SQLSERVER/MYSQL适用) DELETE A FROM TABLEA A WHERE A.FIELD1=10
(Ora/SQL均适用) DELETE FROM TABLEA WHERE TABLEA.FIELD1=10
执行DELETE语句为表起别名,不同的数据库支持的情况不同,需要注意
(ORACLE适用) DELETE FROM TABLEA A WHERE A.FIELD1=10
(SQLSERVER/MYSQL适用) DELETE A FROM TABLEA A WHERE A.FIELD1=10
(Ora/SQL均适用) DELETE FROM TABLEA WHERE TABLEA.FIELD1=10