> 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?
JcD
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
