![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL Workbench
神奇的网友
寒江孤影,江湖故人,相逢何必曾相识。
展开
-
MySQL Workbench 导出数据库 mysqkdump Version Mismatch
异常:mysqldump.exe is version 8.0.15,but the MySQL Server to be dumped has version 5.7.15.导出失败原因是工具版本和数据库版本对应不上。要选回5.7的 mysqldump.exeEdit > Preferences > Administrator > Path to mysqldump ...原创 2019-04-11 08:35:17 · 1179 阅读 · 0 评论 -
Mysql Workbeach(一)数据库设计
1.基本字段类型PK: primary key (column is part of a pk)NN: not null (column is nullable)UQ: unique (column is part of a unique key)AI: auto increment (the column is auto incremented when rows are insert...原创 2019-04-12 11:32:47 · 864 阅读 · 0 评论 -
Mysql Workbeach
使用mysql workbench建表时,字段中有PK,NN,UQ,BIN,UN,ZF,AI几个基本字段类型标识。PK: primary key (column is part of a pk) 主键NN: not null (column is nullable) 非空UQ: unique (column is part of a unique key) 唯一AI: auto ...原创 2018-08-10 12:54:00 · 318 阅读 · 0 评论