MYSQL ordered table

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.

[Free WordPress Themes]

why do you need that? while selecting records you can set the order.

If it takes to much time you need to set an index on the column where the query is based on:

select * from table where field = 'something'

set an index to column 'field'

[Join us @ facebook]

Olaf is right. It doesn;t matter how you enter data in a database because you can retrieve them in any way you like.

Olaf is right. It doesn;t matter how you enter data in a database because you can retrieve them in any way you like.

Yes. In particular, you can use the ORDER BY clause to specify the order:

Code:

select * from my_table ORDER BY question_id

[Guest]

[44.163]

Yahoo crawler, adsense, Msnbot, Baidu Spider