Perl Database 58 codes

  1. Home
  2. Perl
  3. Database
1 Available DBI Drivers and Data Sources
2 Binding Columns
3 Commit and Rollback
4 Connect to mysql
5 Connect to Oracle
6 Connect with OLE
7 Copying from One DBM Format to Another
8 Create, add, delete, and close a DBM file and how to create a Perl-style report
9 Creating a Web Page Integrated with SQL Data
10 Creating an HTML Table
11 Creating and Assigning Data to a DBM File
12 DBI ODBC
13 Delete a record from the database
14 Delete records in a database with OLE connection
15 Delete statement and DBI ODBC connection
16 Deleting Entries
17 Deleting Entries from a DBM File
18 Do() method prepares and executes nonselect, nonrepeating statements in one step
19 Dumping a Querys Results
20 Error Diagnostic Variables
21 Handling Quotes
22 Insert statement with DBI connection
23 Insert value with OLE connection
24 Inserting into a Database
25 Listing Currently Installed Drivers
26 Listing Valid DSNs
27 Load text file to database
28 MySQL Data Types
29 Open DBM up for read write access
30 Opening an MLDBM database is similar to opening a regular DBM database
31 Preparing a Statement Handle and Fetching Results
32 Program to insert a new record into the database
33 Pushing Query Results to an Array to Find Wildcard Hosts
34 Query a database and display the contents in a table
35 Query parameter binding
36 Reads DBM file, printing entries with tie and untie function
37 Retrieving an Index ID
38 Retrieving Data from a DBM File
39 Retrieving Query Results Listing MySQL Users and Hosts
40 Select, Execute, and Dump the Results
41 Select, Execute, and Fetch a Row as a Hash
42 Select, Execute, and Fetch a Row as an Array
43 Simple Inserts
44 Simple query
45 Store hashes in a DBM file
46 Talking with the Database
47 The connect() Method
48 The First SQL Query
49 Update a record in the database
50 Update record with OLE connection
51 Update statement and DBI ODBC connection
52 Use DBI to connect to a database
53 Using a Placeholder
54 Using DBM databases with reports
55 Using Multiple Placeholders
56 Using Placeholders to Insert Multiple Records
57 Write out data into a DBM database
58 Writing Portable DBM Programs with the AnyDBM Module