[sqlite] make sqlite3_analyzer No rule to make target `sqlite3_analyzer'. Stop.

Hi! I can't seem to use the sqlite3_analyzer on my MacBook Pro 2010 i7. Following the instructions in the book 'The Definitive Guide To Sqlite', to analyze the test.db all I have to do is issue the command 'sqlite3_analyzer test.db'. This command unfortunately gives me the response '-bash:

[sqlite] how to merge this three command in c++

This follow 3 commands,I wanna merge to c++,but don't know how to do: sqlite3 my.db " select '' " > my.html sqlite3 -html -header my.db " select * from BOD " >> my.html sqlite3 my.db " select '' " >> my.html is this follow right? char bbb[300]; strcpy(bbb,"BEGIN\n " select '' " > my.html\n \

Re: [sqlite] Primary Key uniqueness

On 03/29/2012 06:27 PM, Joe Bennett wrote: > Hi, > > I have three sqlite3 datbases that currently have no primary key (actually > done with two and stuck on the third). I am converting them to 'new' tables > with a primary key like so: > > create table if not exists new_table >

[sqlite] Positioned Read/Write for Windows

Hi, recently I noticed the use of positioned Read/Write in the unix vfs. In Windows this can be achieved by providing an offset in an OVERLAPPED structure. I tried it and found a small but notable increase in throughput, especially during reads when most of the db is in the system cache.

Re: [sqlite] Primary Key uniqueness

Try omitting 'rowid' - you are not grouping by it and if you did it is unique so no dups. select Column_1,Column_27,Column_47 , count(*) from old_table group by Column_1,Column_27,Column_47 having count(*) > 1 JG On 29 March 2012 17:27, Joe Bennett

Re: [sqlite] Primary Key uniqueness

On 29 Mar 2012, at 5:27pm, Joe Bennett wrote: > No rows meet this criteria... So, I'm looking for a better way to find the > non unique data in the old_table so I can clear this error and insert it > into the new table... Any ideas? Instead of using the plain INSERT ...

[sqlite] Primary Key uniqueness

Hi, I have three sqlite3 datbases that currently have no primary key (actually done with two and stuck on the third). I am converting them to 'new' tables with a primary key like so: create table if not exists new_table (Column_1,Column_2,Column_3..,Column_47, primary key(Column_1,

Re: [sqlite] xBestIndex/xFilter Bug(?) when using LIKE "F%"

On 03/23/2012 03:59 PM, Kurt Keller wrote: I have a virtual table implementation, that implements the xBestIndex/xFilter funktions and I found the following problem: This query SELECT * FROM vf WHERE field LIKE "F%"; will result in a call to xBestIndex with the following constraint

Re: [sqlite] how to add time in a new column

On 29 March 2012 12:36, Black, Michael (IS) wrote: > You'll need to export the table and data.  Change the SQL to what you want. > Then import again. > > Does the shell have ability to name the columns on the insert  statements > from the .dump to make this easier?  I

Re: [sqlite] In-memory and temporary database

At 11:32 28/03/2012, you wrote: Hello, I'm doing some test with SQlite 3.7.11 in Windows Embedded industrial PC. I need to store data in a table very quickly. Let's say new data each 10 msec. I tryed with DB on disk but obviously was not possible to reach the correct performance. So I tryed

Re: [sqlite] how to add time in a new column

You'll need to export the table and data. Change the SQL to what you want. Then import again. Does the shell have ability to name the columns on the insert statements from the .dump to make this easier? I don' t see anythinig offhand that seems to do that. Michael D. Black Senior

Re: [sqlite] how to built xml file from sqlite database?

On 29 Mar 2012, at 5:17am, YAN HONG YE wrote: > how to built xml file from sqlite database? No function built into SQLite to do this. You can write your own software to read the data and make up the XML format from it. Simon.

Re: [sqlite] how to add time in a new column

On Thu, Mar 29, 2012 at 1:43 AM, YAN HONG YE wrote: > sqlite> alter table dzh add mtime NOT NULL DEFAULT CURRENT_TIME; > Error: Cannot add a column with non-constant default > ___ > http://www.sqlite.org/lang_altertable.html The