2,187
edits
(→CREATE / ALTER Tables: Added DELETE) |
(→CREATE / ALTER Tables: Added RENAME) |
||
Line 91: | Line 91: | ||
<source lang="mysql"> | <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)); | 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> | |||
'''RENAME''' | |||
<source lang="mysql"> | |||
RENAME TABLE hware to hardware; | |||
</source> | </source> | ||