select_some_field

来自「一个俄国人实现的数据库系统」· 代码 · 共 19 行

#!/usr/local/bin/perl -w
use strict;
use DBI;
my $host='localhost';
my $port=6100;
my $dbh = DBI->connect(
  "dbi:Gigabase:host=$host;port=6100",
    "guest", "guest",{AutoCommit=>1}) 
   || die ;
my $select=$dbh->prepare('select one,name from r')
 || die $dbh->err_msg;
print "prepared\n";
$select->execute('3');
while ( my($name,$one)=$select->fetchrow_array) {
  print "$name, $one\n";
}
$dbh->disconnect;
print "disconnected\n";