in reply to Inserting hash keys to MySQL field names using DBI
See SQL::Abstract for the syntax, which DBIx::Simple uses for its implementation.use DBIx::Simple; $db = DBIx::Simple->connect(...); # just as with DBI $db->insert($table, \%hash);
Behind the curtains, it builds and prepares statements using placeholders, and it keeps a pool of cached statement holders, so repeated use of calls will be quite efficient: it'll try to avoid preparing the same statement over and over again.
|
|---|