2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
→CREATE / ALTER Tables: Added an ALTER example
m (→INSERT / UPDATE Rows: Added "UPDATE ... SELECT") |
m (→CREATE / ALTER Tables: Added an ALTER example) |
||
| Line 81: | Line 81: | ||
<br>'''ALTER'''<br> | <br>'''ALTER'''<br> | ||
<source lang="mysql"> | <source lang="mysql"> | ||
ALTER TABLE hware ADD UNIQUE KEY hid; | ALTER TABLE hware ADD UNIQUE KEY hid; # Add key (using existing column) | ||
ALTER TABLE hware ADD COLUMN cpu_core TINYINT UNSIGNED AFTER cpu_num; | ALTER TABLE hware ADD COLUMN cpu_core TINYINT UNSIGNED AFTER cpu_num; # Add new column | ||
ALTER TABLE hware CHANGE COLUMN cpu_num cpu_sock TINYINT UNSIGNED; | 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 | |||
</source> | </source> | ||
== INSERT / UPDATE Rows == | == INSERT / UPDATE Rows == | ||