[Phpmyadmin-devel] strange " bug

7 Aug
2001
7 Aug
'01
7:43 p.m.
Hello, Step 1 : CREATE TABLE `test` (`id` VARCHAR(50) not null, `txt` VARCHAR(50) not null , PRIMARY KEY (`id`), INDEX (`id`)); INSERT INTO `test` (`id`, `txt`) VALUES ('1', 'test "test" test'); Step 2 : Use phpmyadmin to Select id 1 (using tbl_select.php3), Click Edit (do nothing) then click save. <phpmyadmin> SELECT `id`,`txt` FROM `test` WHERE 1 AND `id` LIKE \"1\" LIMIT 0, 30 MySQL said: You have an error in your SQL syntax near '\"1\" LIMIT 0, 30' at line 1 </phpmyadmin> No problem if you key is an int. Yuk. Regards, Alain.
8807
Age (days ago)
8807
Last active (days ago)
0 comments
1 participants
participants (1)
-
Alain Brissaud