Posts by Alexandre Ruiz • 9 points

• 0

  votes

  2

  answers

  40

  views

  A: Line numbering

  I was able to get the solution using variables. Maybe not the most elegant solution, but it met what I needed with a very good performance, because my list has almost 1 million lines. SET @y = 0;…

  mysql

  answered 4 years, 9 months ago Alexandre Ruiz 9

• 0

  votes

  2

  answers

  40

  views

  Q: Line numbering

  Suppose the following table: id -- ano 1 -- 2014 2 -- 2014 3 -- 2014 4 -- 2015 5 -- 2015 6 -- 2016 7 -- 2016 8 -- 2016 9 -- 2016 I would like to get a list with a sequential count/numbering of rows…

  mysql

  asked 4 years, 9 months ago Alexandre Ruiz 9