当前位置:网站首页>MySQL workbench basically uses [create a data table]

MySQL workbench basically uses [create a data table]

2022-07-19 05:59:00 Don't worry

tips: To make the data table look convenient and clear , You can put Result area Turn off first - Click the middle icon in the upper right corner .

 

Double click to open the newly created database -Tables-Create Table...

Fill in the relevant information in the data sheet -Apply

among , The meaning of some characters in the figure

Field data type    INT: Integers

                        TINYINT(1): Boolean value

                        VARCHAR(length): String type ,length Indicates the limit of length

Special logo           PK:primary key Primary key , Unique identification

                        NN:not null Value cannot be empty

                        UQ:unique Value cannot be duplicate

                        AI:auto increment The value increases automatically

eject SQL Pop up of statement , direct Apply-Finish

  The newly added data table appears in the left database column users

Mouse click users, The basic description of the data table will appear in the lower left corner

A data table is created .

原网站

版权声明
本文为[Don't worry]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/200/202207170509058175.html