In this new database I created I have to organize some things that require A LOT of cell colums. I inserted all of them into my database from a peice of paper that i had them written on. Now I did the insertions in no special order, but I want now to organize them all in alphabetical order. I'm wondering if this is possible.
I could do that for the output which I know how to do, but yea I need to know how to make the changes to the database itself not the output of the database.
You may be able to copy the data to a temp table in the order you want using INSERT...SELECT: http://www.mysql.com/doc/en/INSERT_SELECT.html
and then delete the old table and rename the copy.
Not sure what you mean. A DB table does not have any order. When you select it back it is essentially random.
It may appear ordered, but won't stay that way when deletes/inserts happen then the deleted rows are re-used by the new inserted rows. Also when the table extends new data could be anywhere on the disk. The only way to guarantee the output order is the order by clause.
edit:
should have said, this is with the db's (Oracle, sybase, etc.) I have used. Maybe some out there do store it in order.
I highlighted the first letters of the coloumns. That is what i want in alphabetical order. It's for organizational reasons, that is just a few of many. I just can't seem to find a way how.