--- [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 position and > cannot be used to insert > them > Replace is a hybrid whcih can do either if you set > your indexes right. > > I think what you want is an Update, not an Insert. > > Alec Thank you Alex. It works. !
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]