From 9a86656c139eef8963bcf449a8985ef9bcb1299c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 18 十一月 2024 17:57:05 +0800
Subject: [PATCH] 1
---
ys.sql | 19 +++++++++++++++----
1 files changed, 15 insertions(+), 4 deletions(-)
diff --git a/ys.sql b/ys.sql
index 1a2d7ed..0b56c2e 100644
--- a/ys.sql
+++ b/ys.sql
@@ -4,6 +4,11 @@
SHOW BINARY LOGS;
RESET MASTER;
+
+create index index_yssh_gcsj_time on yssh_gcsj(time);
+drop index index_yssh_gcsj_time on yssh_gcsj;
+
+https://blog.csdn.net/qq_63161848/article/details/141591514
----------------------------------------------------------------------
create table voc_vals (
id bigint not null primary key comment '涓婚敭',
@@ -12,13 +17,19 @@
val double(25, 10) comment '鍊�',
create_time datetime comment '鍊�'
);
--- drop table voc_vals;
+
create index voc_vals_val on voc_vals (val);
create index voc_vals_time on voc_vals (create_time);
----------------------------------------------------------------------
-/* 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';
+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 date_sub(now(), interval 1 year) "time" from dual;
-select count(*) from voc_vals; */
select * from voc_vals;
+select * from voc_addr;
--
Gitblit v1.9.3