Organizational Research By

Surprising Reserch Topic

what is the most important List Of Mysql Fucntions


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
asked Jul 7, 2015 in MYSQL by rajesh
0 votes
69 views



Related Hot Questions



Government Jobs Opening


...