All pastes #733195 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-10-11 16:37 UTC
rendered paste body
#!/usr/bin/perl

use strict;
use DBI;

my $dbh = DBI->connect( 'dbi:mysql:mysql',
                        'blue',
                        'bluepassword',
                        {
                          RaiseError => 1,
                          AutoCommit => 0
                        }
                      ) || die "Database connection not made: $DBI::errstr";

my $sql = qq{ CREATE TABLE employees ( id INTEGER NOT NULL, 
                                       name VARCHAR2(128), 
                                       title VARCHAR2(128), 
                                       phone CHAR(8) 
                                     ) };
$dbh->do( $sql );

$dbh->disconnect();