How to execute multiple SQL queries in MySQL Workbench?

mysql, mysql-workbench, sql

Solution

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;

Problem

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?

Original source