Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Mysql 5.7workaround using aliases

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report