2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→CREATE / ALTER Tables: Added DELETE
(→User Accounts: Added "Delete Users") |
(→CREATE / ALTER Tables: Added DELETE) |
||
| Line 99: | Line 99: | ||
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 | ||
</source> | |||
<br>'''DELETE'''<br> | |||
<source lang="mysql"> | |||
DELETE FROM hware; # Delete the contents if the hware table | |||
</source> | </source> | ||