On Wed, May 16, 2012 at 2:47 PM, Jean-Christophe Deschamps <j...@antichoc.net > wrote:
> > > This FAQ topic doesn't apply here. We're talking about schema names or >> keywords, while FAQ#14 is literal escaping a single quote. >> >> create table "foo""bar" ( baz ); >> >> select * from "one""two"; >> >> select * from sqlite_master; >> >> table|foo"bar|foo"bar|9|CREATE TABLE "foo""bar" ( baz ) >> > > I knew this particular escape worked, granted, but this isn't documented. > > But even then: > > SQLite version 3.7.11 2012-03-20 11:35:50 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table [foo [[bar]] ?]; > Error: unrecognized token: "]" > sqlite> create table `foo ``bar`` ?`; > Error: near ";": syntax error > sqlite> create table `foo ``bar ?`; > Error: near ";": syntax error > > So some questions remain: what are the definitive rules? > Those all work. You are getting an error because you didn't supply any column in the table -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
