再双击t1表 进入表
往里面填数据插记录就可以了
tab键往下行
新建一张dep表 部门表
#4. 设计表:外键
新建dep表 员工表
新增dep_id 做外键
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107221352636-1915489136.png)
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107221732430-1258993871.png)
#5. 新建查询
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107222120159-457064706.png)
可以直接在这里查询,不需要依赖mysql服务端命令行
ctrl+?键 注释
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107222331989-1633084918.png)
#6. 备份库/表
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107222506402-595667584.png)
备份db10.sql
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107222614401-1698823713.png)
针对db10库 备份
恢复库里面的表
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107222846658-930482926.png)
导入数据
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107222950378-1734394432.png)
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107223057129-443559779.png)
然后退出连接 重新连接数据库
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107223147764-1658072631.png)
打开数据库 有了
![](https://img2018.cnblogs.com/blog/1137246/201811/1137246-20181107223206734-638887163.png)
#注意:
批量加注释:ctrl+?键
批量去注释:ctrl+shift+?键