I'm trying to build an insert query that will add a
value into a field , after the first insert query adds
the record.
Relevant table information:
+-+-++--+
| RecordID| InitOn | LenChoice | EndDate |
+ [PrimID,AutoInc]| [Date] | [int]
Stuart Felenstein [EMAIL PROTECTED] wrote on 26/11/2004 13:54:31:
I'm trying to build an insert query that will add a
value into a field , after the first insert query adds
the record.
Relevant table information:
+-+-++--+
| RecordID|
--- [EMAIL PROTECTED] wrote:
I think you need an UPDATE statement
UPDATE MyTable set EndDate=DATE_ADD(InitOn, INTERVAL
LenChoice DAY) WHERE
RecordID = value ;
Insert *always* creates new records if successful
and cannot be used to
modify them.
Update *always* updates recirds in