diff options
| author | unknown <serg@serg.mylan> | 2003-05-03 01:16:56 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2003-05-03 01:16:56 +0200 |
| commit | b33115ecf9f99c1ffee158d193cafa53b438e52c (patch) | |
| tree | 467d41e9c8504f3a06fc667f9a989394e4a6bce7 /mysql-test/r/insert_update.result | |
| parent | a20b167cae50d938914f0a024bf31546305d17cb (diff) | |
| download | mariadb-git-b33115ecf9f99c1ffee158d193cafa53b438e52c.tar.gz | |
INSERT ... UPDATE ... VALUES()
Diffstat (limited to 'mysql-test/r/insert_update.result')
| -rw-r--r-- | mysql-test/r/insert_update.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/insert_update.result b/mysql-test/r/insert_update.result index 8cc79564679..068f7c68286 100644 --- a/mysql-test/r/insert_update.result +++ b/mysql-test/r/insert_update.result @@ -48,4 +48,12 @@ a b c 3 4 120 5 0 30 8 9 60 +INSERT t1 VALUES (2,1,11), (7,4,40) ON DUPLICATE KEY UPDATE c=c+VALUES(a); +SELECT *, VALUES(a) FROM t1; +a b c VALUES(a) +1 2 10 NULL +3 4 127 NULL +5 0 30 NULL +8 9 60 NULL +2 1 11 NULL DROP TABLE t1; |