-----Original Message-----
From: Josh Hunsaker
On Fri, Apr 7, 2017 at 3:02 PM, Richard Hipp wrote:
On 4/7/17, Tony Papadimitriou wrote:
sql xxx.db "CREATE TABLE xxx(`time zone`)" "insert into xxx values('1')"
sql .dump xxx.db | sql
I'm unable to repro.
Is this possibly because the shell that Tony is using is evaluating `time
zone`?
I can repro, but in my case, the obvious cause is that the `time zone`
portion gets evaluated to an empty string.
Well, try this instead:
sql xxx.db "CREATE TABLE xxx(`a b c`)" "insert into xxx values(1)"
The problem is the column has spaces and it's not quoted.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users