Perl DBI

Introduction

Get documentation on the version of DBI you have on your system via

    perldoc DBI

The perldoc for the most recent version is on the web at http://search.cpan.org/~timb/DBI/DBI.pm.

Getting Started

Handles

Methods

Driver ($drh->)	connect connect_cached disconnect_all data_sources default_user
Connection ($dbh->)	data_sources take_imp_data clone connected begin_work commit rollback do last_insert_id preparse prepare prepare_cached selectrow_array selectrow_arrayref selectrow_hashref selectall_arrayref selectall_hashref selectcol_arrayref ping disconnect quote quote_identifier rows tables table_info column_info primary_key_info primary_key foreign_key_info type_info_all type_info get_info
Statement ($sth->)	bind_col bind_columns bind_param bind_param_inout execute bind_param_array bind_param_inout_array execute_array execute_for_fetch fetch fetchrow_arrayref fetchrow_hashref fetchrow_array fetchrow fetchall_arrayref fetchall_hashref blob_read blob_copy_to_file dump_results more_results finish cancel rows
Common	DESTROY CLEAR EXISTS FETCH FIRSTKEY NEXTKEY STORE can debug dump_handle err errstr state func parse_trace_flag parse_trace_flags private_data set_err trace trace_msg swap_inner_handle