阿里云分布式数据库SQL命令创建用户
使用CREATEUSER语句创建一个用户tiuser，密码为123456
CREATEUSER'tiuser'@'localhost'IDENTIFIEDBY'123456';用户授权
授权用户tiuser可检索数据库samp_db内的表
CREATEUSER'tiuser'@'localhost'IDENTIFIEDBY'123456';用户权限查询
查询用户tiuser的权限
SHOWGRANTSfortiuser@localhost;删除用户
删除用户tiuser
DROPUSER'tiuser'@'localhost';
数据操作插入数据INSERTINTOpersonVALUES("1","tom","20170912");
查询数据SELECTFROMperson;+--------+------+------------+|number|name|birthday|+--------+------+------------+|1|tom|2017-09-12|+--------+------+------------+修改数据UPDATEpersonSETbirthday='20171010'WHEREname='tom';SELECTFROMperson;+--------+------+------------+|number|name|birthday|+--------+------+------------+|1|tom|2017-10-10|+--------+------+------------+删除数据DELETEFROMpersonWHEREnumber=1;SELECTFROMperson;Emptyset(0.00sec)
