[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Adding data with periods
From:       "P Kishor" <punk.kish () gmail ! com>
Date:       2008-12-15 5:14:59
Message-ID: cdf6db500812142114l1b93eedalc2dd3e6237309f15 () mail ! gmail ! com
[Download RAW message or body]

On 12/14/08, aditya siram <aditya.siram@gmail.com> wrote:
> 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
>


many errors in the above. The correct syntax would be

sqlite> INSERT INTO test_table VALUES ('hello . world');

note the keyword VALUES, and the text string delimited with single
quotes, not double quotes.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]