Reply
MYSQL ordered table
Old 01-06-2009, 04:08 AM MYSQL ordered table
Novice Talker

Posts: 8
Name: asep komara sanjaya
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 is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 01-06-2009, 09:12 AM Re: MYSQL ordered table
chrishirst's Avatar
Super Moderator

Posts: 19,022
Location: Blackpool. UK
only if you put the data into the tables in the appropriate order.

I don't know of ANY DB server that lets you insert a row into a table in a particular position.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System | Bits & Bobs
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to MYSQL ordered table
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 



Page generated in 0.09404 seconds with 12 queries