diff options
| author | evgen@moonbone.local <> | 2007-05-08 15:54:49 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2007-05-08 15:54:49 +0400 |
| commit | df081a3a4ff099bc354a8e052d5ea2daa48a362e (patch) | |
| tree | c21fe5ea88d116da87702aa338dee3c533148c18 /mysql-test/r/insert_update.result | |
| parent | e86643ec0fc84b9cbbb997b419a00bb6552b5cdb (diff) | |
| parent | efb13e1bfe9b7e438325e85cae51d1bf9de476ad (diff) | |
| download | mariadb-git-df081a3a4ff099bc354a8e052d5ea2daa48a362e.tar.gz | |
Merge moonbone.local:/mnt/gentoo64/work/bk-trees/mysql-5.0-opt
into moonbone.local:/mnt/gentoo64/work/test-5.1-opt-mysql
Diffstat (limited to 'mysql-test/r/insert_update.result')
| -rw-r--r-- | mysql-test/r/insert_update.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/insert_update.result b/mysql-test/r/insert_update.result index fed66ed47a7..98e6878482b 100644 --- a/mysql-test/r/insert_update.result +++ b/mysql-test/r/insert_update.result @@ -336,3 +336,25 @@ id f1 0 test1 DROP TABLE t1; SET SQL_MODE=''; +CREATE TABLE t1 ( +id INT AUTO_INCREMENT PRIMARY KEY, +c1 CHAR(1) UNIQUE KEY, +cnt INT DEFAULT 1 +); +INSERT INTO t1 (c1) VALUES ('A'), ('B'), ('C'); +SELECT * FROM t1; +id c1 cnt +1 A 1 +2 B 1 +3 C 1 +INSERT INTO t1 (c1) VALUES ('A'), ('X'), ('Y'), ('Z') +ON DUPLICATE KEY UPDATE cnt=cnt+1; +SELECT * FROM t1; +id c1 cnt +1 A 2 +2 B 1 +3 C 1 +4 X 1 +5 Y 1 +6 Z 1 +DROP TABLE t1; |