How to Run Query in MySQL Workbench?

How to Run Query in MySQL Workbench?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Blog
  • 1 min read

In MySQL Workbench, follow these steps to run a query.

Run/Execute a Query in MySQL Workbench

  1. Open MySQL Workbench and connect to the database and set a default database.
  2. Then open an SQL editor by clicking on the menu File > New Query Tab or by pressing the key Ctrl+T.
  3. 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.
  4. 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.

Run query in MySQL Workbench