distal-attribute
distal-attribute
distal-attribute
distal-attribute

Error running script containing quotes and semicolons

akovar posted 5 years ago in Running SQL scripts
Let's have simple table here:

CREATE TABLE `temp_test` (
`id` INT(10) NOT NULL DEFAULT '0',
`text` TEXT NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
ROW_FORMAT=DEFAULT



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.

ansgar posted 5 years ago
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%.
ansgar posted 5 years ago
Fixed in r3351
akovar posted 5 years ago
Yes, it's working now.
Thank you

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