30 terms

207LastReviewSmallerSet

STUDY
PLAY
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()