fastmac:/applications/sqlite rn$ ./sqlite contacts SQLite version 2.8.13 Enter ".help" for instructions sqlite> Create Table Company ( ...> Company Name Character (50) NOT NULL, ...> Contact Name Character (35), ...> Address1 Character (30), ...> Address2 Character (30), ...> City Character (30), ...> State Character (2), ...> Zip Character (10), ...> Phone1 Character (13), ...> Phone2 Character (13), ...> Fax Character (13) ) ; SQL error: near ".": syntax error sqlite>
It would appear, the sqlite does not follow the sql rules of syntax ? or is there something I'm doing wrong?
TKS - Rick