Column Value

[neroag]

Hi All

I have a mysql database where one of the columns(importid) in a table (products) has all the wrong values assigned
if there a way i repopulate all the columns incrementing the value by 1 on each entry ?

thanks you

[bradgrafelman]

Sounds like you simply need to execute an UPDATE query with no WHERE clause and set the offending column equal to its current value plus one.

What have you tried?