![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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_v1 alter table tc_transhippoint_inf原创 2021-11-29 11:49:31 · 830 阅读 · 0 评论 -
mysql存储过程定时删除数据
drop PROCEDURE if EXISTS `sp_delete_tb_push_message_data`; delimiter ;; CREATE PROCEDURE `sp_delete_tb_push_message_data`() BEGIN DECLARE 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 · 511 阅读 · 0 评论