MYSQL
TOBEORNOTTB
这个作者很懒,什么都没留下…
展开
-
数据表清空数据
– 1.新建临时表create table tc_transhippoint_info_v1_temp like tc_transhippoint_info_v1 ;– 2.重命名旧表做备份alter table tc_transhippoint_info_v1 rename to tc_transhippoint_info_v1_delete_20211021;– 3.修改临时表名为表tc_transhippoint_info_v1alter table tc_transhippoint_inf原创 2021-11-29 11:49:31 · 826 阅读 · 0 评论 -
mysql存储过程定时删除数据
drop PROCEDURE if EXISTS `sp_delete_tb_push_message_data`;delimiter ;;CREATE PROCEDURE `sp_delete_tb_push_message_data`()BEGINDECLARE v_id int;DECLARE stopflag int;DECLARE v_num int;DECLARE cursor_id cursor for select id from tb_push_message原创 2020-07-22 11:30:26 · 506 阅读 · 0 评论