DELETE操作之表别名
ORACLE数据库:
DELETE test t WHERE t.id<10;
SQL SERVER与MySQL(类似于SELECT操作)
DELETE t FROM test t WHERE id<10;
通用不取别名:
DELETE test WHERE test.id<10;
ORACLE数据库:
DELETE test t WHERE t.id<10;
SQL SERVER与MySQL(类似于SELECT操作)
DELETE t FROM test t WHERE id<10;
通用不取别名:
DELETE test WHERE test.id<10;