mysql统计每天的数据_mysql 统计新增每天数据

#创建基表

CREATE TABLE `table_sum` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`table_name` varchar(50) DEFAULT NULL,

`table_rows` int(11) DEFAULT NULL,

`total_size` int(11) DEFAULT NULL,

`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#创建统计表

CREATE TABLE `table_day_growth` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`table_name` varchar(50) DEFAULT NULL,

`table_rows` int(11) DEFAULT NULL,

`total_size`  int(11) DEFAULT NULL,

`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#每天向基表里插入数据

cat insert_table_bak.sh

#!/bin/bash