MySQL - MySQL API offers a number of functions

MySQL API offers a number of functions. Explain them

Following are the list of functions:

1. mysql_connect -- Open a connection to a MySQL Server
2. mysql_get_client_info -- Get MySQL client info
3. mysql_get_host_info -- Get MySQL host info
4. mysql_get_server_info -- Get MySQL server info
5. mysql_close -- Close MySQL connection
6. mysql_list_dbs -- List databases available on a MySQL server
7. mysql_fetch_object -- Fetch a result row as an object
8. mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both
9. mysql_query -- Send a MySQL query
10. mysql_errno -- Returns the numerical value of the error message from previous MySQL operation
11. mysql_error -- Returns the text of the error message from previous MySQL operation
12. mysql_select_db -- Select a MySQL database
13. mysql_num_rows -- Returns the number of rows selected in a result set object returned from SELECT statement
14. mysql_affected_rows -- Returns the number of rows affected by the last INSERT, UPDATE or DELETE statement
15. mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both
16. mysql_free_result -- Free result memory
17. mysql_list_tables -- List tables in a MySQL database
18. mysql_list_fields -- List MySQL table fields
MySQL - Explain how to close MySQL connection objects
Explain how to close MySQL connection objects - MySQL connection objects created with mysql_connect() calls can be closed by calling mysql_close($con) function......
MySQL - Explain how to handle MySQL statement execution errors
Explain how to handle MySQL statement execution errors - When a MySQL statement is executed using mysql_query(), a FALSE Boolean value is returned if any error occurred......
MySQL - What are storage engines? Explain storage engines supported
What are storage engines? Explain storage engines supported - Storage engines are used to manage the database of the MySQL.......
Post your comment