how to change order of fields??

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

how to change order of fields??

Postby ironmansp » 29. March 2007 19:30

I have several tables on a database. How can I reorder the name of the fields of the tables? I want to reorder the names but I can not how to do it... Suggestions please?
Posts: 24
Joined: 26. February 2007 14:59

Postby Mätes » 30. March 2007 12:42

i think there is no (easy) way to reorder the fields.

one way is to create a new table with the same fields and a new order,
copy the data and rename both tables.
its a littlebit more to do if there are any constraints or anything else.

ms-sql-server also has no function to do it, but one tool (sql-manager) provides a small wizard to do it, and he executes all the steps mentioned above.

possible there are tools for mysql that can help you.
try SQLYog
or HeidiSQL

User avatar
Posts: 142
Joined: 13. April 2006 09:34
Location: kölle

Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 3 guests