select id from xxx GROUP BY id order by id desc limit 2
怎么可能会有一样的呢 都GROUP BY掉了 我测试没问题的啊
怎么可能会有一样的呢 都GROUP BY掉了 我测试没问题的啊 如果每个内容*5 然后 select id(乘以5后的) from xxx GROUP BY id order by id desc limit 2 怎么写
select id*5 from xxx GROUP BY id order by id desc limit 2
说错了 id是时间戳 js把他变成了2014-01-22 然后 select id from xxx GROUP BY id order by id desc limit 2 怎么写
说错了 id是时间戳 js把他变成了2014-01-22 然后 select id from xxx GROUP BY id order by id desc limit 2 怎么写 还是一样的 就是把id全部改成时间就行了
说错了 id是时间戳 js把他变成了2014-01-22 然后 select id from xxx GROUP BY id order by id desc limit 2 怎么写 还是一样的 就是把id全部改成时间就行了 我想问有没有方便的方法现在要把id取出来 变成2014-01-22这种类型 然后再放到数据库表 然后再select id from xxx GROUP BY id order by id desc limit 2
获取最近2天的description内容不知道你要表达什么
SELECT * , FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) FROM `user` where datediff(date(now()), FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' ))< 2 ORDER BY FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) DESC
SELECT * , FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) FROM xxx WHERE DATEDIFF( DATE( NOW( ) ) , FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' ) ) <2 GROUP BY FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' ) ORDER BY FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) DESC
你数据库要不只有今天或者昨天的数据吧 建议你还是去好好自己学下sql语句吧select * from dede_archives where FROM_UNIXTIME(pubdate,'%Y-%m-%d') = (select FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by pubdate desc limit 1);我刚写的子查询。。为什么phpmyadmin运行报错了 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by p' at line 1
你数据库要不只有今天或者昨天的数据吧 建议你还是去好好自己学下sql语句吧查询最近1天的
SELECT * , FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) FROM xxx WHERE DATEDIFF( DATE( NOW( ) ) , FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' ) ) <1 GROUP BY FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' ) ORDER BY FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) DESC 2变成1就可以了啊 哎 你还是先学习吧
select * from dede_archives where FROM_UNIXTIME(pubdate,'%Y-%m-%d') = (select FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by pubdate desc limit 1);我刚写的子查询。。为什么phpmyadmin运行报错了 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by p' at line 1
如果每个内容*5 然后 select id(乘以5后的) from xxx GROUP BY id order by id desc limit 2
怎么写
说错了 id是时间戳 js把他变成了2014-01-22 然后 select id from xxx GROUP BY id order by id desc limit 2 怎么写
说错了 id是时间戳 js把他变成了2014-01-22 然后 select id from xxx GROUP BY id order by id desc limit 2 怎么写
还是一样的 就是把id全部改成时间就行了
说错了 id是时间戳 js把他变成了2014-01-22 然后 select id from xxx GROUP BY id order by id desc limit 2 怎么写
还是一样的 就是把id全部改成时间就行了 我想问有没有方便的方法现在要把id取出来 变成2014-01-22这种类型 然后再放到数据库表 然后再select id from xxx GROUP BY id order by id desc limit 2
获取最近2天的description内容不知道你要表达什么
FROM `user` where datediff(date(now()), FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' ))< 2
ORDER BY FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) DESC
FROM xxx
WHERE DATEDIFF( DATE( NOW( ) ) , FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' ) ) <2
GROUP BY FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' )
ORDER BY FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) DESC
看不懂怎么还是1条语句。。 GROUP BY不是用在数字相加么。。
建议你还是去好好自己学下sql语句吧
建议你还是去好好自己学下sql语句吧嗯我也是这么想的。。好好学下 一直没时间系统的学过。其实我想问你这个怎么分别输出到变量 我感觉用子查询比较适合我
建议你还是去好好自己学下sql语句吧select * from dede_archives where FROM_UNIXTIME(pubdate,'%Y-%m-%d') = (select FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by pubdate desc limit 1);我刚写的子查询。。为什么phpmyadmin运行报错了
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by p' at line 1
建议你还是去好好自己学下sql语句吧查询最近1天的
FROM xxx
WHERE DATEDIFF( DATE( NOW( ) ) , FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' ) ) <1
GROUP BY FROM_UNIXTIME( `pubdate` , '%Y-%m-%d' )
ORDER BY FROM_UNIXTIME( `pubdate` , '%Y%m%d' ) DESC
2变成1就可以了啊 哎 你还是先学习吧
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM_UNIXTIME(pubdate,'%Y-%m-%d') from dede_archives group by pubdate order by p' at line 1