Difference between revisions of "VI-DB vi-db-update-v2.7"
Jump to navigation
Jump to search
(Initial creation) |
(Updated category) |
||
| Line 5: | Line 5: | ||
</source> | </source> | ||
[[Category:MySQL]] | [[Category:MySQL Examples]] | ||
Latest revision as of 22:13, 16 March 2014
ALTER TABLE vm2ip DROP PRIMARY KEY;
DELETE FROM vm2ip WHERE ISNULL(ip);
ALTER TABLE vm2ip ADD PRIMARY KEY (vmid, vnicid, ip);