Skip navigation links
MySQL 3.23, 4.0, 4.1 Reference Manual :: 17 Connectors and APIs :: 17.6 MySQL C API :: 17.6.7 C API Prepared Statement Function Descriptions
17.6.7.1 mysql_stmt_affected_rows() »
Section Navigation      [Toggle]

17.6.7. C API Prepared Statement Function Descriptions

[+/-]

17.6.7.1. mysql_stmt_affected_rows()
17.6.7.2. mysql_stmt_attr_get()
17.6.7.3. mysql_stmt_attr_set()
17.6.7.4. mysql_stmt_bind_param()
17.6.7.5. mysql_stmt_bind_result()
17.6.7.6. mysql_stmt_close()
17.6.7.7. mysql_stmt_data_seek()
17.6.7.8. mysql_stmt_errno()
17.6.7.9. mysql_stmt_error()
17.6.7.10. mysql_stmt_execute()
17.6.7.11. mysql_stmt_fetch()
17.6.7.12. mysql_stmt_fetch_column()
17.6.7.13. mysql_stmt_field_count()
17.6.7.14. mysql_stmt_free_result()
17.6.7.15. mysql_stmt_init()
17.6.7.16. mysql_stmt_insert_id()
17.6.7.17. mysql_stmt_num_rows()
17.6.7.18. mysql_stmt_param_count()
17.6.7.19. mysql_stmt_param_metadata()
17.6.7.20. mysql_stmt_prepare()
17.6.7.21. mysql_stmt_reset()
17.6.7.22. mysql_stmt_result_metadata()
17.6.7.23. mysql_stmt_row_seek()
17.6.7.24. mysql_stmt_row_tell()
17.6.7.25. mysql_stmt_send_long_data()
17.6.7.26. mysql_stmt_sqlstate()
17.6.7.27. mysql_stmt_store_result()

To prepare and execute queries, use the functions described in detail in the following sections.

Note

In MySQL 4.1.2, the names of several prepared statement functions were changed, as shown here:

Old Name New Name
mysql_bind_param() mysql_stmt_bind_param()
mysql_bind_result() mysql_stmt_bind_result()
mysql_prepare() mysql_stmt_prepare()
mysql_execute() mysql_stmt_execute()
mysql_fetch() mysql_stmt_fetch()
mysql_fetch_column() mysql_stmt_fetch_column()
mysql_param_count() mysql_stmt_param_count()
mysql_param_result() mysql_stmt_param_metadata()
mysql_get_metadata() mysql_stmt_result_metadata()
mysql_send_long_data() mysql_stmt_send_long_data()

All functions that operate with a MYSQL_STMT structure begin with the prefix mysql_stmt_.

Also in 4.1.2, the signature of the mysql_stmt_prepare() function was changed to int mysql_stmt_prepare(MYSQL_STMT *stmt, const char *query, unsigned long length). To create a MYSQL_STMT handle, you should use the mysql_stmt_init() function.