ON DUPLICATE KEY..."Table logs:id: INT(11) auto_increment primary keysite_id: INT(11)time: DATEhits: INT(11)Then: CREATE UNIQUE INDEX comp ON logs (`site_id`, `time`); And then you can: INSERT INTO logs (`site_id`, `time`,`hits`) VALUES (1,"2004-08-09", 15) ON DUPLICATE KEY UPDATE hits=hits 15; Excellent feature, and it is much faster and briefer then using first a select, then issuing either an update or an insert depending on the value of the select.You also get rid of the probably necessary table-lock during this action. ON DUPLICATE KEY UPDATE statement, the returned value is as follows:1 for each successful INSERT.2 for each successful UPDATE.Note that App Transport Security (ATS) applies to all requests made as part of the update process.
ON DUPLICATE KEY UPDATE syntax doesn't replicate to my slave servers. This is with server version 5.0.36sp1-enterprise-gpl-log. I wouldn't recommend anyone use the INSERT ... If you want to INSERT multiple records using single statement in MS SQL Server, then the syntax for My SQL wont work.
The installer generated with Squirrel will create a shortcut icon with an Application User Model ID in the format of API, otherwise Windows will not be able to pin your app properly in task bar. Mac, Windows can host updates on S3 or any other static file host.
PDF (US Ltr) - 27.2Mb PDF (A4) - 27.2Mb PDF (RPM) - 26.0Mb HTML Download (TGZ) - 6.5Mb HTML Download (Zip) - 6.5Mb HTML Download (RPM) - 5.6Mb Man Pages (TGZ) - 152.9Kb Man Pages (Zip) - 255.1Kb Info (Gzip) - 2.6Mb Info (Zip) - 2.6Mb My SQL Backup and Recovery My SQL NDB Cluster 7.2 My SQL Globalization My SQL Information Schema My SQL Installation Guide My SQL and Linux/Unix My SQL and OS X My SQL Partitioning My SQL Performance Schema My SQL Replication My SQL Restrictions and Limitations Security in My SQL My SQL and Solaris Building My SQL from Source Starting and Stopping My SQL My SQL Tutorial My SQL and Windows Each values list must contain exactly as many values as are to be inserted per row.
If you need plan to get the LAST_INSERT_ID() from a INSERT ... I haven't seen this mentioned elsewhere on this page, but you can use a SELECT statement as a single value if it returns a single value.
For example, if we have two tables, t1 and t2: CREATE TABLE t1 ( a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(10)) TYPE=Inno DB; INSERT INTO t1 (b) VALUES (' Spike'), (' Chip'), (' John'); CREATE TABLE t2 ( a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT NOT NULL, FOREIGN KEY (b) REFERENCES t1 (a), c VARCHAR(15)) TYPE=Inno DB; We can INSERT rows into t2 that populate the foreign key column based on a SELECT statement on t1: INSERT INTO t2 (b, c) VALUES ((SELECT a FROM t1 WHERE b=' Chip'), 'shoulder'), ((SELECT a FROM t1 WHERE b=' Chip'), 'old block'), ((SELECT a FROM t1 WHERE b=' John'), 'toilet'), ((SELECT a FROM t1 WHERE b=' John'), 'long,silver'), ((SELECT a FROM t1 WHERE b=' John'), 'li''l'); Then we get:mysql5 rows in set (0.00 sec)This is especially useful if you don't want to specify the ids for your rows (because they may differ from database to database, due to their being based on AUTO_INCREMENTs), but you want to refer to the values of other tables.It should be relatively easy to use the same hostname and only change its DNS record to point on new IP address.