Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

"Run Current Query" doesn't work after semicolon

biao's profile image biao posted 2 months ago in Running SQL scripts Permalink

Hello

If I put cursor after ; and click "Run Current Query", the query won't run.

SHOW PROCESSLIST;|

If I put cursor before ; and click "Run Current Query", query is executed as expected.

SHOW PROCESSLIST|;

It's not convenient sometimes as I have to move the cursor to run the statement. Is it by design?

Thanks

Biao

ansgar's profile image ansgar posted 2 months ago Permalink

Placing the cursor behind the semicolon shifts the current query to the one behind it. This is intentionally.

biao's profile image biao posted 2 months ago Permalink

I prefer the query console to follow the convention of mysql cli :)

biao's profile image biao posted 2 months ago Permalink

select 1; | select 2;

select 1; select 2;|

both run the all statements

ansgar's profile image ansgar posted 2 months ago Permalink

both run the all statements

If you want to run all queries, just press F9, or click "Run".

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.