sqlite.org] On Behalf Of Dale Mellor
>Sent: Tuesday, 27 November, 2018 22:42
>To: sqlite-users@mailinglists.sqlite.org
>Subject: [sqlite] Bug? Confused data entry with column name
>
>>>>>>>>> THIS VERSION
>SQLite 3.25.3 2018-11-05 20:37:38
>89e099fbe5e
Use single quotes, not double. Double quotes are used for identifiers, not
strings, so that matches rows where id and description have the same value.
On Wed, Nov 28, 2018, 1:19 AM Dale Mellor THIS VERSION
> SQLite 3.25.3 2018-11-05 20:37:38
> 89e099fbe5e13c33e683bef07361231ca525b88f790
THIS VERSION
SQLite 3.25.3 2018-11-05 20:37:38
89e099fbe5e13c33e683bef07361231ca525b88f7907be7092058007b750alt1
zlib version 1.2.8
gcc-8.2.0
> THIS SCRIPT
create table test (id varchar, description varchar);
insert into test (id, description) values ("Description", "Duh");
ins
3 matches
Mail list logo