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.