Difference between revisions of "Move mysql column"

From Conservapedia
Jump to navigation Jump to search
m (→‎See also: clean up)
 
(One intermediate revision by one other user not shown)
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]]

Latest revision as of 15:07, June 23, 2016

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

See also

DBMS