diff options
| author | unknown <serg@serg.mysql.com> | 2002-12-02 21:12:25 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2002-12-02 21:12:25 +0100 |
| commit | 6c4519e8db142c8a0ea9db71c140e17a03fa0993 (patch) | |
| tree | 1501a640db8ab613fb995045575d785c925595ff /mysql-test/r/insert_update.result | |
| parent | 694c7334b316cba4b0eb02b4f9381379a67da824 (diff) | |
| download | mariadb-git-6c4519e8db142c8a0ea9db71c140e17a03fa0993.tar.gz | |
one more test
Diffstat (limited to 'mysql-test/r/insert_update.result')
| -rw-r--r-- | mysql-test/r/insert_update.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/insert_update.result b/mysql-test/r/insert_update.result index e02d4ebb588..3732558937d 100644 --- a/mysql-test/r/insert_update.result +++ b/mysql-test/r/insert_update.result @@ -41,4 +41,11 @@ a b c 3 4 120 5 6 30 8 9 60 +INSERT t1 SET a=5 ON DUPLICATE KEY UPDATE SET b=0; +SELECT * FROM t1; +a b c +1 2 10 +3 4 120 +5 0 30 +8 9 60 DROP TABLE t1; |