1、新建数据库
新建一个名为 test 的数据库:右击数据库点击新增,然后创建一张 test ,utf8mb4 字符的,点击确定
![48337de837fc4331b8f8aa9f4a703f5e.png 48337de837fc4331b8f8aa9f4a703f5e.png](https://ucc.alicdn.com/pic/developer-ecology/vksqf7nht55li_0fec7256f8c84fdf855a50eefb46a36c.png?x-oss-process=image/resize,w_1400/format,webp)
2、新建数据表
2.1、新建表
在 test 数据库下新建一张数据表,如下所示:右击表,然后点击新建表
![15dbb0f9dc434ceda79210af2ab15ab4.png 15dbb0f9dc434ceda79210af2ab15ab4.png](https://ucc.alicdn.com/pic/developer-ecology/vksqf7nht55li_a91e60446b6d4455aeba733e2284815d.png?x-oss-process=image/resize,w_1400/format,webp)
2.2、新建列
在列的空白处右击,新建列
id 主键选择数据类型选择 INT,非空和自增都勾选上,如下所示:
![6aa89e0c30b84f45b3bcbbdeab7538c6.png 6aa89e0c30b84f45b3bcbbdeab7538c6.png](https://ucc.alicdn.com/pic/developer-ecology/vksqf7nht55li_ec45c9d3337b48d6a8257172deead9e0.png?x-oss-process=image/resize,w_1400/format,webp)
2.3、新建约束
切换到约束,在列的空白处右击,新建约束
![4147b278248a43e4b47394461acc7269.png 4147b278248a43e4b47394461acc7269.png](https://ucc.alicdn.com/pic/developer-ecology/vksqf7nht55li_8355533e2f804d50bc2bd4edb313a660.png?x-oss-process=image/resize,w_1400/format,webp)
2.4、保存表
点击下面的保存按钮,然后在执行
![da0857c03f04482397f1268b2a1ab78c.png da0857c03f04482397f1268b2a1ab78c.png](https://ucc.alicdn.com/pic/developer-ecology/vksqf7nht55li_6c4da05385b64c308951a49931a6d4ff.png?x-oss-process=image/resize,w_1400/format,webp)
2.5、设置数据
在新建一个字段 name,选字符串的,不为空就行。
然后切换到数据一栏,按顺序手动添加保存即可。
![cdbc8a82b59d444e8346e1a42661caa2.png cdbc8a82b59d444e8346e1a42661caa2.png](https://ucc.alicdn.com/pic/developer-ecology/vksqf7nht55li_d851505e453e4cdd9aa6dee98c8a159c.png?x-oss-process=image/resize,w_1400/format,webp)