spand
04/23/2018, 7:12 AMNikita Nikolenko
04/23/2018, 7:16 AMALTER TABLE table_name ADD newcolumn_name type NOT NULL DEFAULT (0)
Go
Update table_name SET newcolumn_name = oldcolumn_name Where newcolumn_name = 0
spand
04/23/2018, 7:22 AMtapac
04/23/2018, 8:18 AMdefault values from another column
.
It's just "placeholder" value for further manual update.
What you want may be handled with triggers, I guess.Nikita Nikolenko
04/23/2018, 8:27 AM