Re: Warning 1287: setting variables deprecated

[Tim Bomgardner]

Thanks for replying, but I don't think this is going to solve my problem. I'm not looking to set the value in a single row. I need each of many rows to contain an automatically generated incrementing value, starting at 0. In other words, in the first row, order = 0, in the second row, order = 1, and so on. The deprecated feature, in this case @i := @i + 1 in the select, does exactly what I need. I've taken a different approach to solving the problem that doesn't require setting a variable. Thanks again.