Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    5

    Unanswered: Order of Insert ?

    When I insert raw into the table, and then select * from table. There is NO SQUENCE how I insert to the table. It inserts the table in chaotic way.
    I was looking into MySQL manual and there is no specification when the new raw is added. (in what sequence).

    Any ideas, how MySQL handels insert ?


    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    if you want the rows in a specific sequence, use ORDER BY

    rudy
    http://r937.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •