Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Displaying posts with tag: kdb (reset)

Jun

2018

Posted by mysql-云栖社区 on Sun 17 Jun 2018 07:16 UTC
Tags:

sql, group, kdb, by, MySQL, 数据库, 排序, kdb+

mysql里一条包含分组，排序，取前n条的sql语句如下

select create_time,price,sum(num) num from t1 WHERE sid="a" AND rid="b" GROUP BY price ORDER BY price ASC,create_time A...

【mysql】【SQL】【数据库】【排序】【BY】【Group】【KDB】 …

[获取更多]

Jun

2018

Posted by mysql-云栖社区 on Fri 15 Jun 2018 07:38 UTC
Tags:

kdb, test, MySQL, 数据库, UUID, 数组, exchange, Q语言

#需要预先创建表

test:([]uuid:`symbol$();create_time:`datetime$();price:`float$())

#从数据库里查询导出到文件

[获取更多]

Get Started Contributing