MySql is a free and most powerful database. It works very well in combination of various programming languages
like PERL, C, C++, JAVA and PHP. Many developers in the world selected mysql and php for
web development because of its web application development capabilities.
Here is the list of useful mysql functions in PHP :
1. mysql_affected_rows : Using this function you can get number of affected rows in previous MYSQL operation.
2. mysql_change_user : Using this function you can change logged in user of the active connection.
3.mysql_client_encoding : This function returns the name of characterset.
4. mysql_close : Using this function you can close database connection.
5. mysql_connect : Using this function you can connect database connection.
6. mysql_create_db : Using this function you can create MYSQL database.
7. mysql_data_seek : Help of the function you can move internal result pointer.
8. mysql_db_name : Using this function you can get data.
9. mysql_db_query : Help of the function you can send MYSQL query.
10. mysql_drop_db : Using this function you can drop(delete) a MYSQL Database.
11. mysql_errno: This function returns the numerical value of the error message from previous MYSQL operation.
12. mysql_error: This function returns the text of the error message from previous MYSQL operation.
13. mysql_escape_string: Using this function escapes a string for use in mysql_query.
14. mysql_fetch_array: Help of the function you can get a result row as an associative array, a numeric array, or both.
15. mysql_fetch_assoc: Using the function you can fetch result row as an associative array.
16. mysql_fetch_field: Using the function you can get column information from a database table and return as an object.
17. mysql_fetch_lengths : You can get the length of output in a result.
18. mysql_fetch_object : You can get the database table row as an object.
19. mysql_fetch_row: You can fetch a result row as an enumerated array.
20. mysql_field_flags: You can get flag associated with the specified field in the database table.
21. mysql_field_len: This function returns the length of specified field.
22.mysql_field_name: You can get the name of the specified field from the database table.
23. mysql_field_seek : You can set result pointer to a specified field offset.
24. mysql_field_table: You can get name of table the specified field is in.
25. mysql_field_type : You can get the type of the specified field in result.
26. mysql_free_result :Using the function Free result memory
27. mysql_get_client_info : Help of the function you can Get MySQL client info
28. mysql_get_host_info : You can Get MySQL host info
29. mysql_get_proto_info : You can Get MySQL protocol info
30. mysql_get_server_info : You can fetch MySQL server info
31. mysql_info : You can receive information about the most recent query
32. mysql_insert_id : You can receive the ID generated from the previous INSERT operation
33. mysql_list_dbs : Help of the function you can create List databases available on a MySQL server
34. mysql_list_fields : Using this function you can create List MySQL table fields
35. mysql_list_processes : You can create List MySQL processes
36. mysql_list_tables : You can create List tables in a MySQL database
37.mysql_num_fields : You can receives number of fields in result
38.mysql_num_rows : You can fetch number of rows in result
39.mysql_pconnect : Help of the function Open a persistent connection to a MySQL server
40.mysql_ping : Ping a server connection or reconnect if there is no connection
41.mysql_real_escape_string : Using this function Escapes
special characters in a string for use in a SQL statement, taking into
account the current charset of the connection.
42.mysql_result : You can fetch result data
43.mysql_select_db : Using this function you can Select a MySQL database
44.mysql_stat : Help of the function Get current system status
45.mysql_tablename : Help of the function you can Get table name of field
46.mysql_thread_id : This function Return the current thread ID
47.mysql_unbuffered_query : This function Send an SQL query to MySQL, without fetching and buffering the result rows
0 comments:
Post a Comment