@sqlite.org
Subject: Re: [sqlite] Selecting a group of entries based on RowID.
On Tue, 7 Dec 2010 10:44:31 -0800, Kirk Clemons
<k...@chiefarchitect.com> wrote:
>I would like to select each row in order from a table without getting the
>table information as well.
>This way I
I would like to select each row in order from a table without getting the table
information as well.
This way I can insert them into another database with the same tables.
How would I do this?
Thank you,
Kirk.
___
sqlite-users mailing list
Not sure if it helps but I would see this quite frequently when an old journal
file would be left behind in the same directory as the backup database. This
could be why making a change to the database such as vacuum would prevent the
corruption.
___
@bigfraud.org> escreveu:
>
> On 26 Aug 2010, at 3:39pm, Kirk Clemons wrote:
>
> > SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE
> > _rowid_ = 101; SELECT * FROM myTable WHERE _rowid_ = 102;
>
> SELECT * FROM myTable WHERE _rowid_ BETWEEN 100 A
script help.
On 26 Aug 2010, at 3:39pm, Kirk Clemons wrote:
> SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE
> _rowid_ = 101; SELECT * FROM myTable WHERE _rowid_ = 102;
SELECT * FROM myTable WHERE _rowid_ BETWEEN 100 AND 102
or
SELECT * FROM myTable WHERE _rowid_
I have heard about SQL scripts that can automate some processes. Is it possible
to write a script that performs the following on an entire database?
SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE _rowid_
= 101; SELECT * FROM myTable WHERE _rowid_ = 102;
Regards,
Kirk
Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: Saturday, August 14, 2010 8:47 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Database.
On 13 Aug 2010, at 7:45pm, Kirk Clemons wrote:
> Is there a
Is there a way to parse my database by row id? In other words incase there is
an error I don't want SQLite stop parsing. I have bailing turned off but it
still does not continue on through the database when doing a 'select *' on each
row.
Regards
~Kirk.
I am trying to alter the dump function of the command line shell. I am not
completely familiar with C Programming so I am sort of in the dark here.
As I understand it's workings now the .dump command performs a 'select *' on
each row in row id order. If it encounters an error it skips to the end
sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: Thursday, August 05, 2010 4:40 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Repairing a Database.
On 4 Aug 2010, at 10:15pm, Kirk Clemons wrote:
> Also, does this mean that I could take
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Roger Binns
Sent: Tuesday, August 03, 2010 5:56 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Repairing a Database.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/02/2010 07:42 AM, Kirk Clemons wrote:
>
Also, forgot to mention that binary data will not normally work for csv format.
It's best to leave the settings at their default and do;
.mode list
.separator |
.output mytable.sql/.txt
.dump mytable
_
.read mytable.sql/.txt
~Kirk
-Original Message-
From:
.dump copies the insert statements from the table along with the data by doing
a 'select *'.
You will want to make sure you import or read the file with the same settings
as the .dump was done in.
.show will show the settings for mode, separator, etc.
To export to a csv from a table might look
There is the .read function which will read in a file that contains insert
statements. This is done through the shell.
~Kirk
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of john knops
Sent: Tuesday, August 03, 2010 6:53 AM
Thank you Roger,
I will look this over and see what I can do.
~Kirk
Kirk Clemons
Technical Support Analyst
Chief Architect(r)
6500 N. Mineral Dr.
Coeur d'Alene, Idaho 83815
Phone: (800)482-4433
(208)664-4204
Professional Software
www.chiefarchitect.com
Consumer Software
Thanks for your reply.
I was afraid that may be the case. This is for my application that uses an
SQLite database to store 3D data so it would be difficult to find out which set
of binary data is corrupt and which is not.
I do encourage my clients to backup the database, it is even
stored in
and corrupted the database.
I have seen some information on repairing a corrupt database and recovering at
least some of the data. But I have not had any luck finding out how to do it.
Any help would be greatly appreciated.
Kirk Clemons
Technical Support Analyst
Chief Architect(r)
6500 N. Mineral Dr
17 matches
Mail list logo