Re: [sqlite] Minus sign in table name

D. Richard Hipp wrote: > > > On May 4, 2009, at 10:18 AM, bitzzz wrote: > >> >> I am converting an existing database to sqlite format, but I got the >> following problem: >> >> When I create a table name with a minus sign inside then the following >> column definitions are ignored. >> So: >>

[sqlite] Minus sign in table name

I am converting an existing database to sqlite format, but I got the following problem: When I create a table name with a minus sign inside then the following column definitions are ignored. So: CREATE TABLE 'TEST1-TEST' (TST TEXT); refuses to create the column TST in the table TEST1-TEST. The

Re: [sqlite] Minus sign in table name

On May 4, 2009, at 10:18 AM, bitzzz wrote: > > I am converting an existing database to sqlite format, but I got the > following problem: > > When I create a table name with a minus sign inside then the following > column definitions are ignored. > So: > > CREATE TABLE 'TEST1-TEST' (TST TEXT); >

Re: [sqlite] Minus sign in table name

bitzzz wrote: > I am converting an existing database to sqlite format, but I got the > following problem: > > When I create a table name with a minus sign inside then the following > column definitions are ignored. > So: > > CREATE TABLE 'TEST1-TEST' (TST TEXT); > > refuses to create the column