Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    28

    Unanswered: A Newbie-question about INSERT

    Hello!

    Im using JSP, MySql and Mysql Control Center.
    I'm a newbie of databases and got (I think) two simple questions.
    I want to sort my table by "rank". In MySql Controll Center there is an option "Order By" , under Alter Table Option, which I have set to "rank".
    My questions are:

    1) Everytime I edit my table I have to set "Order By" to rank because "Order By" is set to "Default", why does this occur?

    2) When I do an INSERT (a new row) it wont come last in my table even if "rank" is bigger. Should I write something special in my syntax if I want to order my table by "rank" when I do an INSERT, why is there an option "Order By" if it doesn't work? Or is that for something else?

    Thanks for helping me!
    Last edited by digital_storm; 01-06-04 at 15:38.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You might want to check in the MySQL Forum...


    http://www.dbforums.com/f5/
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Location
    Germany
    Posts
    17
    Originally posted by Brett Kaiser
    You might want to check in the MySQL Forum...


    http://www.dbforums.com/f5/
    This is already the MySQL-forum, isn't it?

  4. #4
    Join Date
    Dec 2003
    Posts
    28
    I also thougt that ?!?

Posting Permissions

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