Data

Copy and paste the text below. It is read-only. Select All

Use the ____ function to open a connection to a mysql database server mysql_connect() You close a database connection by passing the database connection variable to the _____ function mysql_close() How many error indicator functions are there 5 You can suppress those messages by using the __ ___ ___ error control operator (@) You select a database or change to a different databae with the ____ function mysql_select_db() The php function to query a database is mysql_query To add records to a table, you use the the mysql keyword _____ insert The mysql_query function accepts what two parameters connection and query The ___ function opens a connection to a MySQL database server mysql_connect() The ___ function closes a database connection mysql_close() The ___ function returns the error code from the last attempted MySQL function call or zero if no error occured mysql_errno() The ___ function returns the error message from the last attemped MySQL function call or returns an empty string if no error occured mysql_error() The ___ and ____ functions terminate script execution die() and exit() The error contorl operator ____ error messages suppresses You use the ____ function select a database mysql_select_db() The ____ function selects a database mysql_drop_db() The ____ function sends SQL statements to MySQL mysql_query() A ___ ___ is a special type of variable that refers to the currently selected row in a resultset result pointer You use the ___ ___ statement with the mysql_query() function to creat a table CREATE TABLE The ___ ___ clause indicates a field or fields that will be used as a referential index for the table PRIMARY KEY The _______ clause creates a field that is automatically updated with the next sequentila value for that column AUTO_INCREMENT The ___ ____ clause creates a field that must contain data NOT NULL You usethe ___ ___ statement with the mysql_query() function to delete a table DROP TABLE You use the ___ ___ statement and the mysql_query() function with a local text file to add multiple records to a database LOAD DATA You can use the ___ statement with the mysql_query() function to update records in a table UPDATE You use the the ___ statement with the mysql_query() function to delete records from a table DELETE The ____ function returns the number of operations for various types of actions, depending on the type of query mysql_info() The ___ fucntion retunrs the fields in the current row of a resultset into an indexed array and moves the result pointer to the next row mysql_fetch_row() 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 mysql_fetch_assoc() The ____ function closes a resultset mysql_free_result()