Can I add a column name containing a dash "-" and if yes, how would I do that?
I am asking because I fail to add a column name that contains a dash "-" and I don't know if I cause the problem (easy solution) or if its something else causing this to fail. Here's what I try: sqlite> create table test(column-1 varchar(255)); SQL error: near "-": syntax error So far I have had a look at the SQLite documentation, but couldn't find anything that would tell me about 'reserved' characters or how I would escape a dash. Thanks, p...@rick -- state of mind Digitale Kommunikation http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3090 4664 81669 München Telefax +49 89 3090 4666 Amtsgericht München Partnerschaftsregister PR 563 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users