Exam 8: Manipulating Mysql Databases With Php

To prevent code from trying to create a table that already exists, use the SHOW EXISTING TABLES command.

To close the resultset, use ____.

The mysql_fetch_row() function returns the fields in the current row of a resultset into an indexed array and moves the result pointer to the next row.

The first record added to a table that has an auto-incrementing primary key will be assigned a value of 0.

To update records in a table, use the UPDATE, SET, and WHERE keywords with the mysql_query() function.

The mysql_connect() function returns a ____________________ as an integer if it connects successfully to a database or a Boolean FALSE if it doesn't.

To delete a table, use the ____________________ statement with the mysql_query() function.

You select a database or change to a different database with the ____ function.

The ___ keyword, often used with the primary key, requires that the field include a value.

The mysql_free_result() function ____________________ the resultset.

Because the client and server are defined in relation to MySQL, the Web server where the PHP script is running is the ____________________ when communicating with the MySQL server.

The first field created using the AUTO_INCREMENT keyword is assigned a value of ____________________.

The symbol (@), used to suppress error messages, is called ____.

The ____________________ function returns the number of operations for various types of actions, depending on the type of query.

The function ____ returns the fields in the current row into an indexed array.

The ____________________ is a special type of variable that refers to the currently selected row in records returned by MySQL.

The function ____ returns the fields in the current row of a resultset into an associative array and moves the result pointer to the next row.

The list of records that is returned from a mysql_query() is a called a ____.

The mysql_info() function returns the number of operations for various types of actions, depending on the type of query.

Although they perform similar functions, PEAR DB is designed specifically to work with PHP and ____________________ is a more generic protocol used by many programming languages and database management systems.