Difference between revisions of "Move mysql column"

From Conservapedia
Jump to navigation Jump to search
(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==
 
==See Also==
 
[[DBMS]]
 
[[DBMS]]
 
[[Category:Computer tips]]
 
[[Category:Computer tips]]

Revision as of 03:22, December 20, 2010

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

See Also

DBMS