Simple insert Into Statement Gone Wrong

[Jacques]

Hey Guys,

 

I need some help, i was tasked to create a new column in the a DB i manage.

 

This is to calculate warranty statuses:

 

My Query is as follows:

INSERT INTO #TABLENAME# (#NEW COLUMN ADDED#)

VALUES (DATE_ADD(#DateColumn#,INTERVAL 42 MONTH))

 

This does not work. Can anyone please assist with this?

 

KR

Jacques

[Mchl]

Do you want to INSERT a new row or UPDATE existing rows?

[Jacques]

Insert New Rows. I need to calculate from Existing Date column. For example

DATE_ADD(ShipDate, INTERVAL 42 MONTH) AS Warrdate

[Mchl]

That sound's like you're updating existing rows, so you should use UPDATE query

 

UPDATE #TABLENAME# SET #NEW COLUMN ADDED# = DATE_ADD(#DateColumn#,INTERVAL 42 MONTH)