From 4a4179b19501059168bd2d725bf6294708c99ec3 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 06 六月 2023 16:37:34 +0800
Subject: [PATCH] 添加Voc的地址
---
ys.sql | 13 +++++++++----
1 files changed, 9 insertions(+), 4 deletions(-)
diff --git a/ys.sql b/ys.sql
index 1a2d7ed..9328f2d 100644
--- a/ys.sql
+++ b/ys.sql
@@ -12,13 +12,18 @@
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