如何将alasql输出设置为Array

Question

我需要将alasql输出设置为Array。有可能吗？

我找不到任何方法

​

var pre = document.getElementById('pre');
var keys = Object.keys(alasql).map(function(e) {
  return [e];
});
var qLikes = alasql('SELECT * FROM ? WHERE [0] LIKE "%uery%"', [keys]);
pre.innerHTML = JSON.stringify(qLikes, null, ' ');
var pre = document.getElementById('pre');

<script src="https://cdn.rawgit.com/agershun/alasql/develop/dist/alasql.min.js"></script>
<pre id="pre"></pre>

​

Answer 1

使用AlaSQL，您可以将COLUMN OF添加到SQL中，以获得一个值数组，该数组表示数据集中的第一列。

var qLikes = alasql('COLUMN OF SELECT * FROM ? WHERE [0] LIKE "%uery%"', [keys]);

示例

​

var pre = document.getElementById('pre');
var keys = Object.keys(alasql).map(function(e) {
  return [e];
});
var qLikes = alasql('COLUMN OF SELECT * FROM ? WHERE [0] LIKE "%uery%"', [keys]);
pre.innerHTML = JSON.stringify(qLikes, null, ' ');
var pre = document.getElementById('pre');

<script src="https://cdn.rawgit.com/agershun/alasql/develop/dist/alasql.min.js"></script>
<pre id="pre"></pre>

​