Filter::SQL - search.cpan.org
{img:CPAN}[=>]
Home[=>]
· Authors[=>]
· Recent[=>]
· News[=>]
· Mirrors[=>]
· FAQ[=>]
· Feedback[=>]
in All Modules Distributions Authors permalink[=>]
Kazuho Oku[=>]
> Filter-SQL-0.03[=>]
> Filter::SQL
Download: Filter-SQL-0.03.tar.gz[=>]
Dependencies[=>]
Annotate this POD [=>]
CPAN RT
Open 0 Report a bug[=>]
Module Version: 0.03 Source[=>]
Latest Release: Filter-SQL-0.10[=>]
NAME[=>]
SYNOPSIS[=>]
SYNTAX[=>]
"SELECT" statement[=>]
"SELECT ROW" statement[=>]
"EXEC" statement[=>]
"INSERT" statement =head2 "UPDATE" statement =head2 "DELETE" statement =head2 "REPLACE" statement[=>]
VARIABLE SUBSTITUTION[=>]
AUTHOR[=>]
COPYRIGHT AND LICENSE[=>]
NAME {img:^}[=>]
Filter::SQL - embedded SQL for perl SYNOPSIS {img:^}[=>]
use Filter::SQL; Filter::SQL->dbh(DBI->connect('dbi:...')) or die DBI->errstr; EXEC CREATE TABLE t (v int not null);; $v = 12345; INSERT INTO t (v) VALUES ($v);; foreach my $row (SELECT * FROM t;) { print "v: $row[0]\n"; } if (SELECT ROW COUNT(*) FROM t; == 1) { print "1 row in table\n"; } SYNTAX {img:^}[=>]
Filter::SQL recognizes portion of source code starting from one of the keywords below as an SQL statement, terminated by a semicolon. SELECT SELECT ROW EXEC INSERT UPDATE DELETE REPLACE "SELECT" statement[=>]
Executes a SQL SELECT statement. Returns an array of rows. my @row = SELECT * FROM t;; "SELECT ROW" statement[=>]
Executes a SQL SELECT statement and returns the first row. my @column_values = SELECT ROW * FROM t;; my $sum = SELECT ROW SUM(v) FROM t;; "EXEC" statement[=>]
Executes following string as a SQL statement and returns statement handle. EXEC DROP TABLE t;; my $sth = EXEC SELECT * FROM t;; while (my @row = $sth->fetchrow_array) { ... } "INSERT" statement =head2 "UPDATE" statement =head2 "DELETE" statement =head2 "REPLACE" statement[=>]
Executes a SQL sta
■Next Page
･Full Browser
en.abc-yoga.podzone.org | Contact