biZ5qPpk

1DELIMITER $$
2create procedure delt_old_backup_library()
3begin
4	DECLARE delete_rows INT;
5	DECLARE rows_count INT;
6	
7	CREATE TEMPORARY TABLE IF NOT EXISTS logt
8	(
9		msg varchar(255) NOT NULL
10	);
11	
12	SELECT COUNT(id) into rows_count FROM library_backup;
13	
14	INSERT INTO logt VALUES( CONCAT('rows_count = ', rows_count) ); 
15	
16	SET delete_rows = rows_count - 10;
17	
18	INSERT INTO logt VALUES( CONCAT('delete_rows = ', delete_rows) ); 
19	
20	IF rows_count > 10 then
21		INSERT INTO logt VALUES( CONCAT('start delete ', delete_rows, ' rows') ); 
22		DELETE FROM library_backup ORDER BY id LIMIT delete_rows;
23		INSERT INTO logt VALUES( CONCAT('end delete ', delete_rows, ' rows') ); 
24	END IF;
25end;$$
26DELIMITER ;