Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
do several updates at once
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
run
|
edit
|
history
|
help
0
gdfgfd
Train Reservation
TRAIN
mysql4
Finding Row Wise Max Value From Table
Creation tables
Stackoverflow 37635278
SS my sql server 2014 4/7
http://connect.bein.net/ar/live-ar/
Orders