10-361 查询商品表中部分字段
select id,category_id,name from sh_goods;
10-362 简单条件查询数据
select * from sh_goods where id = 1;
10-363 修改商品表价格数据
update sh_goods set price = 30 where id = 2
10-364 删除商品表数据
delete from sh_goods where category_id != 3;
10-365 获
Mysql 的权限分类
分为以下四种:
1.全局权限
mysql> grant all privileges on *.* to 'test'@'%' with grant option; # 赋予全部的权限
mysql> grant select on *.* to 'test'@'%'; # 赋予查询的权限
mysql> revoke all privileges on *.* from 'test'@'%'; # 撤销全部的权限
说明:通过通配符 *.