delete from t1
where t1.id >312You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't1
where t1.id >100000' at line 1
where t1.id >312You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't1
where t1.id >100000' at line 1
+------+------+
| id | f1 |
+------+------+
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
+------+------+
4 rows in set (0.00 sec)mysql> delete from t1
-> where t1.id >3;
Query OK, 1 row affected (0.09 sec)mysql> select * from t1;
+------+------+
| id | f1 |
+------+------+
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
+------+------+
3 rows in set (0.00 sec)mysql>
where id >312 ;
试试这个~~!!看行不???
LZ绝对是输入法问题,因为sql文正确。
也不是什么权限问题。
建议重建个表,进行测试!