Summary of Perl DBI.pm
Four stages cycle of queries.
Methods of Fetching
- Prepare
- Execute
- Fetch
- De-allocation
Methods of Fetching
| method | return | remark |
| fetchrow_array | @row | |
| fetchrow_arraryref | $row_arraryref | |
| fetchrow_hashref | $row_hashref | |
| dump_results | ||
| selectrow_array | @row | Only single row |
| selectrow_arrayref | $row_arrayref | Only single row |
| fetchall_arraryref | $resultset_arraryref | The entire results set |
| fetchall_hashref | $resultset_hashref | The entire set |
| fetch | @row | Used with bind_col/bind_columns |
