当前位置：网站首页>[mysql]--remember a delete delete statement using an alias pit

[mysql]--remember a delete delete statement using an alias pit

2022-08-06 00:30:00 【can love programming】

1. Statements that do not use aliases:

[delete from bbms.users where userid ='123';]

Delete operations can be performed normally

2. Statements using aliases:

[delete from bbms.users u where u.userid ='123';]

Cannot be deleted normally, and an error is reported:

【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 'u where u.userid ='123'' at line 1]

3. Check the information to find out:

It's not that aliases cannot be used, but aliases should be added after the delete keyword, as follows:

[delete u from bbms.users u where u.userid ='123';]

This will delete the statement normally

原网站

版权声明
本文为[can love programming]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/218/202208060026590770.html

边栏推荐

猜你喜欢

随机推荐