DBI/PERL Tutorial over the Web

Click to go to the PREVIOUS page. Click to go to the INDEX page. Click to go to the NEXT page.

SLIDE #4 CREATE TABLE 


In this fourth slide, we recreate the table.

1. THE CREATE TABLE STATEMENT:

#Create table
        $statement="create table studios (id char(5), name char(20), 
		city char(20), state char(2))";
        $sth=$dbh->prepare($statement);
        $rv=$sth->execute;
        print $statement."<br>";

2. FORM DESCRIPTION:

The first line defines the SQL statement.

The second line creates a statement object, calling the prepare method on the 
database object, and using the statement as parameter.

The third line calls the execute method on the  statement object

The fourth line displays the statement.


© Copyright 2002 International Customized Software Co.