mySQL update insert

I am trying to execute this mySQL statement here but it isn't working here is the code


Open in new window

UPDATE LISTINGS SET creationDate = (SELECT CONCAT('-','year','month','day') from LISTINGS);

basically its a old table that has YY,MM,DD in separate columns i want to combine them into one field called creationDate with the proper mySQL date format.  
stargateatlantisAsked:
Who is Participating?
 
SharathData EngineerCommented:
try like this.
UPDATE LISTINGS 
   SET creationDate = CONCAT('-','year','month','day');

Open in new window

0
 
Aaron TomoskySD-WAN SimplifiedCommented:
Get rid of the select, from listings.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.