mysql自动按时间分区实例

#添加删除表分区存储过程DELIMITER || DROP PROCEDURE IF EXISTS drop_Partition || CREATE PROCEDURE drop_Partition (IN databaseName VARCHAR(50),IN tableName VARCHAR(50)) L_END:BEGIN   DECLARE i INT DEFAULT 0;   WHILE i <= 2 DO   SELECT PARTITION_NAME INTO @MIN_PARTITION   FROM information_schema.PARTITIONS   WHERE TABLE_SCHEMA = databaseName AND TABLE_NAME = tableName   ORDER BY partition_description ASC LIMIT 1;  SET @S=CONCAT('ALTER TABLE ',tableName,' DROP PARTITION ',@MIN_PARTITION);PREPARE stmt FROM @s;        EXECUTE stmt;        SELECT @s;SET i=i+1;   END WHILE;END L_END;|| DELIMITER ;DELIMITER||DROP EVENT IF EXISTS auto_drop_partitions||CREATE EVENT auto_drop_partitionsNO SCHEDULEEVERY 1 DAY STARTS '2016-12-01 23:59:59'BEGINCALL drop_Partition('adverttj','records');END||DELIMITER ;CALL drop_Partition('adverttj','records');SELECT partition_description INTO @MIN_PARTITIONFROM information_schema.PARTITIONSWHERE TABLE_SCHEMA = 'adverttj' AND TABLE_NAME = 'records'ORDER BY partition_description ASC LIMIT 1;ALTER TABLE `records` DROP PARTITION p20161128#查看分区分区SELECT TABLE_NAME,PARTITION_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME='records'

#添加删除表分区存储过程DELIMITER || DROP PROCEDURE IF EXISTS drop_Partition || CREATE PROCEDURE drop_Partition (IN databaseName VARCHAR(50),IN tableName VARCHAR(50)) L_END:BEGIN   DECLARE i INT DEFAULT 0;   WHILE i <= 2 DO   SELECT partition_description INTO @MIN_PARTITION   FROM information_schema.PARTITIONS   WHERE TABLE_SCHEMA = datavaseName AND TABLE_NAME = tableName   ORDER BY partition_description ASC LIMIT 1;  SET @S=CONCAT('ALTER TABLE ',tableName,' DROP PARTITION p',@MIN_PARTITION,')';PREPARE stmt FROM @s;        EXECUTE stmt;        SELECT @s;SET i=i+1;   END WHILE;END L_END;|| DELIMITER ;CALL drop_Partition('adverttj','records');SELECT partition_description INTO @MIN_PARTITIONFROM information_schema.PARTITIONSWHERE TABLE_SCHEMA = 'adverttj' AND TABLE_NAME = 'records'ORDER BY partition_description ASC LIMIT 1;ALTER TABLE `records` DROP PARTITION p20161128#查看分区分区SELECT TABLE_NAME,PARTITION_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME='records'


                                             
        0        0           
	
				
	
					   
mysql自动按时间分区实例
	  	   
mysql按时间分区插入数据
	  	   
mysql自动分区应用实例
	  	   
自动删除按时间自增量分区job
	  	   
PostgreSQL中使用动态SQL-实现自动按时间创建表分区
	  	   
mysql 按时间查询
	  	   
mysql 按时间查询
	  	   
mysql 按时间查询
	  	   
MySQL按时间分组
	  	   
mysql按时间统计
	  	   
按时间给表建立range分区
	  	   
按时间动态生成分区脚本
	  	   
mysql 语句按时间分组
	  	   
mysql按时间获取数据
	  	   
mysql 按时间段统计
	  	   
mysql按时间段查询
	  	   
MySQL按时间分组求和
	  	   
mysql 按时间查询的
	     		  
	  	   
UML四种关系简介
	  	   
利用大白菜制作多系统启动U盘（win+ubuntu+PE+...）
	  	   
使用MockMvc测试Spring mvc Controller
	  	   
用最科学的方法展示最形象的图表——前端数据可视化实践
	  	   
nginx代理httpd（mod_php）时yii2的url美化问题
	  	   
mysql自动按时间分区实例
	  	   
python3处理剧本角色台词分开输出
	  	   
"error while loading shared libraries: xxx.so.x"
	  	   
Malloc Debug  & Native Memory Tracking using libc Callbacks
	  	   
软键盘 ListView中包含EditText 重绘 ,失去焦点
	  	   
Junit测试Controller（MockMVC使用），传输@RequestBody数据解决办法
	  	   
关于屏幕适配
	  	   
block总结
	  	   
collectionView reloadData 引起闪屏