Error running script containing quotes and semicolons
| User, date | Message |
|---|---|
|
Written by akovar
3 years ago Category: Running SQL scripts 2 posts since Thu, 27 May 10 |
Let's have simple table here: CREATE TABLE `temp_test` ( When I'm trying to change the 'text' column using Query window in HeidiSQL it fails. (F9 command) UPDATE `temp_test` SET `text`='<span style="text-decoration: underline;">' WHERE `id`=1; The same command succeeded when I'm changing values in data grid in HeidiSQL. Please see screenshot here: [/url] In log window you can see the correct statement when I used data grid for changing value (line 30) and the error when I tried to use Query window (line 31) The same command has worked fine in MySQL Command Line Client: [url=http://picasaweb.google.com/107916404888365403566/HeidiSQL#5475961157226095234] Please help. A. |
|
Written by ansgar
3 years ago 4027 posts since Fri, 07 Apr 06 |
That's a bug in the SQL splitter - your query end is detected at the semicolon. Damn, should have been fixed by r3346 but obviously is not working 100%. |
|
Written by ansgar
3 years ago 4027 posts since Fri, 07 Apr 06 |
Fixed in r3351 |
|
Written by akovar
3 years ago 2 posts since Thu, 27 May 10 |
Yes, it's working now. Thank you |
|
Please login to leave a reply, or register at first. |