How to write mysql trigger current date + 7 days
I want to store current date+ 7 days in mysql database, dont want just to create a recordset and put DATE_ADD(DateColumn,INTERVAL 7 DAY).. for future references I need to store expiry date in my database, so please tell me how I can write trigger on new insertion by using DA