also the following queries.
Accidentally the server date was set to a wrong value for 1 day. You have correctly set the date now. But you want to change all the date entries made on that day. Write a query to change the day by 1 of all dates in the query table on 31st Jan 2013.
Write a query to delete all queries from the query table posted before year 2012.
Write a query such that the experience table contains only the details regarding the past experience of the alumni.
The event 'ALUMNI MEET' has been postponed by 3 hours. Write a query to change the event time.
UPDATE event
RépondreSupprimerSET date=DATE_ADD(date,INTERVAL 3 HOUR)
WHERE name='ALUMNI MEET';
delete from query where date<'2011-12-31 11:59:59';
RépondreSupprimer