2011/6/6 Jean-Christophe Deschamps <j...@antichoc.net>:

>>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"


Or, what you can also do is use table names such as

no_special_chars

and/or

do_not_distinguish_between_caps_and_lower_case_in_designing_system

?


Paul...


-- 

lineh...@tcd.ie

Mob: 00 353 86 864 5772
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to