PhpMyAdmin database operations

1. Access the MySQL database web page management tool through the phpMyAdmin website you have created.

 

2. Enter your user account and password to log on.

3. enter the name of the database to be created in the database creation box, for example, qk_newdb, select utf8_general_ci encoding, and then click "CREATE". If your account has the permission to create a database, then phpMyAdmin prompts that the database is successfully created.

4. After creating a database, enter the name of the table to be created at the bottom, specify the columns of the table to be created, and click Create ", go to the page for setting the table data format.

5. Fill in the columns of the table to be created, set the data format and attributes of each column, and set the ID column to automatically increase. The name column is a text column, the posttime column is the time when data is inserted. It is represented by numbers and can be stored as timestamp.

6. Click Save to create a table. You can add data to the table by following the steps below.

 

Click Browse to view the data in the table.

 

7. Click a database name to return to the database table list. You can delete a data table.

8. Click "Export" to export data in the current database for backup.

9: click "import" to copy the backup. import the SQL database file to the selected database. If the backup file is not set to automatically delete duplicate tables, manually delete the table with the same name as the current database table in the backup file, otherwise, the Import fails.