Posts by Leandro Moreira • 1 point
1 post
-
0
votes4
answers18077
viewsA: How to organize auto-increment numbering of a column Id of a table in Mysql?
My knowledge in SQL is not very advanced but I have learned a lot. DECLARE @W INT = 1 DECLARE @ID INT = 1 DECLARE @Max INT = (SELECT MAX ([ID]) FROM [_Table]) WHILE @W Between 1 and @Max BEGIN IF…