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 <itandet...@mvps.org> wrote: > "Rand Huck" <randh...@gmail.com> wrote in > message > news:d232e14b0903131800j53e59f56ic8e19b1d94bd7...@mail.gmail.com<news%3ad232e14b0903131800j53e59f56ic8e19b1d94bd7...@mail.gmail.com> > > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
