Click on the "Plus" icon to create a new connection,
For example, first enter the database account password, account default is root, fill in the Password and click "OK", the connection is established, after the completion of the establishment, there will be a rectangular box, double-click it, appear the page shown
Click the button in the red circle in the image to create a new schema, the database (personal understanding). ), modify the value of name, such as MyDatabase, click Apply, then point to apply, then click Finish as shown
The database is built!!!
The next step is how to create a table
First to be!!! Double click!!! Just set up the database MyDatabase, and then create the table, otherwise it will be wrong, right click on tables and then click Create New tables, fill in the table name, and the table column information, then click Apply, a table is completed
Pk:primary Key (column is part of a PK) primary key
Nn:not Null (column is nullable) is empty
-uq:unique (column is part of a unique key) foreign key
Ai:auto Increment (the column is auto incremented if rows are inserted) automatically increases
Bin:binary (if DT is a blob or similar, this indicates is binary data, rather than text) binary
un:unsigned (for-integer types, see docs: "10.2.) Numeric Types ")
-Zf:zero fill (rather a display related flag, see docs: "10.2. Numeric Types ")
The following page appears
Next, add data to the built-in tb_student table.
Right-click Tb_student, and then click Select Rows Limit 1000
Adding data to a table in a database is roughly what it looks like in MySQL Workbench.
There is nothing wrong with the above, but also ask the great God for advice.
Use MySQL workbench to build a database, create a new table, add data to a table