SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table routes (route_id int, trunk_id int, seq int); insert into routes values (16,117,0), (16,118,1), (16,120,2), (16,121,3); select * from routes; set @q = -1; update routes join ( select routes.*, @q:=ifnull(@q, -1) +1 new_seq from routes order by trunk_id = 120 desc, seq ) new_routes using (route_id, trunk_id) set routes.seq = new_routes.new_seq where route_id = 16; select routes.* from routes order by seq;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear