Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m (→Select Rows: Added "AS") |
m (Added "CREATE / ALTER Tables") |
||
Line 73: | Line 73: | ||
Alternatively, use VARCHAR(15) to store as text. | Alternatively, use VARCHAR(15) to store as text. | ||
== | == CREATE / ALTER Tables == | ||
'''CREATE''' | |||
<source lang="mysql"> | |||
CREATE TABLE hware (hid INT, make VARCHAR(64), model VARCHAR(64), cpu_num TINYINT UNSIGNED, cpu_mhz SMALLINT UNSIGNED, mem SMALLINT UNSIGNED, sn VARCHAR(64), PRIMARY KEY (hid)); | |||
</source> | |||
<br>'''ALTER'''<br> | |||
<source lang="mysql"> | |||
ALTER TABLE hware ADD UNIQUE KEY hid; | |||
ALTER TABLE hware ADD COLUMN cpu_core TINYINT UNSIGNED AFTER cpu_num; | |||
ALTER TABLE hware CHANGE COLUMN cpu_num cpu_sock TINYINT UNSIGNED; | |||
</source> | |||
== INSERT / UPDATE Rows == | |||
'''Basic Examples''' | '''Basic Examples''' | ||
<source lang="mysql">INSERT INTO hosts (name, ping_ok) VALUES ('ServerA', 1) ON DUPLICATE KEY UPDATE ping_ok=1; | <source lang="mysql">INSERT INTO hosts (name, ping_ok) VALUES ('ServerA', 1) ON DUPLICATE KEY UPDATE ping_ok=1; |