Changes

Move mysql column (view source)

46 bytes added , 03:22, December 20, 2010

To move a MySQL column

Line 1: Line 1: −

alter table tablename modify `columnname` int(10) unsigned NOT NULL AUTO_INCREMENT first;

+

To move a [[MySQL]] column, use this command: alter table tablename modify `columnname` int(10) unsigned NOT NULL AUTO_INCREMENT first;

==See Also==

[[DBMS]]

[[Category:Computer tips]]

Siteadmin, Check users, nsTeam1RO, nsTeam1RW, nsTeam1_talkRO, nsTeam1_talkRW, oversight, Administrators

30,650

edits