Re^2: MySQL INSERT in Perl

use SQL::Abstract;
my $SQL = SQL::Abstract->new;

...

my ($sql, @bind) = $SQL->insert ($table, \%h1);
$dbh->do ($sql, {}, @bind);
[download]

Comment on Re^2: MySQL INSERT in Perl Download Code

Replies are listed 'Best First'.
Re^3: MySQL INSERT in Perl by baperl (Sexton) on Aug 04, 2011 at 15:00 UTC
thx superdoc, I'm not sure I fully understand how that will work... also, it seems like I should replace prepare/execute with do()?	[reply]
Re^4: MySQL INSERT in Perl by happy.barney (Friar) on Aug 05, 2011 at 09:17 UTC
SQL::Abstract generates (simple) sql statement from perl data structures. Yes, you can replace prepare/execute everywhere you don't care about returned rows or rows are not returned, like insert/update/delete without returning clause. See DBI#do	[reply]
Re^5: MySQL INSERT in Perl by baperl (Sexton) on Aug 05, 2011 at 12:28 UTC
sounds good...thanks!	[reply]