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

This article will explain in detail how to use select syntax in mysql. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

1. The keywords in the SQL statement are not case-sensitive, and SELECT is equivalent to SELECT,FROM and from.

2. If you select all the columns from the users table, you can use the symbol * instead of the column name.

Grammar

-- this is a comment-- query all data from the table specified by FEOM. * indicates [all columns] SELECT*FROM-- query the data SELECT column name (field) of the specified column name (field) from the FROM from the specified [table] FROM table name

Example

Note: between multiple columns, use English commas to separate select username,password from. This is the end of the article on "how to use select syntax in mysql". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it 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.