2010/1/25 Patrick Ben Koetter <[email protected]>: > 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
C:\>sqlite3_6_20 SQLite version 3.6.20 Enter ".help" for instructions sqlite> sqlite> create table tst( "column-1" text ); sqlite> > > 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 > Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
