Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
do several updates at once
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
select id,sta into #tmp from ( select 60000 id,9 sta union all select 61000,8 union all select 61209,7 union all select 61208,6 union all select 72000,5 union all select 72670,10 union all select 56916,11 union all select 55451,12 ) tbl; select * from #tmp; -- before update #tmp set sta=st from ( select 61209 i,2 st union all select 61208,2 union all select 72670,3 union all select 56916,3 union all select 55451,4 ) tv inner join #tmp on id=i; select * from #tmp; -- after
View schema
Execution time: 0,02 sec, rows selected: 16, rows affected: 5, absolute service time: 0,16 sec
fork mode
|
history
|
discussion
id
sta
1
60000
9
2
61000
8
3
61209
7
4
61208
6
5
72000
5
6
72670
10
7
56916
11
8
55451
12
id
sta
1
60000
9
2
61000
8
3
61209
2
4
61208
2
5
72000
5
6
72670
3
7
56916
3
8
55451
4