-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 07/27/2010 05:48 AM, Gilles Ganault wrote:
> Found it: For newbies like me... "table" is a reserved name so cannot
> be used as a name to table:
You can if you quote it. Note use double quotes to quote table & column
names, single quotes for strings. You can also quote names using square
brackets - eg [table name].
create table "table"(...)
Heck SQLite even lets you create tables and columns with zero length names.
This works:
create table ""("" "");
Obviously I wouldn't recommend doing that, nor using reserved names :-)
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkxPxoEACgkQmOOfHg372QSzjQCggSYL4xSQVUG83Cfz7N1XFCnc
absAoKipjx0W6L6w4TIhXM9KWmhFRgn6
=u0Bs
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
