mysql基础语法

在线模拟地址
http://sample.jimstone.com.cn/xsql/Course/

sql：structured query language（结构性查询语言）

sql 氛围DML(Data Manipulation Language数据操纵增删等)和DDL（Data Definition Language 数据定义，增加数据库和表等。）

“Persons” 表:
Id LastName FirstName Address City
1 Adams John Oxford Street London
2 Bush George Fifth Avenue New York
3 Carter Thomas Changan Street Beijing

测试语句
select from person (输出整个person表)
select lastname,firstname from person （从persons表中输出lastname和firstname列 ）
select instinct 列名 from person (去重查询)
select rowname或者* from table where anyrowname=‘john’

AND运算
select *from person where LastName=‘Adams John’ AND city=‘new York’

Order by 排序运算（默认升序，ASC也是升序）desc则是降序
select *from person order by ordernumber ASC

一个升序一个降序
select *from person order by ordernumber ASC,company DESC

插入运算
insert into person (“lastname”) values (“tande”)

更新运算
update user set students=‘tande1’,score=‘100’ where students=‘tande’ （注意where前面不能有符号）