On Mon, Jun 6, 2011 at 6:14 AM, Jean-Christophe Deschamps <[email protected]>wrote:
> > >What is the official way to escape table name that contains a space > >and column name that contain a spaces? > > You can use square brakets or double-quotes: > > [This is a long name for a small table] > "This is a long name for a small table as well" > > Double-quotes is the official (portable) SQL way of quoting identifiers. Square bracket quoting is provided by SQLite for compatibility with SQL Server. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
