2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
Added link to official MySQL documentation
m (Added "Insert / Update Rows") |
m (Added link to official MySQL documentation) |
||
| Line 1: | Line 1: | ||
See the official [http://dev.mysql.com/doc/ MySQL documentation] for further info. | |||
== Basic Commands == | == Basic Commands == | ||
| Line 45: | Line 47: | ||
* <code> INSERT INTO hosts (name, ping_ok) VALUES ('ServerA', 1) ON DUPLICATE KEY UPDATE ping_ok=1; </code> | * <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> | * <code> UPDATE hosts SET ping_ok=0, reason='Time Out' WHERE name='ServerA'; </code> | ||
== Software Packages == | |||
[[Category:MySQL]] | [[Category:MySQL]] | ||