{"provider_name":"Hatena Blog","url":"https://arupaka-arupaka.hatenadiary.org/entry/20141008/1412741669","blog_title":"arupaka-_-arupaka\u306e\u65e5\u8a18","published":"2014-10-08 13:14:29","title":"ruby\u304b\u3089sqlite","categories":["ruby","sql"],"author_name":"arupaka-_-arupaka","width":"100%","type":"rich","provider_url":"https://hatena.blog","blog_url":"https://arupaka-arupaka.hatenadiary.org/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Farupaka-arupaka.hatenadiary.org%2Fentry%2F20141008%2F1412741669\" title=\"ruby\u304b\u3089sqlite - arupaka-_-arupaka\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","description":"\u6e96\u5099 yum install sqlite gem install sqllite3 \u4ee5\u4e0b\u306e\u30d5\u30a1\u30a4\u30eb\u3092table\u306b\u3064\u3081\u308b\uff0e food_list.txt 1,xxx 2,yyy 3,zzz 4,aaa \u78ba\u8a8d \u30b3\u30fc\u30c9 require 'rubygems' require 'sqlite3' db=SQLite3::Database.new(\"syoku.sqlite3\") db.execute(\"drop table if exists food_list\") db.execute(\"create table if not exists food_list(id integer,foodname \u2026","author_url":"https://blog.hatena.ne.jp/arupaka-_-arupaka/","version":"1.0","image_url":null}