diff options
author | unknown <monty@mysql.com> | 2003-12-13 04:04:38 +0200 |
---|---|---|
committer | unknown <monty@mysql.com> | 2003-12-13 04:04:38 +0200 |
commit | db37aa2297d30c339b1d6128f26fe437ae89a605 (patch) | |
tree | cf05e1e4ec36f367ed2af0f1637a851099cc54ba /mysql-test/r/multi_update.result | |
parent | cbc18a76c83365240b0bb684b8b0990ca6d4797d (diff) | |
parent | 759ea82ee1335543da1d484d76468b6686057e90 (diff) | |
download | mariadb-git-db37aa2297d30c339b1d6128f26fe437ae89a605.tar.gz |
Merge
sql/sql_select.cc:
Auto merged
sql/sql_update.cc:
Auto merged
mysql-test/r/multi_update.result:
SCCS merged
mysql-test/t/multi_update.test:
SCCS merged
Diffstat (limited to 'mysql-test/r/multi_update.result')
-rw-r--r-- | mysql-test/r/multi_update.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index 5b265d578cd..31be96fc0fd 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -327,6 +327,16 @@ select t1.a, t1.b,t2.a, t2.b from t1 left join t2 on t1.a=t2.a where t1.b=1 and a b a b 2 2 NULL NULL drop table t1,t2; +create table t1 (a int not null auto_increment primary key, b int not null); +insert into t1 (b) values (1),(2),(3),(4); +update t1, t1 as t2 set t1.b=t2.b+1 where t1.a=t2.a; +select * from t1; +a b +1 2 +2 3 +3 4 +4 5 +drop table t1; drop table if exists t1, t2; create table t1(id1 smallint(5), field char(5)); create table t2(id2 smallint(5), field char(5)); |