- A+
所属分类:Mysql
1.mysql服务的启动和停止
- mysql> net stop mysql
- mysql> net start mysql
2.登陆mysql
- mysql> 键入命令mysql -uroot -p, 回车后提示你输入密码,输入12345,然后回车即可
3.操作数据库
- 显示数据库列表。show databases;
![MYSQL登录、以及表的操作](https://oss-wp-picture.oss-cn-shanghai.aliyuncs.com/2020/06/1730824-20190718151209708-1122941532-2.png)
- 显示数据表的结构:mysql>describe 表名;mysql>(或者)desc 表名;
![MYSQL登录、以及表的操作](https://oss-wp-picture.oss-cn-shanghai.aliyuncs.com/2020/06/1730824-20190718151305605-1274728652-2.png)
- 建库与删库:mysql> create database 库名;
mysql> drop database 库名;
![MYSQL登录、以及表的操作](https://oss-wp-picture.oss-cn-shanghai.aliyuncs.com/2020/06/1730824-20190718151338108-649240037-2.png)
- 建表:mysql> use 库名;mysql> create table 表名(字段列表);mysql> drop table 表名;
![MYSQL登录、以及表的操作](https://oss-wp-picture.oss-cn-shanghai.aliyuncs.com/2020/06/1730824-20190718151356380-1378828957-2.png)
- 微信公众号
- 扫一扫关注微信公众号
-
- 运维交流群
- 扫一扫二维码加入群聊
-