Mysql 基础

Mysql 数据类型

1.整数

intyint              //小整数值 255 
smallint 
mediumint
int                   //大整数值 4 294 967 295
integer
bigint            //最大整数值  18 446 744 073 709 551 615

2.小数

float 
double

3.日期

date
time
year
datetime
timestamp

4.字符

char
varchar
intyblob
tinytext
blob
text
mediumblob
mediumtext
longblob
longtext

Mysql 基础操作

4.增

insert into wx_admin ('wx_uid','wx_username') values ('admin','123456');

insert into wx_temp('wx_temp_on','wx_temp_name') values('6','视频播放');

2.改

update wx_admin set wx_username = 'maybe', wx_nickname = 'gengwenx';

update wx_admin set wx_username = 'mybe' where id = 12;

3.删

delete form wx_admin where wx_username = 'admin' and wx_uid = 3;

delete form wx_admin where wx_uid = 12;

4.查

select wx_username as name, wx_nickname as nickname  from wx_admin;

select * from wx_admin where wx_username = 'maybe';

5.where

select * form wx_admin where wx_admin_username = 'admin';

select * from wx_admin where wx_admin_username = 'admin' and wx_uid = 1;

6.like

select * from wx_admin where wx_admin_username like '%min%';

select * from wx_admin where wx_admin_username like '%admin';

6.union

select * from wx_admin union all select * from wx_admin;

select * from wx_admin union distinct select * from wx_admin;

7.排序

select * from wx_temp order by wx_temp_sort asc;

select * from wx_temp order by wx_temp_sort desc;

8.分组

select wx_temp_name,count(wx_uid) form wx_temp group by wx_temp_name;

select *,count(wx_uid) from wx_temp group by wx_temp_name;