2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→CREATE / ALTER Tables: Added further ALTER examples
(→INSERT / UPDATE Rows: Updated) |
(→CREATE / ALTER Tables: Added further ALTER examples) |
||
| Line 108: | Line 108: | ||
<br>'''ALTER'''<br> | <br>'''ALTER'''<br> | ||
<source lang="mysql"> | <source lang="mysql"> | ||
ALTER TABLE hware ADD UNIQUE KEY hid; # Add key (using existing column) | ALTER TABLE hware ADD UNIQUE KEY hid; # Add index/key (using existing column) | ||
ALTER TABLE hware ADD FULLTEXT(name); # Add a FULLTEXT key (used for fuzzy searches) | |||
ALTER TABLE hware ADD COLUMN cpu_core TINYINT UNSIGNED AFTER cpu_num; # Add new column | ALTER TABLE hware ADD COLUMN cpu_core TINYINT UNSIGNED AFTER cpu_num; # Add new column | ||
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 | ALTER TABLE hware DROP COLUMN cpu_sock; # Drop (delete/remove) column from table | ||
ALTER TABLE hware DROP KEY hid; # Drop (delete/remove) hid index (not the column) | |||
</source> | </source> | ||