接上一篇文章：MySQL基础入门常用命令介绍今天介绍一下对Mysql数据库进行一些操作的基本命令。命令mysql>setpasswordfortest=passowrd('!1A@2#3');5.6及以上命令mysql>updatemysql.usersetauthentication_string=password('A1b2c3#!@')whereuser='test';创建用户并授权mysql>grantselect,insert,updateonstudent.*totest@localhostidentifiedby'A1b2c3#!@';查看授权mysql>showgrantsfortest@localhost;删除权限mysql>revokeinsert,updateonstudent.*fromtest@localhost;建立数据库和表createdatabasemysql>createdatabasestudent;mysql>显示数据库；创建表mysql>使用学生；mysql>createtableT1(namevarchar(10)notnull,sexvarchar(10)notnull);从现有表创建新表mysql>createtableT2asselect*fromT1;插入数据mysql>insertintoT1values('zhang','man');QueryOK,1rowaffected(0.03sec)mysql>insertintoT1values('li','man');QueryOK,1rowaffected(0.03sec)mysql>insertintoT1values('wang','man');QueryOK,1rowaffected(0.02sec)mysql>insertintoT1values('zhao','women');QueryOK,1rowaffected(0.05sec)#需要注意的是，如果列超过两列，需要指定列字段名如下mysql>插入T1(姓名,性别)值('哥哥','男人');查询数据查询数据mysql>selectuser,hostfrommysql.user;#viewusermysql>select*fromT1wherenamelike'%an%';mysql>select*fromT1whereagelike'2%';匹配查询mysql>select*fromT1orderbyname,age;querysortmysql>selectcount(*)astoaolcountfromT1;mysql>selectsum(age)assumvaluefromT1;mysql>selectavg(age)asavgvaluefromT1;mysql>selectmax(age)fromT1;查询值mysql>selectscorefromT1wherescore<91;mysql>selectscorefromT1wherescore>=91;mysql>select*fromT1wherescorein(96,100);条件查询mysql>select*fromT2;mysql>select*fromT1;增删改查增删列mysql>altertableT1addageint(4)notnull;mysql>altertableT1dropage更新表中的数据mysql>updateT1setage=25wherename='zhang';mysql>updateT1setage=23wherename='li';删除数据我的sql>从年龄='22'的T1中删除；建立索引并删除mysql>createindexindexT1onT1(name(10));mysql>dropindexindexT1onT1;主键和视图创建主键mysql>altertableT1addprimarykey(name);mysql>descT1;创建和删除视图mysql>createviewt1viewasselectnamefromT1;mysql>select*fromt1view;mysql>dropviewt1view;mysql>select*fromt1view;ERROR1146(42S02):表'student.t1view'没有exist#提示该视图不存在点击关注民工科技之路微信公众号对话框回复关键词：1024即可获取一份最新技术干货：包括系统运维、Databases、redis、MogoDB、电子书、Java基础课程、Java实战项目、架构师综合教程、架构师实战项目、大数据、Docker容器、ELKStack、机器学习、BAT面试精讲视频等。
