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.

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

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

Yes ORDER BY is the best option... you can order by ascending or descending...

the one thing you can do while creating the table itself no need to worry for the rest of the values

Would you say MYSQL is the best database format?

Would you say MYSQL is the best database format?

Well there is now a trend of moving away from relational databases; "NoSQL" so I'd keep my fingers crossed

I recently register new website and i am going to set up new data base. I don't know how to create this.  Once i tried to do this. I enter in cpanel and then click on data base. After create new one with user name and password. After this i click on file manager but i am unable to do so.

Tell me what is problem. I am unable to login in my ftp account. 

MySql Database are one of the most appropriate database with lots of cool services involved in it. You can go ahead with the downloading the database adnd then later to upload the database as it is, some times it creates a huge directly in to yourwebsite which can take it if every things goes right . So do make sure you must have a perfect work on the database

How about using a "priority" column so you can easily switch entries around and allow you to order the questions quickly within the SQL SELECT statement?

It was too useful for me too. Thanks @troublescoot. However I would prefer mostly the Data Entity Framework and LinQ for database programming in ASP.NET. Although these was in the PHP.

[Guest]

[62.886]

Googlebot, Yahoo crawler