Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Thomas 'PointedEars' Lahn Newsgroups: comp.lang.php Subject: Re: Problem creating a series of tables Date: Fri, 03 Apr 2015 01:10:59 +0200 Organization: PointedEars Software (PES) Lines: 15 Message-ID: <1834737.PZRfAB79AP@PointedEars.de> References: <1957209.MyoqzTBkhW@PointedEars.de> <1928459.l4EcNPIvok@PointedEars.de> Reply-To: Thomas 'PointedEars' Lahn Mime-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8Bit X-Trace: solani.org 1428016378 1144 eJwFwYEBwDAEBMCVEP8Ypxr2HyF3OFT+4QQdiz3VGtZ7r4/0mFstqDG1WUkR021GwhFfZD0XqBBi (2 Apr 2015 23:12:58 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Thu, 2 Apr 2015 23:12:58 +0000 (UTC) User-Agent: KNode/4.14.2 X-User-ID: eJwNwQkBwDAIBDBLvEeRU6D4l7AlrmB0GBzm67vxRFydubJnQmNr5BGh9Q1n055FsRAIGfQbHONqu9R+P0zJFRU= Cancel-Lock: sha1:QlfqUSlgClbVRS0+/OhPDDLPrtg= X-NNTP-Posting-Host: eJwNxcEBwCAIA8CVVJK0rBOE/Udo73MMbdUDUeBwpMm5iPRqVJzJTjf3+ouCgXPavpJfF/0BJy8RyA== Xref: csiph.com comp.lang.php:15194 Richard Yates wrote: > Interesting. InnoDb pulls them out in order of the primary index. > MyISAM pulls them in the order that they went in. I cannot reproduce that. The same table, using MyISAM as database engine instead, yields the same results as in : Never once is the “1” at first position. -- PointedEars Zend Certified PHP Engineer Twitter: @PointedEars2 Please do not cc me. / Bitte keine Kopien per E-Mail.