Stefan, Do you imply that tables cannot be sorted desc or asc based on one of the columns e.g. a last name? or am I misunderstanding you.
Albert Atlanta (anyone else in Atlanta?) ----- Original Message ----- From: "Stefan Kuhn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 6:57 AM Subject: Re: insert ... select .. order by, problem > Hi, > I think you can't do this. There is no order in the table, so there is no > point in using order by with insert. You always have to do this when > retrieving the records (the order you get with select without order by is > accidential). > HTH > Stefan > > Am Tuesday 02 September 2003 11:49 schrieb Alejandro Paz: > > Hi Stephan, > > > > Let's see the case : > > > > I use ORDER BY, because I want that order in PTemp > > table, so I do not have to order them later (because > > they are retrieved several times later). > > > > 1. Inserting with mysql c.l.i. : > > > > I get the records well sorted : first by a, secondly > > by b and finally by c (ascendig order). I'm using d to > > relink both tables in a join. > > > > 2. Inserting with the application : > > > > I get the records well sorted : first by a, secondly > > by b and finally by c, but in descending order. As all > > records has the same value in a, so the records that > > in case 1 start with '0' are at the beginning, the > > same records here are at the end. I'm using d to > > relink both tables in a join. > > > > I thought that was clear when I said reverse order, > > sorry. > > > > So you see what I mean ? > > > > thanks ! > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site design software > > http://sitebuilder.yahoo.com > > -- > Stefan Kuhn M. A. > Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) > Zülpicher Str. 47, 50674 Cologne > Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 > My public PGP key is available at http://pgp.mit.edu > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]