MySQL基本查询语句及方法

基本查询语句及方法:

书写顺序:

  比如: select * from emp where id > 3 and id < 6;

执行顺序:

  from:先确定是哪张表 

    from 表名

  where:根据过滤条件筛选数据   

    where nane like ‘%要查询的数据%’

  select:再取出筛选出来的某些数据字段

    select mame,salary

  建表:

# 建一个新库,指定库建表 create database ku1; use ku1; create table emp( id int not null unique auto_increment, name varchar(20) not null, sex enum(\'male\',\'female\') not null default \'male\', #大部分是男的 age int(3) unsigned not null default 28, hire_date date not null, post varchar(50), post_comment varchar(100), salary double(15,2), office int, #一个部门一个屋子 depart_id int ); # 在表中插入数据 insert into emp(name,sex,age,hire_date,post,salary,office,depart_id) values (\'jason\',\'male\',18,\'20170301\',\'张江第一帅形象代言\',7300.33,401,1), #以下是教学部 (\'egon\',\'male\',78,\'20150302\',\'teacher\',1000000.31,401,1), (\'kevin\',\'male\',81,\'20130305\',\'teacher\',8300,401,1), (\'tank\',\'male\',73,\'20140701\',\'teacher\',3500,401,1), (\'owen\',\'male\',28,\'20121101\',\'teacher\',2100,401,1), (\'jerry\',\'female\',18,\'20110211\',\'teacher\',9000,401,1), (\'nick\',\'male\',18,\'19000301\',\'teacher\',30000,401,1), (\'sean\',\'male\',48,\'20101111\',\'teacher\',10000,401,1), (\'歪歪\',\'female\',48,\'20150311\',\'sale\',3000.13,402,2),#以下是销售部门 (\'丫丫\',\'female\',38,\'20101101\',\'sale\',2000.35,402,2), (\'丁丁\',\'female\',18,\'20110312\',\'sale\',1000.37,402,2), (\'星星\',\'female\',18,\'20160513\',\'sale\',3000.29,402,2), (\'格格\',\'female\',28,\'20170127\',\'sale\',4000.33,402,2), (\'张野\',\'male\',28,\'20160311\',\'operation\',10000.13,403,3), #以下是运营部门 (\'程咬金\',\'male\',18,\'19970312\',\'operation\',20000,403,3), (\'程咬银\',\'female\',18,\'20130311\',\'operation\',19000,403,3), (\'程咬铜\',\'male\',18,\'20150411\',\'operation\',18000,403,3), (\'程咬铁\',\'female\',18,\'20140512\',\'operation\',17000,403,3) ;

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/zzssgx.html