Visual addition, deletion and modification tutorial of sql data table (phpMyAdmin usage tutorial)

Operation of data tables is based on selecting a database, and then creating and managing data tables in the database.

1. Create sql data table:

As shown in the picture above, we enter the database and you can see the new data table, There are two things we need to fill in below, name and number of fields

Let’s create a new admin table and set 3 fields, then click Execute on the right to reach the fill-in page, where we will fill in several field names

#We need to set the id to gradually, what type of field, length, etc. After setting, we click save, and our database table is created.

#As shown in the picture above, we have created a table named admin.

Click admin this table

We can see the field information, modify the fields and delete the fields.

2. Modify the sql database table

Then we click on the operation and you can take a look:

As shown in the picture above, we can see some operations on the database table

Look at the table option on the left. We can change the name of the table, etc., and just execute it.

3. How to delete sql data table

On the right, you can copy the table to another database. Look at the lower right corner, you can clear the database table, which means to Delete all the data in our table

There is a delete data table below, click it and there will be a prompt window

After confirming, give our data table deleted.

The above is the detailed content of Visual addition, deletion and modification tutorial of sql data table (phpMyAdmin usage tutorial). For more information, please follow other related articles on the PHP Chinese website!