mysql> delete
from
love l
where
l.user_id = '402880e637f04df30137f051bf110000'
and l.pic_id = '4028b8813813102e013813103b8f0002';
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 'l
where
l.user_id = '402880e637f04df30137f051bf110000'
a' at line 3
mysql> delete
from
love
where
user_id = '402880e637f04df30137f051bf110000'
and pic_id = '4028b8813813102e013813103b8f0002';
Database changed
from
love l
where
l.user_id = '402880e637f04df30137f051bf110000'
and l.pic_id = '4028b8813813102e013813103b8f0002';
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 'l
where
l.user_id = '402880e637f04df30137f051bf110000'
a' at line 3
mysql> delete
from
love
where
user_id = '402880e637f04df30137f051bf110000'
and pic_id = '4028b8813813102e013813103b8f0002';
Database changed
mysql>
删除的时候,为啥不能给表取别名?
搞不懂!!
不过,下次记住,不要给它取别名就是了!!!!!