in reply to Using MySQL table's default values upon insert

You can assign default value to $blah in Perl code before execute.

$blah="NA" unless defined $blah;

Replies are listed 'Best First'.
Re^2: Using MySQL table's default values upon insert
by Zettai (Acolyte) on Jan 30, 2010 at 20:37 UTC
    Thanks Zwon, this is a nice and easy solution if I know what the default value is in the database.