What is the equivalent of 'go' in MySQL?

Question

In TSQL I can state:

insert into myTable (ID) values (5)
GO
select * from myTable

In MySQL I can't write the same query.

What is the correct way to write this query in MySQL?

Answer 1

Semicolon at the end of the line.

INSERT INTO myTable (ID) values (5); 

Answer 2

The semicolon is the default delimiter. You can however redefine it to whatever you want with the DELIMITER keyword. From the MySQL manual:

mysql> delimiter //

mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
    -> BEGIN
    ->   SELECT COUNT(*) INTO param1 FROM t;
    -> END;
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

mysql> CALL simpleproc(@a);
Query OK, 0 rows affected (0.00 sec)

This is not limited to stored procedure definitions of course.