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

Setting New Column Value

forums › forums › SQLyog › Query Builder and Schema Designer › Setting New Column Value

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • September 27, 2009 at 6:12 am #11693
      bkelley
      Member

      Hi, I would appreciate some help with this. I have created a new column (year_qtr char(6)) and I would like to set the value of that new column to be the concatenated value of two other columns. In SPSS I would write the code as concat(year,”Q”,quarter) which would take the values of 'year' and add in “Q” and then add in the value of quarter. The value of this new column would then be something like “2008Q3”.

      How can I create/set/change the value of the year_qtr column to this new value, drawn from fields that exist in each record?

      thanks for any help.

      Brian

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.