2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→CREATE / ALTER Tables: Added further CREATE examples
(→CREATE / ALTER Tables: Added RENAME) |
(→CREATE / ALTER Tables: Added further CREATE examples) |
||
| Line 90: | Line 90: | ||
'''CREATE''' | '''CREATE''' | ||
<source lang="mysql"> | <source lang="mysql"> | ||
CREATE TABLE hware (hid INT, make VARCHAR(64), model VARCHAR(64), cpu_num TINYINT | CREATE TABLE hware (hid INT AUTO_INCREMENT, make VARCHAR(64), model VARCHAR(64), cpu_num TINYINT UNSIGNED, mem SMALLINT UNSIGNED, sn VARCHAR(64), PRIMARY KEY (hid)); | ||
CREATE TABLE notes (nid INT UNSIGNED AUTO_INCREMENT, note VARCHAR(256), stamp TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp, PRIMARY KEY (nid)); | |||
CREATE TABLE hware2notes (hid INT, nid INT, PRIMARY KEY (hid, nid)); # Primary key prevent duplicate rows | |||
</source> | </source> | ||
'''RENAME''' | <br>'''RENAME''' | ||
<source lang="mysql"> | <source lang="mysql"> | ||
RENAME TABLE hware to hardware; | RENAME TABLE hware to hardware; | ||