CREATE TABLE mytable( id INT PRIMARY KEY AUTO_INCREMENT, myvalue VARCHAR(10), mydate DATETIME ) INSERT INTO mytable(myvalue,mydate) VALUES('a','2014-07-22 14:23:00'); INSERT INTO mytable(myvalue,mydate) VALUES('b','2014-07-22 15:28:00'); INSERT INTO mytable(myvalue,mydate) VALUES('c','2014-07-23 11:23:00'); INSERT INTO mytable(myvalue,mydate) VALUES('d','2014-07-25 14:23:00'); INSERT INTO mytable(myvalue,mydate) VALUES('f','2014-07-26 07:23:00');INSERT INTO mytable(myvalue,mydate) VALUES('e','2014-07-25 19:26:00'); INSERT INTO mytable(myvalue,mydate) VALUES('g','2014-07-27 14:23:00'); INSERT INTO mytable(myvalue,mydate) VALUES('h','2014-07-27 15:23:00'); INSERT INTO mytable(myvalue,mydate) VALUES('i','2014-07-27 19:51:00'); INSERT INTO mytable(myvalue,mydate) VALUES('k','2014-07-28 14:23:00'); INSERT INTO mytable(myvalue,mydate) VALUES('l','2014-07-29 14:23:00');--查詢23號(hào)到28號(hào)中每天的最后一條數(shù)據(jù)的集合，即從這張表中篩選出myvalue為c、e、f、i、k哎呀，想寫(xiě)個(gè)sql真是太難了，心好累。
2 回答
繁花如伊
TA貢獻(xiàn)2012條經(jīng)驗(yàn) 獲得超12個(gè)贊
兄弟，你這是mysql，開(kāi)始被你誤導(dǎo)啦
select a.* from mytable a,(select date(mydate) mydate,max(mydate) max_datetime from mytable where date(mydate) between '2014-07-23' and '2014-07-28' group by date(mydate)) bwhere a.mydate=b.max_datetimeand date(a.mydate)=b.mydate |
子衿沉夜
TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超3個(gè)贊
$mysqli->query("SELECT answer FROM FAQ WHERE question="hello"")這句里面出錯(cuò)了，修改的辦法有2種：
第一把雙引號(hào)內(nèi)部的雙引號(hào)轉(zhuǎn)義：
$mysqli->query("SELECT answer FROM FAQ WHERE question=\"hello\"");第二種把雙引號(hào)變成單引號(hào)：
$mysqli->query("SELECT answer FROM FAQ WHERE question='hello'");希望對(duì)你有所幫助！
添加回答
舉報(bào)
0/150
提交
取消