Mysql 5.7workaround using aliases

The following brings you about mysql 5.7 use alias problem solution content, I believe you must have seen similar articles. What's the difference in what we bring to you? Let's take a look at the body part of it, I believe that after reading mysql 5.7 using alias problem solution you will certainly gain something.

Delete FROM bdxm_person_info WHERE id>46171 Error message: [SQL]Delete FROM bdxm_person_info b WHERE b.id>46171[Err] 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 'b WHERE b.id>46171' at line 1 Analysis: Query the official website documentation using the correct method

Result: More: Delete b FROM bdxm_person_info b WHERE b.id>46170

Summary:

Delete using alias syntax: delete from where ....

Do you think the solution to the alias problem in mysql 5.7 above is what you want? If you want to know more about it, you can continue to pay attention to our industry information section.