mysql表数据备份示例脚本

一月初一

已于 2024-07-18 22:29:50 修改

阅读量83

点赞数 3

文章标签： mysql 数据库 sql

于 2024-07-18 22:28:38 首次发布

本文链接：https://blog.csdn.net/qq_27821393/article/details/140534840

版权

为了方便下次使用，小记一下

-- 查询总数 （生产总数 758 条）(生产2024-05-02 00:00:00之前没有)
SELECT count(*) FROM `t_entity`  where entity_type in (1,2,17) and brand="500000003002" and create_time >="2024-05-02 00:00:00"  and content_text is not null limit 1 


-- 查看部分详情信息 
SELECT * FROM `t_entity`  where entity_type in (1,2,17) and brand="500000003002" and create_time >="2024-05-02 00:00:00"  and content_text is not null order by id  desc limit 10 


-- 备份表（无索引）
create table t_entity_bak_20240718 like t_entity ;

insert into t_entity_bak_20240718 select * FROM
	`t_entity` 
WHERE
	entity_type IN ( 1, 2, 17 ) 
	AND brand = "500000003002" 
	AND create_time >= "2024-05-02 00:00:00" 
	AND content_text IS NOT NULL;


-- 修改数据，去掉contentText值
UPDATE `t_entity` 
 SET content_text = NULL 
WHERE
	entity_type IN ( 1, 2, 17 ) 
	AND brand = "500000003002" 
	AND create_time >= "2024-05-02 00:00:00" 
	AND content_text IS NOT NULL