At 13:55 16/05/2012, you wrote:
´¯¯¯
Those all work. You are getting an error because you didn't supply any
column in the table
`---
Oops, that's what happens when you try doing too many things at the
same time.
Nonetheless,
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]] ?] (a);
Error: unrecognized token: "]"
It would be logical to have ]] represent a single ] (standard escape by
doubling), while [[ would be left as [[ since there's ne need to escape
the opening bracket [.
But yes, this one works:
sqlite> create table `foo ``bar`` ?` (a);
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users