The problem is that you are using unusual quotes. Use only standard double-quotes for identifiers and single-quotes for strings. Your example uses "fancy" quotes commonly seen in word processors.
----- stephan Sent from a mobile device, possibly from bed. Please excuse brevity, typos, and top-posting. On Jan 21, 2016 14:18, "DONALD LEUNG" <donuld at icloud.com> wrote: > hello, > > .read name.sql has a bug for mac os x 10.10 for the latest edition of > SQLITE on Jan 20th > > > I can confirm that I have created table C. > > > INPUT > > From Script.sql in home folder with database.db file > > INSERT INTO "C? (Names) VALUES (?Al?); > INSERT INTO "C? (Names) VALUES (?Ale?); > > > > OUTPUT: > > copying and pasting into sqlite3 error > > Error: near line 1: no such table: ?C? > Error: near line 2: no such column: ?Al? > Error: near line 3: no such column: ?Ale? > Error: near line 4: no such column: ?Andy? > Error: near line 5: near "?": syntax error > Error: near line 6: no such column: ?Anti' > Error: near line 7: no such column: ?Atina? > Error: near line 8: no such column: ?Armen? > Error: near line 9: no such column: ?Austy? > Error: near line 10: no such column: ?Azer? > Error: near line 11: > Error: incomplete SQL: INSERT INTO "C? (Names) VALUES (?Candy?); > > > > ????? > Another thing is when I copy and paste from OS X sqlite3, the script: > INSERT INTO ?C? (Names) VALUE (?names?); > > the paste looks turns out different, and becomes INSERT INTO ?C? (Names) > VALUE );?names? ( > > Please tell me what to do and how to fix. > > > d > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
