How to go to next statement in MySQL if current statement fails?

Question

I run few drop and alter statements in MySQL workbench. How to skip to next statement when current statement fails ?

I am looking for a GO keyword equivalent of MSSQL server in MySQL

score 0 · Answer 1 · answered Sep 20 '18 at 05:51

0

Use a semicolon (;). It will separate your statements.

answered Sep 20 '18 at 05:51

Fahmi

score 0 · Answer 2 · answered Sep 20 '18 at 06:33

Which MySQL Workbench version you are using?

I am posting 2 options here: In MySQL Workbench, just un-check the option under Query to "Stop Script Execution on Errors":

and in a newer versions use 'Toggle whether execution of SQL script should continue after failed statements'

For details you can be found here

Pratik Dekate · Answer 3 · 2018-09-20T07:32:43.850

-1

In MySQL Workbench, you can untick the option under Query to "Stop Script Execution on Errors": Following link may help you.

edited Sep 20 '18 at 07:32

answered Sep 20 '18 at 05:57

Pratik Dekate

The link is to another answer on SO, not to an external website. I think that is fine to keep. – dubes Sep 20 '18 at 07:40

3 Answers3