How to correct syntax error created by using escape for single quote (\') in sqlite3
by pizzipie from LinuxQuestions.org on (#4V843)
I am trying to use an INSERT statement in an sqlite3 database that came from MySql.
Code:INSERT INTO `pdata` (`id`, `First`, `Last`, `Name`, `CatId`, `Sub`, `Location`, `Phone`, `Cell`, `Email`, `Notes`) VALUES
(3, 'Beth', 'Jean\'s Friend', 'Jean\'s Friend, Beth', 6, 0, '', '208.255.8015', '', '', 'Jeans Friend');The escapes (\') create syntax errors in sqlite3.
How do I get around this in sqlite3? I am trying to Code:.read insertpdata.sql The file insertpdata.sql was created by phpmyadmin.
Thanks for your help in advance.
R
Code:INSERT INTO `pdata` (`id`, `First`, `Last`, `Name`, `CatId`, `Sub`, `Location`, `Phone`, `Cell`, `Email`, `Notes`) VALUES
(3, 'Beth', 'Jean\'s Friend', 'Jean\'s Friend, Beth', 6, 0, '', '208.255.8015', '', '', 'Jeans Friend');The escapes (\') create syntax errors in sqlite3.
How do I get around this in sqlite3? I am trying to Code:.read insertpdata.sql The file insertpdata.sql was created by phpmyadmin.
Thanks for your help in advance.
R