刚接触oracle ,mysql> select * from qo_modules t where t.id=24;
+----+--------+---------+------+-------------+------------+----------+--------+--------------+-----------+
| id | author | version | url | description | moduleType | moduleId | active | loadOnDemand | sortOrder |
+----+--------+---------+------+-------------+------------+----------+--------+--------------+-----------+
| 24 | NULL | NULL | NULL | haha | et | NULL | NULL | NULL | NULL |
+----+--------+---------+------+-------------+------------+----------+--------+--------------+-----------+
1 row in setmysql> delete qo_modules t where t.id=24;
1064 - 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 'where t.id=24' at line 1
mysql> delete from qo_modules t where t.id=24;
1064 - 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 't where t.id=24' at line 1
mysql>
请问这是啥原因??oracle下都可以这样删除的啊。。
+----+--------+---------+------+-------------+------------+----------+--------+--------------+-----------+
| id | author | version | url | description | moduleType | moduleId | active | loadOnDemand | sortOrder |
+----+--------+---------+------+-------------+------------+----------+--------+--------------+-----------+
| 24 | NULL | NULL | NULL | haha | et | NULL | NULL | NULL | NULL |
+----+--------+---------+------+-------------+------------+----------+--------+--------------+-----------+
1 row in setmysql> delete qo_modules t where t.id=24;
1064 - 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 'where t.id=24' at line 1
mysql> delete from qo_modules t where t.id=24;
1064 - 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 't where t.id=24' at line 1
mysql>
请问这是啥原因??oracle下都可以这样删除的啊。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货