[Squirrel-sql-users] Problem while executing batch with escaped quot
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Serega S. <ser...@gm...> - 2010-01-03 10:15:12
|
Hello, it's really nice to use Squirrel. Please, help me solve such problem: I often execute batch of queries: INSERT INTO `abstract_items` VALUES ('96', 'Girls Just Want to Play', 'Lacquer', '0', '97', '15', '330', '', '0', '6', '', '1', null, '0'); INSERT INTO `abstract_items` VALUES ('97', 'Glitter Bit of Music Top Coat', 'Lacquer', '1', '98', '15', '330', '', '0', '6', '', '2', null, '0'); INSERT INTO `abstract_items` VALUES ('98', 'Goldilocks Rocks', 'Lacquer', '1', '99', '15', '330', '', '0', '6', '', '2', null, '0'); INSERT INTO `abstract_items` VALUES ('99', 'Have a Tempura Tan-Trum', 'Lacquer', '1', '100', '15', '330', '', '0', '6', '', '1', null, '0'); INSERT INTO `abstract_items` VALUES ('100', 'Don\'t Be Koi with Me', 'Lacquer', '0', '101', '15', '330', '', '0', '6', '', '1', null, '0'); INSERT INTO `abstract_items` VALUES ('101', 'Don\'t Toy With Me', 'Lacquer', '0', '102', '15', '330', '', '0', '6', '', null, null, '0'); 97..101 are primary keys as you can guess. As you can see, record with id=100, 101 has escaped \' when I execute list of queries, Squirrel executes 1..100 but it stops on SQL id=101. with an error message: INSERT INTO `abstract_items` VALUES ('101', "Don't Toy With Me", 'Lacquer', '0' at line 1 SQLState: 42000 ErrorCode: 1064 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; I can select only one line with id=101, it executes, and then continue to execute list of queries. Why does Squirrel stop after first sql-query with escaped special char? |