Sorry, that was the result of my genericizing the code. The code I have does not have the trailing comma.
On Fri, Mar 13, 2009 at 9:03 PM, Igor Tandetnik <[email protected]> wrote: > "Rand Huck" <[email protected]> wrote in > message > news:[email protected]<news%[email protected]> > > CREATE TABLE `tbl` ( > > `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, > > `title` varchar(255), > > `body` text, > > `isRead` integer(1), > > `isExpired` integer(1), > > `isReminder` integer(1), > > ); > > Remove the last comma, one right before the closing paren. > > > INSERT INTO `tbl` (`id`, `title`, `body` > > `isRead`, `isExpired`, `isReminder`) SELECT > > `id`, > > `title`, > > `body`, > > CASE WHEN `status` = 'viewed' THEN '1' ELSE '0' END AS `isRead`, > > CASE WHEN `status` = 'expired' THEN '1' ELSE '0' END AS `isExpired`, > > CASE WHEN `status` = 'reminder' THEN '1' ELSE '0' END AS `isReminder`, > > FROM `tbl_backup`; > > Same here - remove the comma before FROM. > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
