[komrad]

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.

[jitendraag]

Are you trying to insert? What is the purpose of 'order' when you are inserting? Wouldn't this be required when you are retrieving the rows.

[MH Vishal]

You simple need to do write some codes to verify that the primary key to be inserted doesn't already exist in the tables.

[iapp]

I don't know what do you mean.

[imboring1]

there a options in xammp lol

[extremeseos]

Basically SQL is quite useful in big establishments......with all its features properly used....

[HivelocityDD]

There is no significance in inserting the data to mysql in an orderly manner. But you can use autoincrement to insert the data with out duplicates in the id putting a primary key to it.

And while selecting the data you can call the "order by field name " to sort it in the corresponding order.

[careertargetph]

You can use a SQL query to transfer this data in your prefered way. You can read for documentation regarding this matter.