MySQL database-3. Visualizing the Operational database

Create a table

increase, delete, change and check the data in the table

Check

Right-click the table you just created-choose to view the top 1000 data

Increase, change

The table must have a primary key to add data, and the primary key cannot be duplicated

1. Right-click Table-View Top 1000 data

2. Click the NULL location to add the data you want to add (click Existing data to make changes to the existing data)

3. Click Apply in the bottom right corner after clicking on the data to add, click on the application in the pop-up window, then click Finish after the error.

By deleting

Right-click the data in the list-pop-up menu-Select Delete this piece of data

MySQL database-3. Visualizing the Operational database