2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→CREATE / ALTER Tables: Added RENAME
(→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> | ||