maybe try 'order by sort_id desc'?
On Mon, Jul 14, 2014 at 12:42 PM, Don Wieland <d...@pointmade.net> wrote: > I am trying to create this stored procedure, but can't understand why my > editor is chocking on it. Little help please: > > DELIMITER // > CREATE PROCEDURE `reset_sortid` (IN category INT(11)) > BEGIN > DECLARE a INT; > SET a = 0; > UPDATE > documents SET sort_id = (a := a + 1) > WHERE > document_category = category > ORDER BY > sort_id; > END > // > > > Don Wieland > d...@pointmade.net > http://www.pointmade.net > https://www.facebook.com/pointmade.band > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
