Switching order of columns?
Posted 24 September 2006 - 12:54 AM
Posted 24 September 2006 - 05:24 AM
Yes, but one of my primary indices "id" is listed as my sixth column. It'd be easier to browse and keep track if I could change the position of "id" to first position.
Why would you want to do that? It's the order in which you display retrieved data that's important, isn't it?
Posted 24 September 2006 - 11:57 AM
ALTER TABLE tablename MODIFY columnname INT NOT NULL AUTO_INCREMENT FIRST or ALTER TABLE tablename MODIFY columnname INT NOT NULL AUTO_INCREMENT AFTER othercolumn
Be careful when writing the column definition. If the wrong definition is given you may alter the contents of the column.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users