小白：MySQL

基本命令：create  drop  show  describe

数据类型：文本：varchar(size)  text long text数字：tinyint(size) int(size) bigint(size) double(size,d) decimal(size,d)日期：date() datetime()

添加／删除列：alter table table_name add col_name data_type [not null] [default]            alter tabletable_namedrop col_name

修改列名／数据类型：alter table table_name rename new_table_name            alter tabletable_namechange old_col_name new_col_name data_type

插入／查看表数据：insert into table_name (,  ,  ...) values (,  ,  ...)            select * fromtable_name

where条件查询in:   select * fromtable_namewhere col_name [not]in (value1,value2,....) / (selectcol_namefrom table_name)

where条件查询between:   select * from table_name where col_name [not]between...and...

where条件查询like：select * fromtable_namewhere col_name [not]like pattern     'abc'   '%abc'   'abc%'   '%abc%'

去重查询：select distinct

判断null：is    is not

排序：select * from table_name [where子句]order bycol1 asc/desc,col2 asc/desc...

limit截取：select * from table_name [where子句] [order by子句]limit [offset,]  row_count

insert和select结合：insert into table1 selectcol1,col2 ...from table2       insert into table1(col1,col2 ...)  select col1,col2 ...fromtable2

更新表数据：update table_name set col1 = xxx,col2 = xxx ... [where子句]