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

This article mainly introduces the relevant knowledge of "what is the meaning of mysql field selection". The editor shows you the operation process through an actual case. The operation method is simple and fast, and it is practical. I hope this article "what is the meaning of mysql field selection" can help you solve the problem.

Description

1. According to the actual needs, specify the desired field names and separate them with English commas.

2. Get all the fields and match them with an asterisk *.

3. The field data does not necessarily come from the data source (select as long as there is a result)

4. As long as you ensure that the data requirements can be met, the selection of fields should be replaced by * as little as possible (MySQL optimization)

Example

# full query select * from tweets 6; # requirements for trade names and prices select goods_name,goods_price from tweets 6; # aliases using select goods_name as gn,goods_price gp from tweets 6; this is the end of the content on "what is the meaning of mysql field selection". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

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.