OraFAQ Forum: MySQL » way to inserting data into a MYSQL table data in an ordered way

Home » Open Source » MySQL » way to inserting data into a MYSQL table data in an ordered way

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

way to inserting data into a MYSQL table data in an ordered way [message #556112]

Thu, 31 May 2012 06:16

Cole001
Messages: 1
Registered: April 2012
Location: Ahmedabad, Gujarat, India

Junior Member

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.

Report message to a moderator

Re: way to inserting data into a MYSQL table data in an ordered way [message #556186 is a reply to message #556112]

Thu, 31 May 2012 14:54

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't use MySQL. However, if it is anything like Oracle, there's no use in storing records in an ordered way; ORDER BY - when selecting data from a table - should be used to retrieve record in a desired order. Because, records may be modified - bunch of them deleted from a table, some of them added, then added some more and deleted a few. Insert order will break, sooner or later. Therefore, the ORDER BY clause is the only certain way to get records sorted.

Report message to a moderator

Re: way to inserting data into a MYSQL table data in an ordered way [message #563920 is a reply to message #556186]

Fri, 17 August 2012 23:46

ritu7verma
Messages: 1
Registered: August 2012
Location: India

Junior Member

absolutely correct @littlefoot

can u please tell me which one is better-MYSQl or oracle????

Report message to a moderator

Re: way to inserting data into a MYSQL table data in an ordered way [message #563923 is a reply to message #563920]

Sat, 18 August 2012 00:43

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Better towards which criteria?

Regards
Michel

Report message to a moderator

Re: way to inserting data into a MYSQL table data in an ordered way [message #563938 is a reply to message #563923]

Sat, 18 August 2012 09:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I'd like to know if there is a way to insert into a MYSQL table data in an ordered way?
yes, but it makes no sense to do so
>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.
For some obscure definition of "work around"
Realize that by doing so when you want to add a new question other than at the "top" or "bottom" of the list,
the application is required to do one INSERT & two UPDATE for every new row.
>Basically I've made a two way linked list from scratch.
& what exactly is gained by doing so?
>Is there anything built into MYSQL that implements this?
No since linked list is not directly support by the standard SQL language upon which all RDBMS are based.

Report message to a moderator

Re: way to inserting data into a MYSQL table data in an ordered way [message #565769 is a reply to message #556112]

Thu, 06 September 2012 10:47

Shenbagaramanm
Messages: 3
Registered: September 2012
Location: Chennai

Junior Member

Just index the table...

Report message to a moderator

Previous Topic:	Recover innodb table and data using frm and ibd file
Next Topic:	File data without -INFILE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:19:15 CST 2024