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.

Find command line number from error message

kip@wfrc.org's profile image kip@wfrc.org posted 1 month ago in Running SQL scripts Permalink

Error message says there is a syntax error on command #141. I have 1,000 lines of code with 160 commands. There must be any easy way to find command #141 (not line of code #141) without counting each semicolon!?

ansgar's profile image ansgar posted 1 month ago Permalink

Normally the editor should set the cursor to the exact position of the error. But I recently fixed some things in that feature, plus temporarily adding a red background. You need to update to the latest build to get that fix:

Description

Note that this only works if the queries execution is set to "one by one":

Description

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.