Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Insert New Column With Default Value

forums › forums › SQLyog › Using SQLyog › Insert New Column With Default Value

Tagged: , , , ,

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • November 10, 2015 at 12:44 pm #13440
      paulmaherstarwars
      Participant

      I have inserted a new column with a default value into an existing table with about 5000 records but all the existing records still show a null value in the column and I want them to have the default value for the column, how to update all in the column from null to the default please?

    • November 10, 2015 at 1:29 pm #35544
      paulmaherstarwars
      Participant

      No worries I did it with simple query:

       

      Update Tablename set Columnname=’value’

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.