mysql table data question

Discussion in 'MySQL' started by komrad, Jan 7, 2009.

0
  1. #1
    Hello all,

    I'd like to know if there is a way to insert into a MYSQL table data in an ordered way?
    Right now as a workaround I've literally made a table of questions with questionID as primary key, nextQuestion and prevQuestion pointing to other questionIDs. Basically I've made a two way linked list from scratch. Is there anything built into MYSQL that implements this?

    Thanks in advance.
     
    komrad, Jan 7, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    BTW I have not fully understand your question, you may be looking for AUTO_INCREMENT.
     
    mwasif, Jan 7, 2009 IP