如果我有下面的代码,我怎么把我的循环值放到一个数组中呢? for row in db:nrows("SELECT song.id, song.title as title, artist.name as name FROM song, artist where song.artist_id = artist.id") do song = row.title, }}unexpected symbol near 'for'
我想要创建一个视图,使查询更加容易。但我有麻烦了。由于视图中使用的表包含大约100.000行,而且我要连接其中的四行,所以视图必须使用合并算法。但根据
选择列表中的子查询(SELECT id FROM payments WHER contract_id = val ORDER BY id DESC LIMIT