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

Posts: 8
Name: asep komara sanjaya
Trades: 0
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, 10:12 AM Re: MYSQL ordered table
chrishirst's Avatar
Super Moderator

Posts: 22,285
Location: Blackpool. UK
Trades: 0
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!! <<-
Growing old is mandatory - Growing up is optional
Code Samples | People Counting System | Bits & Bobs
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to MYSQL ordered table
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB 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.10230 seconds with 13 queries