2,187
edits
(→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> | ||