default column value in sql same as other column
Solutions on MaxInterview for default column value in sql same as other column by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "default column value in sql same as other column"
Chris
19 Jun 2016
1ALTER TABLE tablename ADD newcolumn type NOT NULL DEFAULT (0)
2Go
3Update tablename SET newcolumn = oldcolumn Where newcolumn = 0
4Gosimilar questions
queries leading to this page
default column value in sql same as other column your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful