delete from后面只能接一个表,语法就是delete from 表名,中间不能加东西
解决方案 »
- 关于用sqlldr导入日期的问题
- 疑似grouping sets BUG,求解
- 求完成类似功能的Sql语句
- 急!向oracle中clob字段插入数据,insert的时候如何循环?
- oracle rman 恢复后,重建临时表空间,是怎么一回事?
- 角色分配问题(绝对高分)
- 请问高人:定时间每隔一个月运行一次存储过程,时间那段如何计算( DBMS—JOB。SUBMIT(:JOBNO,‘PROCEDURE—NAME’,SYSDATE,‘SYSDA
- 不安装ORACLE客户端通过ODBC访问数据库的方法?
- 请问如何能恢复数据??????急急急!!!!
- s_ind 什么意思
- Oracle 中 number类型,用java连接后,返回的数据类型变成BigBigDecimal,怎么救
- oracel查询时的一个小问题,请教一下大家
mysql可以哪样? 这和比不比的上无关吧,只是标准不一样吧。
我感觉mysql有些语法是没有oracle严格,但是这也不能说mysql就好
mysql也不可以这样用啊mysql> delete * from tmp;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp' at line 1
mysql> delete * from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp left join tmp2 on tmp.name=tmp2.name' at line 1
mysql> delete from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'left
join tmp2 on tmp.name=tmp2.name' at line 1
mysql>
mysql也不可以这样用啊mysql> delete * from tmp;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp' at line 1
mysql> delete * from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp left join tmp2 on tmp.name=tmp2.name' at line 1
mysql> delete from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'left
join tmp2 on tmp.name=tmp2.name' at line 1
mysql>
你写错了,额?这样。。我只知道我用在mysql上面是可以,难道一个oracle还比不上mysql ??
mysql也不可以这样用啊mysql> delete * from tmp;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp' at line 1
mysql> delete * from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp left join tmp2 on tmp.name=tmp2.name' at line 1
mysql> delete from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'left
join tmp2 on tmp.name=tmp2.name' at line 1
mysql>你写错了,是这样的。。delete a.* from aa as a left join bb as b on a.b_id=b.b_id;
delete a from aa as a left join bb as b on a.b_id=b.b_id
[SQL]delete a.* from aa as a left join bb as b on a.b_id=b.b_id;
受影响的行: 0
时间: 0.000s[SQL]
delete a from aa as a left join bb as b on a.b_id=b.b_id受影响的行: 0
时间: 0.001s
mysql也不可以这样用啊mysql> delete * from tmp;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp' at line 1
mysql> delete * from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp left join tmp2 on tmp.name=tmp2.name' at line 1
mysql> delete from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'left
join tmp2 on tmp.name=tmp2.name' at line 1
mysql>
你写错了,额?这样。。我只知道我用在mysql上面是可以,难道一个oracle还比不上mysql ??
mysql也不可以这样用啊mysql> delete * from tmp;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp' at line 1
mysql> delete * from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '* fro
m tmp left join tmp2 on tmp.name=tmp2.name' at line 1
mysql> delete from tmp left join tmp2 on tmp.name=tmp2.name;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'left
join tmp2 on tmp.name=tmp2.name' at line 1
mysql>你写错了,是这样的。。delete a.* from aa as a left join bb as b on a.b_id=b.b_id;
delete a from aa as a left join bb as b on a.b_id=b.b_id
[SQL]delete a.* from aa as a left join bb as b on a.b_id=b.b_id;
受影响的行: 0
时间: 0.000s[SQL]
delete a from aa as a left join bb as b on a.b_id=b.b_id受影响的行: 0
时间: 0.001s
但是受影响的行为0,只是没有显式的报错而已,删除数据只能按行删,不可能删除某一列的数据