Some of the MySQL functions

Source: Internet
Author: User
Tags mysql functions

Mysql_affected_rows: Gets the number of columns affected by MySQL last operation.
Mysql_close: Close the MySQL server connection.
Mysql_connect: Open the MySQL server connection.
mysql_create_db: Create a new MySQL database.
Mysql_data_seek: Moves the internal return pointer.
Mysql_db_query: Send query string to MySQL database.
mysql_drop_db: Remove the database.
Mysql_errno: Returns the error message code.
Mysql_error: Returns an error message.
Mysql_fetch_array: Returns the array data.
Mysql_fetch_field: Gets the field information.
Mysql_fetch_lengths: Returns the maximum length of the column data in a single column.
Mysql_fetch_object: Returns the class data.
Mysql_fetch_row: Returns the fields of a single column.
Mysql_field_name: Returns the name of the specified field.
Mysql_field_seek: Configures a pointer to a field that returns a value.
Mysql_field_table: Gets the table name of the current field (table).
Mysql_field_type: Gets the type of the current field.
Mysql_field_flags: Gets the flag for the current field.
Mysql_field_len: Gets the length of the current field.
Mysql_free_result: Release returns memory consumption.
MYSQL_INSERT_ID: Returns the ID of the last use of the Insert Directive.
Mysql_list_fields: Lists the fields (field) for the specified table.
Mysql_list_dbs: Lists the databases available to the MySQL server.
Mysql_list_tables: Lists the data table (table) for the specified database.
Mysql_num_fields: Gets the number of return fields.
Mysql_num_rows: Gets the number of returned columns.
Mysql_pconnect: Open the MySQL server for persistent connections.
Mysql_query: Sends out a query string.
Mysql_result: Gets the result of the query.
mysql_select_db: Select a database.
Mysql_tablename: Gets the table name.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.