The syntax is wrong.
INSERT INTO TEST_TABLE(CONTENTS) VALUES ("Hello. World!");
is the correct one.
-radzi-
----- Original Message -----
From: "aditya siram" <[email protected]>
To: <[email protected]>
Sent: Monday, December 15, 2008 1:04 PM
Subject: [sqlite] Adding data with periods
> Hi all,
> I'm having trouble adding data with period characters in it. I tries to
> escape the period with a `'` but that didn' t seem to work. Here is an
> example interaction:
>
> sqlite> create table test_table ("Contents" varchar);
> sqlite> insert into test_table "hello . world";
> SQL error: near ""hello . world"": syntax error
> sqlite> insert into test_table "hello '. world";
> SQL error: near ""hello '. world"": syntax error
>
> Thanks ...
> deech
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
