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]
