How to run SQL script in MySQL?

MySQLMySQLi Database

To run SQL script in MySQL, use the MySQL workbench. First, you need to open MySQL workbench.

The snapshot is as follows −

Now, File -> Open SQL Script to open the SQL script.

Alternatively, use the following shortcut key −

Ctrl+Shift+O

After that an option would be visible for you to choose your .sql file from the disk. In my system, the file is located on the Desktop. I will select the same “tblstudent” SQL file as shown in the following screenshot −

After browsing .sql files, you need to select the option “Reconnect to database” as shown in the following screenshot −

Now, it will ask for password to connect with MySQL. Add the password and click “OK” as in the following screenshot −

Note − Press OK button twice to connect with MySQL.

After completing the above process, the following screen will be visible with our SQL file “tblstudent”, which we uploaded before −

After that you need to execute the script. To execute the script, click the symbol marked in the following screenshot −

After that you will get the following output −

raja
Published on 21-Dec-2018 10:14:06
Advertisements