2,187
edits
m (→Data Types: Added NULL) |
m (Added "Insert / Update Rows") |
||
Line 40: | Line 40: | ||
* <code> INSERT INTO ips SET ip=INET_ATON('10.1.2.3'); </code> | * <code> INSERT INTO ips SET ip=INET_ATON('10.1.2.3'); </code> | ||
Alternatively, use VARCHAR(15) to store as text. | Alternatively, use VARCHAR(15) to store as text. | ||
== Insert / Update Rows == | |||
* <code> INSERT INTO hosts (name, ping_ok) VALUES ('ServerA', 1) ON DUPLICATE KEY UPDATE ping_ok=1; </code> | |||
* <code> UPDATE hosts SET ping_ok=0, reason='Time Out' WHERE name='ServerA'; </code> | |||
[[Category:MySQL]] | [[Category:MySQL]] |