mysql query to delete all the records of a month,

/*delete*/
delete from mytable where MONTH (scheduleDate)=5;

/*to Select*/
select * from mytable where MONTH (scheduleDate)=5;

/*update*/
update set recordtype="saved" where MONTH (scheduleDate)=5;

Comments

Popular posts from this blog

defining functions clojure

Integrating Struts2 with Spring Security using Custom Login Form