Reputation: 13129
What is the correct syntax to do a SQL Update on a column and divide its values by 1 000 000?
Upvotes: 15
Views: 34697
Reputation: 23514
UPDATE table SET column = column / 1000000
Upvotes: 36