如何使用mysql数据库基本命令添加数据库，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。

添加数据库

[root@localhost~]#mysql-uroot-p#进入mysql数据表`Enterpassword:WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis8......#省略部分内容Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.

mysql>showdatabases;+--------------------+|Database|+--------------------+|information_schema||mysql||performance_schema||sys|+--------------------+4rowsinset(0.00sec)

mysql> create database school; #创建新库‘school
Query OK, 1 row affected (0.00 sec)

mysql> show databases; #查看所有库
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| school |
| sys |
+--------------------+
5 rows in set (0.00 sec)

添加数据表

mysql>useschool;mysql>createtableinfo(idintnotnull,namechar(6),scoredecimal(5,2),ageint(4))；QueryOK,0rowsaffected(0.04sec)mysql>descinfo;#查看表结构+-------+--------------+------+-----+---------+-------+|Field|Type|Null|Key|Default|Extra|+-------+--------------+------+-----+---------+-------+|id|int(11)|NO||NULL|||name|char(6)|YES||NULL|||score|decimal(5,2)|YES|NULL|||age|int(4)|YES||NULL||+-------+--------------+------+-----+---------+-------+添加数据表内容mysql>insertintoinfo(id,name,score,age)values(1,'张三',88,33);QueryOK,1rowaffected(0.01sec)mysql>insertintoinfo(id,name,score,age)values(2,'李四',48,31);QueryOK,1rowaffected(0.01sec)mysql>insertintoinfo(id,name,score,age)values(3,'王五',68,27);QueryOK,1rowaffected(0.00sec)mysql>select*frominfo;#查看表内容+----+--------+-------+------+|id|name|score|age|+----+--------+-------+------+|1|张三|88.00|33||2|李四|48.00|31||3|王五|68.00|27|+----+--------+-------+------+添加表列mysql>altertableinfoaddcolumnscoredecimal(5,2);QueryOK,0rowsaffected(0.05sec)Records:0Duplicates:0Warnings:0mysql>select*frominfo;#查看表内容+----+--------+--------+-------+|id|name|hobbly|score|+----+--------+--------+-------+|1|zl|看书|NULL||2|李四|上网|NULL||5|kl|游泳|NULL|+----+--------+--------+-------+更改数据mysql>updateinfosetscore=82whereid=1;#更改id=1的学生成绩为82分QueryOK,1rowaffected(0.01sec)Rowsmatched:1Changed:1Warnings:0mysql>select*frominfo;#查看更改效果+----+--------+-------+------+|id|name|score|age|+----+--------+-------+------+|1|张三|82.00|33||2|李四|48.00|31||3|王五|68.00|27|+----+--------+-------+------+删除数据表mysql>droptableinfo;QueryOK,0rowsaffected(0.02sec)mysql>showtables;#查看是否删除Emptyset(0.00sec)#已经删除（空表）删除库mysql>dropdatabaseschool;QueryOK,0rowsaffected(0.01sec)mysql>showdatabases;#查看school数据库是否删除+--------------------+|Database|+--------------------+|information_schema||mysql||performance_schema||sys|+--------------------+删除表列（记录条数）mysql>deletefrominfowherehobbly=1;QueryOK,1rowaffected(0.01sec)mysql>select*frominfo;+----+--------+-------+------+--------+|id|name|score|age|hobbly|+----+--------+-------+------+--------+|1|张三|82.00|33|3||2|李四|48.00|31|5||3|王五|68.00|27|4||2|ff|55|44|2||3|ww|33|31|3|+----+--------+-------+------+--------+删除表列（字段）mysql>select*frominfo;#查看数据表+----+--------+-------+--------+|id|name|score|hobbly|+----+--------+-------+--------+|1|zl|88|看书||2|李四|68|上网||5|kl|88|游泳|+----+--------+-------+--------+mysql>altertableinfodropcolumnscore;#用alter删除表列mysql>select*frominfo;#再次查看数据表+----+--------+--------+|id|name|hobbly|+----+--------+--------+|1|zl|看书||2|李四|上网||5|kl|游泳|+----+--------+--------+

看完上述内容，你们掌握如何使用mysql数据库基本命令添加数据库的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注亿速云行业资讯频道，感谢各位的阅读！