首頁(yè) 猿問(wèn) 但是性能是個(gè)問(wèn)題，誰(shuí)有更好的辦法??？

但是性能是個(gè)問(wèn)題，誰(shuí)有更好的辦法啊？

MySQL

千巷貓影 2023-04-16 21:18:29

比如2012-12-11 8:00:00-12:00:00到2012-12-13 8:00:00-12:00:00這3天內(nèi)，8點(diǎn)到12點(diǎn)。查詢語(yǔ)句怎么寫？自己寫出來(lái)了。EXPLAIN SELECT COUNT(*) FROM fd_member WHERE FROM_UNIXTIME(UNIX_TIMESTAMP(add_time),'%h')>=8 AND FROM_UNIXTIME(UNIX_TIMESTAMP(add_time),'%h')<12 GROUP BY CONVERT(add_time,CHAR(10))表結(jié)構(gòu)：`mem_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mem_name` varchar(50) NOT NULL , `mem_pass` varchar(50) NOT NULL , `telephone` varchar(20) DEFAULT NULL, `add_time` timestamp NULL DEFAULT NULL, PRIMARY KEY (`mem_id`), UNIQUE KEY `mem_card_id` (`mem_card_id`), UNIQUE KEY `mem_name` (`mem_name`)

查看完整描述

1 回答

慕碼人2483693

TA貢獻(xiàn)1860條經(jīng)驗(yàn) 獲得超9個(gè)贊

SELECT * FROM table_nameWHERE time BETWEEN unix_timestamp(2012-12-11 8:00:00) AND unix_timestamp(2012-12-11 12:00:00)OR time BETWEEN unix_timestamp(2012-12-12 8:00:00) AND unix_timestamp(2012-12-12 12:00:00)OR time BETWEEN unix_timestamp(2012-12-13 8:00:00) AND unix_timestamp(2012-12-13 12:00:00)

反對(duì) 回復(fù) 2023-04-20