$dbh->do ("CREATE TABLE bookplateleaf (id integer PRIMARY KEY AUTOINCREMENT, name varchar(20), ) "); my $insert_name = prepare ("INSERT into bookplateleaf name = ?"); $insert_name->execute("someNaME"); #### $dbh->do ("CREATE TABLE bookplateleaf (id integer PRIMARY KEY AUTOINCREMENT, name varchar(20), box varchar(8192), ) "); my $insert_row = prepare ("INSERT into bookplateleaf name = ?, box = ? "); $insert_row->execute($name,$box);