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 a collection of rows, like marbles in a bag. It is quite correct for any SQL engine to do this: SELECT name,phone FROM contacts; --> all rows appear SELECT name,phone FROM contacts; --> same rows in different order Unless you specify a sort order using ORDER BY you cannot complain about the order SQL returns your rows. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users