The following tables list keyboard shortcuts for MySQL Workbench commands. Modifier in the tables stands for the platform-specific modifier key. This is Command on macOS, Control on other platforms. On macOS, the Alt key is Option. There are keyboard shortcuts for the different menus in MySQL Workbench. Mar 05, 2019 Then in the SQL editor type your query, for example, select. from customer, then press Ctrl+Enter to run the current query in MySQL Workbench. To run the whole SQL script press Ctrl+Shift+Enter. You can also click the buttons highlighted below in the image. Button 1 to execute the whole script and button 2 to run the query under the cursor.
To run SQL script in MySQL, use the MySQL workbench. First, you need to open MySQL workbench.
https://bestdload271.weebly.com/tama-serial-number-lookup.html. Blueharvest 6 3 3 – disable ds_store creation and more. The snapshot is as follows −
Now, File -> Open SQL Script to open the SQL script.
Alternatively, use the following shortcut key −
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 − Fluid browser watch more learn more 1 6.
After that you need to execute the script. To execute the script, click the symbol marked in the following screenshot − Vise x 5 1 – create your own installation programs.
After that you will get the following output −