PHP学习（6）数据库操作（二）

残缺极品

//查询,字段
SELECT id,uid FROM anpeng.`test` WHERE 1
//查询,转换
SELECT remarks as r FROM anpeng.`test` WHERE 1
//查询,等于
SELECT * FROM anpeng.`test` WHERE id=2
//查询,不等于
SELECT * FROM anpeng.`test` WHERE id<>2
//查询,包含
SELECT * FROM anpeng.`test` WHERE id in(1,3)
//查询,不包含
SELECT * FROM anpeng.`test` WHERE id not in(1,3)
//查询,匹配
SELECT * FROM anpeng.`test` WHERE 'uid' like '%王%'
//查询,between在范围
SELECT * FROM anpeng.`test` WHERE id between 1 and 3
//查询,not between不在范围
SELECT * FROM anpeng.`test` WHERE id not between 1 and 3
//查询，条件and
SELECT * FROM `test` WHERE `id`=1 and `remark`='学生'
//查询，条件or
SELECT * FROM `test` WHERE `id`=1 or `remark`='学生'
//查询，分组group by
SELECT * FROM `test` group by 'remark'
//查询，排序order by  //asc 正序  //desc 倒序
SELECT * FROM `test` order by 'regdata'
//查询，指针limit
SELECT * FROM `test` limit 0,3
//查询,统计总数
SELECT count(*) FROM anpeng.`test` WHERE 1
//查询，统计最大值
SELECT max(id) FROM `test` WHERE 1
//查询，统计最小值
SELECT min(id) FROM `test` WHERE 1
//查询，统计平均值
SELECT AVG(id) FROM `test` WHERE 1
//查询，统计最小值
SELECT SUM(id) FROM `test` WHERE 1
//插入
insert into test (`id`,`uid`,`regdate`,`remark`) values (5,'anpeng','2010-04-09','学生')
insert into test values (5,'anpeng','2010-04-09','学生')
//更新
update test set uid='anpeng' where id=6
//删除
delete from test where id=3