Difference between revisions of "Move mysql column"
Jump to navigation
Jump to search
(changed "donors" to "tablename" so it's more clear how to apply this. i don't know mysql well, so please fix if i screwed up!) |
DavidB4-bot (talk | contribs) m (→See also: clean up) |
||
| (3 intermediate revisions by 3 users 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== | ||
| + | [[DBMS]] | ||
| + | [[Category:Computer tips]] | ||