Difference between revisions of "Move mysql column"
Jump to navigation
Jump to search
(This command will move your id column to the first position in a MySQL table) |
DavidB4-bot (talk | contribs) m (→See also: clean up) |
||
| (4 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | alter table | + | 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]] | ||