---------------------------------------------------------------------- use yssh; show tables; SHOW BINARY LOGS; RESET MASTER; ---------------------------------------------------------------------- create table voc_vals ( id bigint not null primary key comment '主键', x int comment 'X', y int comment 'Y', val double(25, 10) comment '值', create_time datetime comment '值' ); create index voc_vals_val on voc_vals (val); create index voc_vals_time on voc_vals (create_time); ---------------------------------------------------------------------- create table voc_addr ( id int not null auto_increment primary key comment '主键', x int comment 'X', y int comment 'Y', addr varchar(50) comment '地址' ); ---------------------------------------------------------------------- select a.*, date_format(create_time, '%Y%m%d%H') "time" from voc_vals a where date_format(create_time, '%Y%m%d%H') = '2023060514'; select * from voc_vals where create_time < date_sub(now(), interval 1 year); select * from voc_vals; select * from voc_addr;