mysql操作数据库和表单

1、插入数据；语法insert into 表名(列名1,列名2,...)values(值1,值2)Insert into stu(sid,sname,age,gender) values(‘s_1001’,’zhangsan’,23,’male’);insert into stu(sid,sname) values(‘s_1001’,’zhangsan’)

3、修改数据；语法：UPDATE 表名 SET 列名1=值1, … 列名n=值n [WHERE 条件]UPDATE stu SET sname=’zhangSanSan’, age=’32’, gender=’female’ WHERE sid=’s_1001’;UPDATE stu SET sname=’liSi’, age=’20’ WHERE age>50 AND gender=’male’;

5、创建用户语法：CREATE USER 用户名@地址 IDENTIFIED BY '密码';CREATE USER user1@localhost IDENTIFIED BY ‘123’; user1用户只能在localhost这个IP登录mysql服务器CREATE USER user2@’%’ IDENTIFIED BY ‘123’; user2用户可以在任何电脑上登录mysql服务器

7、撤销授权；语法：REVOKE权限1, … , 权限n ON 数据库.* FROM 用户名REVOKE CREATE,ALTER,DROP ON mydb1.* FROM user1@localhost;查看授权；语法：SHOW GRANTS FOR 用户名SHOW GRANTS FOR user1@localhost;删除用户；语法：SHOW GRANTS FOR 用户名SHOW GRANTS FOR user1@localhost;