php操作mysql的几条基本命令

查询 select * from table;/全部查询 select * from table where '字段' like '%aaa%';/模糊查询 select * from table order by '字段' desc/asc;/按升降排序 select COUNT(*) from news;/查询共多少条记录 插入 insert into table values('','','','');/插入一条记录 修改 update table set `字段`="修改内容" where `id`=number;/修改一条记录 删除 delete from table where `id`=number;/删除一条记录 -----------------------------------------------------------------