SQLiteを使ã£ãŸãƒ†ã‚¹ãƒˆã®tipsDB周りã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’開発ã—ã¦ã„ã‚‹å ´åˆã€ãƒ†ã‚¹ãƒˆDBã«SQLiteを使ã†äº‹ãŒè‰¯ãã‚ã‚Šã¾ã™ã€‚ ãã®éš›ã€æ™®é€šã§ã‚ã‚Œã°ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã‚’書ãã¨æ€ã„ã¾ã™ use Test::More tests => 1; use DBI; do { # SQLiteã§ä½¿ã†ãƒ•ã‚¡ã‚¤ãƒ«ã‚’指定 my $dbh = DBI->connect('dbi:SQLite:./test.db','',''); $dbh->do(q{CREATE TABLE foo (id INT, name TEXT)}); $dbh->do(q{INSERT INTO foo (id, name) VALUES (10,'nekokak')}); my $sth = $dbh->prepare('SELECT * FROM foo'); $sth->execute; my $row = $sth->fetchrow_hashref();
{{#tags}}- {{label}}
{{/tags}}