CODEWITHSUNDEEP
mysqlsqlmysql-workbench
user921020
user921020

Reputation: 365

How to execute multiple SQL queries in MySQL Workbench?

I am using MySQL Workbench CE for Windows version 5.2.40.

I want to execute the following SQL queries together. However I can only execute the SQL queries by first executing the CREATE TABLE query, and then executing the INSERT INTO query and after that executing the SELECT query. 

CREATE TABLE testTable(
    Name VARCHAR(20),
    Address VARCHAR(50),
    Gender VARCHAR(10)
)

INSERT INTO testTable
    VALUES
    ('Derp', 'ForeverAlone Street', 'Male'),
    ('Derpina', 'Whiterun Breezehome', 'Female')

Select * FROM testTable

So how do I execute the CREATE TABLE, INSERT INTO and the SELECT queries by one click?

Upvotes: 33

Views: 82691

Answers (2)

Weijing Jay Lin
Weijing Jay Lin

Reputation: 3238

You could use Ctrl+Shift+Enter to run everything with semicolon end.

For Mac ⌘+shift+return

Upvotes: 57

bfavaretto
bfavaretto

Reputation: 71939

Add a semicolon after each statement:

CREATE TABLE testTable(
    Name VARCHAR(20),
    Address VARCHAR(50),
    Gender VARCHAR(10)
);

INSERT INTO testTable
VALUES
('Derp', 'ForeverAlone Street', 'Male'),
('Derpina', 'Whiterun Breezehome', 'Female');

SELECT * FROM testTable;

Upvotes: 32

Related Questions