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?
1Answer
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;
- answered 8 years ago
- B Butts
Your Answer