sql
鹤忧
这个作者很懒,什么都没留下…
展开
-
sql取前一天,后一天,指定天数时间
1,取前一天SELECT DATE_SUB(CURDATE(),INTERVAL 1 DAY) 2 取当前天SELECT DATE_SUB(CURDATE(),INTERVAL 0 DAY)3 取明天日期SELECT DATE_SUB(CURDATE(),INTERVAL -1 DAY)4 取指定日期前2天SELECT DATE_SUB('2020-05-22',INTERVAL 2 DAY)原创 2020-05-19 15:46:32 · 4054 阅读 · 0 评论 -
mysql分区表LIST
1.新建普通表CREATE TABLE data(id int(30) ,time int(12), sarlay decimal(12,2));2.插入数据INSERT INTO data VALUES (1,201911,10000), (2,201912, 12000), (3,201910, 11000), (4,202001,13000), (5,202001,15000), (6,202004,16000), (7,202004, 17000), (8,202004, 180000);3原创 2020-05-09 10:12:16 · 437 阅读 · 0 评论 -
mysql分区表RANGE
1.新建普通表CREATE TABLE human (age int, sex int);2.插入数据INSERT INTO human VALUES (5,1), (15, 0), (24, 1), (44, 1), (32, 0), (64, 1), (84, 1), (54, 0);3.建立分区表CREATE TABLE human_fq (age int, sex int) ...原创 2020-05-08 13:54:00 · 413 阅读 · 0 评论 -
sql用法
将文本文件中的行读入表中eg:load local data infile "C:\\sqlfile\\tb_flow.txt" into table tb_flow fields terminated by'|' lines terminated by '\n'fields关键字指定了文件记段的分割格式,如果用到这个关键字,MySQL剖析器希望看到至少有下面的一个选项:termina...原创 2020-04-23 21:07:17 · 187 阅读 · 0 评论