How to add 7 days to mysql date?

[eluser]Sumon[/eluser]
Yes it's valid mysql query statement.I am using mysql version:5.0.45 Here it is once again with full explanation

Code:

UPDATE EVENTS SET EventDate = DATE_ADD( EventDate, INTERVAL 14 DAY ) WHERE EventId =1;

and here is the database table:

Code:

CREATE TABLE `events` (
  `EventId` int(11) NOT NULL auto_increment,
  `EventDate` date NOT NULL default '0000-00-00',
  `EventTitle` varchar(250) NOT NULL default '',
  `EventVanue` varchar(250) NOT NULL default '',
  `EventDetail` longtext NOT NULL,
  PRIMARY KEY  (`EventId`)
);
-- Dumping data for table `events`
INSERT INTO `events` (`EventId`, `EventDate`, `EventTitle`, `EventVanue`, `EventDetail`) VALUES
(1, '2006-03-14', 'This Class is Created By Aminul', '[email protected]', 'Conatct Info:\nMd. Aminul Islam\nHouse- 310/B\nSoudi Coloni\nDhaka Cantonment\nBangladesh\nMobile- 880189512733'),

I hope this might helpful for you.