a guest Mar 23rd, 2019 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- UPDATE catalog_pages INNER JOIN (SELECT * FROM catalog_pages ORDER BY caption ASC) as d ON d.id = catalog_pages.id JOIN (SELECT @ordernum := 0) L SET catalog_pages.order_num=@ordernum:=@ordernum+1 WHERE catalog_pages.parent_id = 912389;
RAW Paste Data