[sqlite] Copying the content of a table to another table

Hi all, I have created a table with two columns c1 and c2 and inserted some values into,in future i may include some additional columns c3,c4. to the same table.In tat case i should not loose my data in the current table,so i should be able to copy the content of the current

RE: [sqlite] Copying the content of a table to another table

Thanks i ll check it out.. -Original Message- From: Lloyd [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 05, 2007 1:37 PM To: Kirrthana M Cc: sqlite-users@sqlite.org Subject: Re: [sqlite] Copying the content of a table to another table create table x(c1 number,c2 number); create table

RE: [sqlite] command

Update can be used to replace a text with some new text. To delete a particular row use 'where' command along with 'delete'. -Original Message- From: nishit sharma [mailto:[EMAIL PROTECTED] Sent: Thursday, August 30, 2007 4:04 PM To: sqlite-users@sqlite.org Subject: [sqlite] command i

RE: [sqlite] compiling

I think you have not included header file "sqlite3.h" in your code,if u have not included include and compile again. -Original Message- From: nishit sharma [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 12:45 PM To: sqlite-users@sqlite.org Subject: [sqlite] compiling hi all, i

RE: [sqlite] running code

Your test1.o with 2 arguments first will be the name of the database and the second will be some sql command to be executed. -Original Message- From: nishit sharma [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 5:13 PM To: sqlite-users@sqlite.org Subject: [sqlite]

RE: [sqlite] beginner

In the sql query use AND operator for the two columns you want to compare. Ex:select * from table_name where col1=="value" AND col2 == "value"; -Original Message- From: nishit sharma [mailto:[EMAIL PROTECTED] Sent: Monday, September 03, 2007 3:41 PM To: sqlite-users@sqlite.org Subject:

[sqlite] Checking out the performance of sqlite3

Hi all, I just want to compare the performance of sqlite on various os and in embedded, Just want to know the time it takes to read and write data,can anybody give me a suggestion of how to do this. Regards Kirrthana The information contained in this electronic message and any attachments to

[sqlite] Getting the no of rows using count(*)

Hi all, Im using the query Select count(*) from table to get the no of rows in the table in my c code. In the command line it will print the no of rows ,but in my c code how can i get the result, should i use prepare and step in this case and where the result of the query will be stored on

RE: [sqlite] Getting the no of rows using count(*)

nt64(ppStmt ,0); } sqlite3_finalize( ppStmt ); This should do it -- Bharath On 1/31/08 11:00 AM, "kirrthana M" <[EMAIL PROTECTED]> wrote: > Hi all, > > Im using the query Select count(*) from table to get the no of rows in the > table in my c code. > In the command line it wi

[sqlite] how to use the query select with sqlite3_exec

Hi, Im new to sqlite,i have written a program to create a table and perform the following operations Insert,Delete,search. To perform a search i used the query SELECT along with sqlite3_exec..Execution is successful but the result is not displayed in the screen.how to retrieve the result.Give me

[sqlite] Usage of special characters in insert query

Hi, In my query for inserting values into the database i have a statement as given below insert into table_name values('I haven't done that'); table is created with this option create table table_name(str varchar(20)); when the insert statement is executed it gives the error in haven't,It is

[sqlite] Sqlite3 in MAC Os

Hi everybody, Im developing an application using sqlite3 in MAC OS,I just wanted to know wheather sqlite3 can be used in MAC OS.If so can the same sqlite3 library and the executable used in windows can be used in MAC OS or a different version has to be used. Regards, Kirrthana

[sqlite] retrieving data from multiple tables

Hi all, I have created a database with four tables,i have to search and retrieve data from all the four tables based on the entry i get from the previous table and display all the entries,could anybody tell how to do it. Regards Kirrthana

RE: [sqlite] retrieving data from multiple tables

I have four tables like Mytable1,Mytable2,Mytable3,Mytable4 Mytable1 and Mytable2 have one similar field rest al different, Mytable2 and Mytable3 have one similar field rest al different, Mytable3 and Mytable4 have one similar field rest al different, i have to select from four tables by matching

RE: [sqlite] retrieving data from multiple tables

By getting the search string from previous table im not only retrieving data from the table4,at each step i have to retrieve data from 3 tables and store it in the data structure. -Original Message- From: T [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 14, 2007 3:35 PM To: