MySQL

--&nbsp;断开连接&nbsp; &nbsp; &nbsp; &nbsp;quit<br><br>--&nbsp;查看数据库&nbsp; &nbsp; &nbsp;show&nbsp;databases;<br><br>--&nbsp;创建数据库&nbsp; &nbsp; &nbsp; create&nbsp;database;<br><br>--&nbsp;创建数据库并且&nbsp;设置编码&nbsp; &nbsp; &nbsp; &nbsp;create&nbsp;database&nbsp;db007&nbsp;character&nbsp;set&nbsp;gbk;<br><br>--&nbsp;查看是否创建&nbsp;该数据库&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;create&nbsp;database&nbsp;if&nbsp;not&nbsp;exists&nbsp;db001;<br>&nbsp;<br>&nbsp;--&nbsp;查看数据库创建信息&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;show&nbsp;create&nbsp;database&nbsp;db007;<br>&nbsp;<br>&nbsp;--&nbsp;删除数据库；&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;drop&nbsp;database&nbsp;db007;<br>&nbsp;<br>--&nbsp;删除是否存在的数据库&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; drop&nbsp;database&nbsp;if&nbsp;exists&nbsp;db008;<br>&nbsp;<br>&nbsp;--&nbsp;修改数据库的编码格式&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;alter&nbsp;database&nbsp;db006&nbsp;character&nbsp;set&nbsp;utf8;<br>&nbsp;<br>&nbsp;--&nbsp;查看当前数据库&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;select&nbsp;database();<br>&nbsp;&nbsp;<br>--&nbsp;切换使用的数据库&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; use&nbsp;db001;&nbsp;<br>