select name,country from tb;
select * from tb;
select distinct country from tb;//筛选出不重复的唯一值
select * from tb where id="1"
select * from tb where num=1;
select * from tb where num > 3 and num < 5;
select * from tb where num > 3 or id < 6;
select * from tb where not num > 3; //小于等于3
select * from tb where id is null ;//id 是空值
select * from tb where num between 3 and 6 ;
select * from tb where num in (2,5,6); //num 等于2,5,6的
select * from tb where country like "N%";//以N开头的国家； %N%含有N的国家； %N_倒数第二个字是N的国家 （%多个字值；_下划线一个字符）
select * from tb where num > 5 and (country = "USA" or country = "UK")
select * from tb order by num ASC|DESC //升序、降序
select * from tb order by country,id //ORDER BY 多列的时候，先按照第一个country排序，在按照第二个id排序
insert into tb (name,num,country) values ('ss','5','US') //没有指定的列默认是0
update tb set num= '6',country='china' where name='goole'
delete * from tb
delete from tb where name="baidu” and country="US"
SQL入门基础语法
©著作权归作者所有,转载或内容合作请联系作者
- 文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
- 文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
- 文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
