Re: Semicolon cannot terminate the statement
How strange ... I copied and pasted from your post and it worked OK. This is the standard install of SQLite on Precise (12.04).
Long shot: What keyboard layout and character set are you using?
$ sqlite3 temp.sqlite
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table artist (ID INTEGER PRIMARY KEY,Artist_name TEXT);
sqlite> insert into artist values(NULL,'hong');
sqlite> select * from artist;
What happens with the standard install version of SQLite?
Please create new threads for new questions.
Please wrap code in code tags using the '#' button or enter it in your post like this: [code]...[/code].