更新时间:2023-02-08 20:32:40
试试这个:
ALTER TABLE tablename ADD newcolumn type NOT NULL DEFAULT (0) Go Update tablename SET newcolumn = oldcolumn Where newcolumn = 0 Go
向表中添加一列,其默认值等于现有列的值