Wampserver-mysql Creating a Database

First open the Wampserver, in the lower right corner will appear a such icon, left click it, select Mysql->mysql Console

Enter password

Creating a new database: Create DB XXX

Note to lose ";", so that the creation is successful, enter use XXX, enter this database

Then open a notepad and write the MySQL statement

Then save and change the file format to SQL

Enter in the Command box: source (SQL file path)

The result of the carriage return is as follows, the import succeeds, the INSERT statement is inserted under the Command box, the content is viewed using the SELECT statement

Ways to delete a database:

Wampserver-mysql Creating a Database