albabar · November 27, 2015 09:24
diff --git a/reposition.sql b/reposition.sql
 SELECT x.id, 
       x.position,
       x.title,
       x.created_at
  FROM (SELECT t.id,
               t.title,
               t.created_at,
               @rownum := @rownum + 1 AS position
          FROM posts t
          JOIN (SELECT @rownum := 0) r
      ORDER BY t.created_at) x;
diff --git a/update.sql b/update.sql
 UPDATE comments c 
 	LEFT JOIN (
 		SELECT t.id,
  			   t.nid,
               t.post_id,
               t.created_at,
               @rownum := @rownum + 1 AS position
          FROM comments t
          JOIN (SELECT @rownum := 0) r
      	  ORDER BY t.created_at) x 
      	ON c.id = x.id
    SET c.nid = x.position;
No results found