1

Topic: Zapolenie columns repeating values

Hello, there is a table where it is necessary to add a new column of type varchar and with value on  NULL - I add->
ALTER TABLE table ADD _ varchar (255) type NULL DEFAULT;
I struggle with that that every tenth value of a column was "_" and remaining values NULL
While there was that that such -
UPDATE table SET _ = _ Where newcolumn = 0
Direct please the wanderer in this infinite relational world!
Thanks!

2

Re: Zapolenie columns repeating values

freelancer21;
To numberings of lines need to be fastened i % 10 = 0