Is it possible to have automatic index ID field in SQLite3?, I would like to
have access to an index in my database...
Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
At 02:27 04/02/2008 +0100, Gilles wrote:
>Thanks for the tip, but I tried that too, with no success:
I tried both:
sqlite> .separator "\t"
sqlite> .import test.csv customer
test.csv line 1: expected 3 columns of data but found 4
sqlite> .separator '\t'
sqlite> .import test.csv customer
test.csv
At 23:42 03/02/2008 +, Robert Wishlaw wrote:
>Instead of
>
>.separator "\t"
>
>try
>
>.separator '\t'
Thanks for the tip, but I tried that too, with no success:
# cat test.csv
NULL123-4567John Doe
(Note: I just replaced 09 with to show you)
# sqlite3 db.sqlite
SQLite version 3.5.4
Enter
I have very simple db. Everything works ok when I use Latin letters,
but when I use the Cyrillic ones - text doesn't look OK anymore.
DB table structure sample:
id - integer primary key
inv_numb - varchar(10) not null unique
name - varchar(40) not null
price - float(15)
HTML code is UTF-8
Noticed that sqlite_stat1 can have duplicates on tbl, idx:
tbl idx stat
---
table1 idx190 2 1
table1 idx290 2
table1 idx12577 2 1
table1 idx22577 2
Is there any harm in this, so would SQLite know that it has to look at the
last
At 18:33 31/01/2008, you wrote:
>The big change from version 3.5.4 is that the internal virtual
>machine was reworked to use operands in registers rather than
>pulling operands from a stack. The virtual machine stack has
>now been removed. The removal of the VM stack will help prevent
>future
"RB Smissaert" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> Running a query like this:
>
> delete from sqlite_stat1
> where
> not tbl in
> ('table1', 'table2', 'table3')
>
> The strange thing is that rows are deleted where tbl is one of the
> listed tables.
Look carefully at the
SQLite 3.5.4, Win XP, VBA with the wrapper dhRichClient
Running a query like this:
delete from sqlite_stat1
where
not tbl in
('table1', 'table2', 'table3')
The strange thing is that rows are deleted where tbl is one of the listed
tables.
Have tried all kind of alterations, such as making it
Hello
I'm trying to import some TAB-separated records from a Windows host into a
Linux host, but it fails with "Error: datatype mismatch":
1. On Windows, converted file from Windows to Unix (ie. CRLF -> LF)
2. On Linux, download test.csv, and ran "sqlite3 db.sqlite"
3. sqlite> .schema
CREATE
Hello all,
Is it possible to prepare statement and use it for several databases
with identical schemas?
And is it possible to create statement, re-open database and then use
it again for same database?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
10 matches
Mail list logo