Shulou(Shulou.com)05/31 Report--

This article is to share with you what are the points for attention in writing SQL sentences. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. Use "`" in English mode. Note that it is not a single quotation mark.

Correct format:

Select `user_ id`, `name`, `room`from `prv_ user`

Wrong format:

Select 'user_id','name','desc' from' prv_user'

2. Write SQL statements with a space before and after the quotation marks of SQL statements to avoid accidental SQL statements being linked together.

String sql = "select `user_ id`, `name`, `room`from `prv_ user`"

3. Avoid using database-related reserved fields when naming database names and field names in SQL statements.

Thank you for reading! This is the end of this article on "what are the points for attention in writing SQL sentences?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.