首页 > itarticle > mysql grammer

mysql grammer

admin 11月 13, 2020 0

Select

1
2
3

select column1, column2, ... 
from table_name;
select * from table_name;

Distinct

1 2	select distinct column1, column2, ... from table_name;

Where

1
2
3

select column1, column2, ... 
from table_name 
where condition;

And , Or, Not

select column1, column2, ... 
from table_name 
where condition1 and condition2 and condition3 ...;
select column1, column2, ... 
from table_name 
where condition1 or condition2 or condition3 ...;
select column1, column2, ... 
from table_name 
where not condition;

Order By

1
2
3

select column1, column2, ... 
from table_name 
order by column1, column2, ... ASC|DESC;

Insert Into

insert into table_name 
values (value1, value2, value3, ...);
insert into table_name (column1, column2, column3, ...) 
values (value1, value2, value3, ...);

Null Values

select column_names
from table_name
where column_name is null;
select column_names
from table_name
where column_name is not null;

Update

1
2
3

update table_name 
set column1 = value1, column2 = value2, ... 
where condition;

Delete

1 2	delete from table_name where condition;