Update Field based on another table's Field values

Question

i want to update a filed named "outofdate"(type date : 2015-01-14 10:03:11 ) based on another filed name "lastmodification" . i want to add 10 days to "outofdate" field where :outofdate < NOW() (actual date)

My code is not working:

Update *
`mytable` set outofdate = lastmodification + 84500*10
WHERE  outofdate < NOW( ) LIMIT 0,100

thx in advance!

Why did you put the * sign after the update operator? – St.Antario Feb 08 '15 at 15:23 — St.Antario, Feb 08 '15 at 15:23

score 1 · Accepted Answer · answered Feb 08 '15 at 15:35

1

Update *? That is not valid syntax. I think the rest is basically ok:

Update mytable
    set outofdate = lastmodification + interval 10 day;
    WHERE outofdate < NOW( )
    LIMIT 0, 100;

Note that the number of seconds in a day is not 84,500. Also, for date/time data types, use date_add() or interval addition.

answered Feb 08 '15 at 15:35

Gordon Linoff

1,242,037
58
646
786

UPDATE `mytable` SET outofdate = DATE_ADD( lastmodification, INTERVAL 10 DAY ) WHERE outofdate < NOW ( ) – Rus Sergiu Feb 08 '15 at 15:39

Update Field based on another table's Field values

1 Answers1

Linked