How to run multiple queries in row safely?

Question

I have the below queries and i can run them one by one successfully,

Delete from eventor.user_role ;
Delete FROM eventor.role ;
delete from eventor.user ;

but when i run all of them together, it complains with the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Delete FROM eventor.role ;

This is a surprise for me since, i can run the

 Delete FROM eventor.role ;

successfully, and i have terminated all the queries using ;.

So, why am i getting this, and how can i fix it?

Delete foreign key table first then finally delete master table data — Ali Azam, Nov 23 '17 at 10:26
May be try a batch separator like 'GO' in between the statements? — Niranjan Rajawat, Nov 23 '17 at 10:27
i am running the query directly against mysql, using `Aqua Data` — Jeff, Nov 23 '17 at 10:27

score 3 · Answer 1 · edited Oct 24 '19 at 17:09

3

From File, choose Options, then General
Check **';' Statement separator

edited Oct 24 '19 at 17:09

jnovack

7,629
2
26
40

answered Oct 24 '19 at 13:56

Mohammed Deifallah

1,290
1
10
25

score 1 · Accepted Answer · answered Nov 23 '17 at 10:37

According to http://www.aquafold.com/support_faq#commands:

Q: Scripts with multiple statements return errors, while each statement can be executed individually without errors.

Example:

select * from t1 select * from t2 select * from t3

This script returns errors.

Aqua Data Studio uses “go” or “/” symbols as line separators between statements.
Here is a corrected example of the same script:
select * from t1
/
select * from t2
/
select * from t3
or
select * from t1
go
select * from t2
go
select * from t3
go

Try using go or / instead of ;

How to run multiple queries in row safely?

2 Answers2