Hi Richards .
Here are some of my codes. You can do some changes whatever you want.
http://blog.chinaunix.net/u/29134/showart_1002486.html
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao
HI All
Just to give you some idea of what I have tried thus far:
mysql> delimiter //
mysql> create procedure select_delete_id (in dt date, out id bigint)
begin select max(id) into id from archive_collections where utc < dt;
end//
Query OK, 0 rows affected (0.00 sec)
mysql> delim
