diff options
| author | serg@serg.mylan <> | 2003-05-03 01:16:56 +0200 |
|---|---|---|
| committer | serg@serg.mylan <> | 2003-05-03 01:16:56 +0200 |
| commit | 784fb81426e917cb66ace05310ebccafb23a4b1b (patch) | |
| tree | 467d41e9c8504f3a06fc667f9a989394e4a6bce7 /mysql-test/t/insert_update.test | |
| parent | 0f653b6fed0c742aa49ed621839eaeda080ebb20 (diff) | |
| download | mariadb-git-784fb81426e917cb66ace05310ebccafb23a4b1b.tar.gz | |
INSERT ... UPDATE ... VALUES()
Diffstat (limited to 'mysql-test/t/insert_update.test')
| -rw-r--r-- | mysql-test/t/insert_update.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/insert_update.test b/mysql-test/t/insert_update.test index f40391554cc..4f19aca8738 100644 --- a/mysql-test/t/insert_update.test +++ b/mysql-test/t/insert_update.test @@ -21,4 +21,6 @@ INSERT t1 VALUES (5,6,30), (7,4,40), (8,9,60) ON DUPLICATE KEY UPDATE c=c+100; SELECT * FROM t1; INSERT t1 SET a=5 ON DUPLICATE KEY UPDATE b=0; SELECT * FROM t1; +INSERT t1 VALUES (2,1,11), (7,4,40) ON DUPLICATE KEY UPDATE c=c+VALUES(a); +SELECT *, VALUES(a) FROM t1; DROP TABLE t1; |