データの結合 rowid は表明を指定して，onで結合しなきゃだめ。 select food_count_data.[2006-11-01],food_count_data.ROWID,food_list.ROWID,food_list.foodname from food_count_data join food_list on food_count_data.rowid=food_list.rowid;

sql cast演算 http://d.hatena.ne.jp/unageanu/20081121/1227265217 select [2014-02-01] || "さん" as "hontai",[2014-02-02]*1000 as "hentai" from food_count_data where cast([2014-02-02] as int) >= 2300 order by [2014-02-01] desc;

PRAGMA TABLE_INFO(TABLE_NAME);

入力データ 0_s.csv 2005-11-1,2005-11-1,43,31 2005-11-2,2005-11-3,44,33 2005-11-2,2005-11-3,45,32 ... 1_s.csv 2005-11-1,2005-11-1,3,1 2005-11-2,2005-11-3,4,3 2005-11-2,2005-11-3,5,2 ... ....3000_s.csvプログラム require 'rubygems' require 's…

Webブラウザで気軽に学ぶ実践SQL講座（1）：SQLとはどういう言語か - ＠IT http://www.atmarkit.co.jp/ait/articles/1112/19/news130.html