HostPapa.com 100% Green Energy Web Hosting

Looking for somewhere to host your site? Browse our PHP web hosts section!

Home > Quick Reference Library > MySQL Functions

MySQL Functions

mysql_affected_rows
Get number of affected rows in previous MySQL operation
mysql_change_user
Change logged in user of the active connection
mysql_client_encoding
Returns the name of the character set
mysql_close
Close MySQL connection
mysql_connect
Open a connection to a MySQL Server
mysql_create_db
Create a MySQL database
mysql_data_seek
Move internal result pointer
mysql_db_name
Get result data
mysql_db_query
Send a MySQL query
mysql_drop_db
Drop (delete) a MySQL database
mysql_errno
Returns the numerical value of the error message from previous MySQL operation
mysql_error
Returns the text of the error message from previous MySQL operation
mysql_escape_string
Escapes a string for use in a mysql_query
mysql_fetch_array
Fetch a result row as an associative array, a numeric array, or both
mysql_fetch_assoc
Fetch a result row as an associative array
mysql_fetch_field
Get column information from a result and return as an object
mysql_fetch_lengths
Get the length of each output in a result
mysql_fetch_object
Fetch a result row as an object
mysql_fetch_row
Get a result row as an enumerated array
mysql_field_flags
Get the flags associated with the specified field in a result

More MySQL functions