Re: [sqlite] ORDER BY is ignored during INSERT INTO

2019-08-25 Thread Simon Slavin
On 25 Aug 2019, at 10:09pm, André Borchert <0xa...@gmail.com> wrote: > I try to copy one table into a second identical one. Once the second table is > created I want to move the content over sorted by ASC. It's worth noting here that the rows of a table do not have any order in SQL. A table is

Re: [sqlite] ORDER BY is ignored during INSERT INTO

2019-08-25 Thread Keith Medcalf
linglists.sqlite.org] On Behalf Of André Borchert >Sent: Sunday, 25 August, 2019 15:10 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] ORDER BY is ignored during INSERT INTO > >Hello, > >I try to copy one table into a second identical one. Once the second >table >

[sqlite] ORDER BY is ignored during INSERT INTO

2019-08-25 Thread André Borchert
Hello, I try to copy one table into a second identical one. Once the second table is created I want to move the content over sorted by ASC. The issue is that the ORDER BY statement gets ignored during a INSERT INTO: INSERT INTO CompanyDetails2 SELECT * FROM CompanyDetails WHERE CompanyDetails.ID