The Mysql module is not DBI. It looks like you're trying to combine the Mysql module's interface with the DBI interface. You should pick one or the other and check the documentation for it. (I suggest avoiding the Mysql module, since it seems out-of-date and DBI is more general.) There's lots of DBI info on PerlMonks and DBI comes with extensive documentation.