MySQL Workbench是MySQL 图形界面管理工具,是一款专门为用户提供了用于创建、修改、执行和优化SQL的可视化工具。
1.新建数据库连接
![](https://img.haomeiwen.com/i1770172/827d0263dd6f5b7e.png)
Manager Connection
![](https://img.haomeiwen.com/i1770172/ee894f20bca18313.png)
Database--> Connect to Database 连接数据库
![](https://img.haomeiwen.com/i1770172/c4748dd261bab2a2.png)
![](https://img.haomeiwen.com/i1770172/45e4e2ab8f0b62bd.png)
![](https://img.haomeiwen.com/i1770172/0820ded593535f9f.png)
2.创建数据库
![](https://img.haomeiwen.com/i1770172/2cdc2fbf1062b7ce.png)
![](https://img.haomeiwen.com/i1770172/d62b69441a93545e.png)
![](https://img.haomeiwen.com/i1770172/6dcf1d2852383d33.png)
![](https://img.haomeiwen.com/i1770172/5cee43d28d5f995c.png)
![](https://img.haomeiwen.com/i1770172/d567aae7ec18066a.png)
3.新建表
![](https://img.haomeiwen.com/i1770172/3e6440c0f9fb9eb1.png)
在创建表的时候,默认的数据存储引擎是InnoDB,Comments表示描述信息,
比如需要创建主键id,直接选择后面的PK(Primary Key) 和AI(Auto Increment)复选框即可
删除表
![](https://img.haomeiwen.com/i1770172/e1229266a4350137.png)
修改表
![](https://img.haomeiwen.com/i1770172/5bd2ffa0469cbee3.png)
查询表
![](https://img.haomeiwen.com/i1770172/87cd7f5d9ec2e752.png)
修改表结构 Alter Table
![](https://img.haomeiwen.com/i1770172/2d721afb123b0eae.png)
建立ER模型
New Model
![](https://img.haomeiwen.com/i1770172/730b588960fa49df.png)
网友评论