#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Posts
    3
    Rep Power
    0
    Do MySQL tables have a row structure where assuming that no updates or other modifications are made, that a query will yield the same order on consecutive queries?

  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    No.
  4. #3
  5. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Not truly a coincidence but it is nothing you can rely on either. LIMIT is pointless unless you use an ORDER BY clause as well.

Similar Threads

  1. Replies: 3
    Last Post: February 11th, 2004, 09:30 AM
  2. Inserting multiple rows to mysql table
    By Roaddust in forum PHP Development
    Replies: 6
    Last Post: February 4th, 2004, 09:28 AM
  3. Replies: 1
    Last Post: January 30th, 2004, 07:04 PM
  4. how to keep table on top, not centered??
    By vinyl in forum HTML Programming
    Replies: 2
    Last Post: January 20th, 2004, 07:19 PM
  5. Validate PHP form and update MySQL table
    By tlugosi in forum PHP Development
    Replies: 2
    Last Post: January 18th, 2004, 03:26 PM

IMN logo majestic logo threadwatch logo seochat tools logo