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

Most people do not understand the knowledge points of this "mysql query option instance Analysis" article, so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "mysql query option example Analysis" article.

Description

1. Query options, which are used for simple data filtering of query results. Query options are mutually exclusive after the select keyword.

2. All defaults to keep all records (keywords may not be displayed).

Distinct deduplicates and repeats the record (based on the record of the selected field, not a field)

Example

Create table tweak 6 (id int primary key auto_increment, goods_name varchar (50) not null, goods_price decimal (10dag2) default 0.00, goods_color varchar (20), goods_weight int unsigned comment 'weight, unit g') charset utf8; insert into taper 6 values (null,'mate10',5499.00,'blue',320), (null,'mate10',5499.00,'gray',320), (null,'nokia3301',1299,'black',420) # consider the deweighting of all fields (excluding logical primary keys) select distinct goods_name,goods_price,goods_color,goods_weight from tweets 6 / select goods_name,goods_price,goods_color,goods_weight from tweets 6; # keep all # regardless of color / select distinct goods_name,goods_price,goods_weight from tweets 6 / select all goods_name,goods_price,goods_weight from tones 6 The above is about the content of this article "mysql query option example Analysis". I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.

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.