1： Query all fields
select from table_name;
2： Query specified fields
select name from goods;
select distinct type from goods;
If you want to query two fields in the table at the same time , Then the fields to be queried should be separated by commas
select id,name from goods;
3： Query specified records
select * from goods where id = 3;
4：
select * from goods where type = ' Sugars ';
5：
select * from goods where price =1230 ;
6：
select *from goods where price=2.5;
7：
select * from goods where add_time is NULL;
8：
select * from goods where num is not null;
9： Multi condition query ,MySQL Support multi condition query . If used between conditions and Keyword connection , Only records that meet all conditions will be returned . If conditions in multi condition query are used or
Keyword to connect , Indicates that only one of all conditions needs to be met , The record will be returned . among ,and Keywords can use symbols “&&” To replace ,or Keywords can use symbols “||” To replace .
select * from goods where type=' Sugars ' || type=' book ';
10： use in Keyword can query records whose field value is equal to any value in the specified set , The grammatical form is
select * from table_name where col_name in (value1,value2,....valuen);
or Keywords and in Keywords can achieve the same function , however in Keywords can make query statements more concise , also in Keyword execution is faster than or Keywords fast . in addition ,in
Keywords can also be associated with not Keywords used together , It is used to query records whose field value is not in the specified set .
select * from goods where id in (1,2,5,8,9);
11： Range query , Used is between keyword , Used to query records with field values within a certain range , The grammatical form is
select * from tablename where col_namea between value1 and value2;
select * from goods where price between 1 and 50;
12：
select * from goods where price >=1 and price <=50;
13：
select * from goods where price<=1 or price>=50;
14： Character matching query , use like Keyword is also called fuzzy query , It is usually used to query records whose field values contain some characters , The grammatical form is
select * from table_name where colnamea like valueb;
among ,vvalueb Represents the character to match ,like keyword General and wildcards “%” perhaps “_” Use together , If field col_namea Median contains
valueb, This record will be returned , Wildcards can be placed before characters , It can also be placed after characters , It can also be placed before and after characters . wildcard “%” Can match characters of any length , Can be 0 individual , It can also be one or more .
select * from goods where name like '% juice ';
15： No duplicate query results ：MySQL Provided distinct keyword , Make the query results not repeated , Its grammatical form
select distinct col_list from table_name;
16: Single field sorting implement sql sentence , query goods In the table id,name and add_ Data of field , And according to add_time Sort by field value , for example
select id,name,add_time from goods order by add add_time;
17: Multi field sorting , query goods All records in the table , And according to price and num Sort by field value , for example
select * from goods order by price,num;
You can see from the query results , The system will first follow price Sort by field value , about price Records with the same field value , Then according to num Sort by field value .
18： according to num Ascending sum of fields add_time Descending order of fields
select * from goods order by num asc,add_time desc;
19： implement sql sentence , take goods Find all the records in the table , And according to price Field descending sort
select * from goods order by price desc;
When sorting by multiple fields , You can also use desc Sort keywords in descending order .
Technology