I can insert all rows of existing table into new table having same columns
using query :
Insert into NEWTABLE select * from OLDTABLE
But I want all rows of NEWTABLE sorted by field No,
So I used query
Insert into NEWTABLE select * from OLDTABLE order by no desc
But it is not giving me
: Paul Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 4:53 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Insert all rows from old table into new table but in
sorted order
I can insert all rows of existing table into new table having same columns
using query :
Insert
You can't do that.
The 'Insert' may (I'm not sure..) insert the data into 'NEWTABLE' in the
you misinterpreted my problem,
I want to add all rows of old table into new table but with sorted order
I don't want to fire another query (select * from newtable order by desc no
) to give sorted
On Thu, 2005-06-30 at 16:35 +0530, Ajay wrote:
So I used query
Insert into NEWTABLE select * from OLDTABLE order by no desc
But it is not giving me sorted output as new table?
Can you tell me where I am wrong ???
The ORDER BY clause on a SELECT used to insert into a table
has been
inserted.
_brad
-Original Message-
From: Ajay [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 8:21 AM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: RE: [sqlite] Insert all rows from old table into new table but
in sorted order
Yaa that's what I wanted to do , So what do
of the db to morph the data into whatever
views your heart desires.
-Original Message-
From: Steve O'Hara [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 5:28 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Insert all rows from old table into new table
but in
sorted order
not be the way they were
originally inserted.
_brad
-Original Message-
From: Ajay [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 8:21 AM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: RE: [sqlite] Insert all rows from old table into new table but
in sorted order
Yaa that's what
by no desc
_brad
-Original Message-
From: Ajay [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 9:38 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Insert all rows from old table into new table but
in sorted order
Seems to be top of my head, Is there any simple and sweet
Ok, it means that I can't do so !
-Original Message-
From: Brad DerManouelian [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 7:33 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Insert all rows from old table into new table but in
sorted order
My apologies for being long
the power of the db to morph the data into whatever
views your heart desires.
-Original Message-
From: Steve O'Hara [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 5:28 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Insert all rows from old table into new table
-return-6304-sohara=pivotal-
[EMAIL PROTECTED]
rg]On Behalf Of Puneet Kishor
Sent: 30 June 2005 14:09
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Insert all rows from old table into new table but
in sorted order
On Jun 30, 2005, at 7:21 AM, Ajay wrote:
Yaa that's what I wanted to do , So
rows from old table into new table but in
sorted order
I can insert all rows of existing table into new table having same columns
using query :
Insert into NEWTABLE select * from OLDTABLE
But I want all rows of NEWTABLE sorted by field No,
So I used query
Insert into NEWTABLE select * from
12 matches
Mail list logo