Hello Brown, Dave,
I don't receive any errors executing your SQL script with my SQLiteSpy database
explorer, which uses version 3.2.2 of the SQLite library.
Maybe you have accidentally inserted a newline into your script which
terminates the "--" comment?
Regards,
Ralf
PS: SQLiteSpy home: ht
The problem seems to be that sqlite is not recognizing
as a comment terminator (unless the comment
is alone on a line). I think you should write a bug
ticket; meanwhile, the work-around is to end your
comment with a semicolon.
sqlite> select * from t1; -- comment
...>
...> ;
a c
I have a text file called "test.sql" which has the following two commands:
CREATE TABLE preference
(
name TEXT UNIQUE NOT NULL,
value TEXT
);
INSERT INTO preference (name, value) VALUES( 'test1', 1024 ); -- test
comment
Now I run sqlite3 to create the database:
C:\Temp\SQLite>s
3 matches
Mail list logo