2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→CREATE / ALTER Tables: Added further ALTER examples
(→Basic Commands: Added DROP DATABASE) |
(→CREATE / ALTER Tables: Added further ALTER examples) |
||
| Line 107: | Line 107: | ||
ALTER TABLE hware MODIFY COLUMN mem INT UNSIGNED; # Modify column type | ALTER TABLE hware MODIFY COLUMN mem INT UNSIGNED; # Modify column type | ||
ALTER TABLE hware CHANGE COLUMN cpu_num cpu_sock TINYINT UNSIGNED; # Change column name | ALTER TABLE hware CHANGE COLUMN cpu_num cpu_sock TINYINT UNSIGNED; # Change column name | ||
ALTER TABLE hware DROP COLUMN cpu_sock; # Drop (delete/remove) column from table | |||
</source> | </source> | ||