Gecko [ georgetownmover.com ]

Name	Size	Permission	Date
mariadb_cancel.3	981 B	-rw-r--r--	2024-05-26 18:15
mariadb_connection.3	675 B	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_check.3	807 B	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_column_cmp_named.3	833 B	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_column_count.3	956 B	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_create_many_named.3	1.41 KB	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_create_many_num.3	1.4 KB	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_exists_named.3	857 B	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_exists_num.3	851 B	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_free.3	693 B	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_list_named.3	1.07 KB	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_list_num.3	1.09 KB	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_unpack.3	1.39 KB	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_update_many_named.3	1.23 KB	-rw-r--r--	2024-05-26 18:15
mariadb_dyncol_update_many_num.3	1.25 KB	-rw-r--r--	2024-05-26 18:15
mariadb_get_infov.3	6.8 KB	-rw-r--r--	2024-05-26 18:15
mariadb_reconnect.3	889 B	-rw-r--r--	2024-05-26 18:15
mariadb_rpl_close.3	685 B	-rw-r--r--	2024-05-26 18:15
mariadb_rpl_fetch.3	1.11 KB	-rw-r--r--	2024-05-26 18:15
mariadb_rpl_get_optionsv.3	1.11 KB	-rw-r--r--	2024-05-26 18:15
mariadb_rpl_open.3	596 B	-rw-r--r--	2024-05-26 18:15
mariadb_rpl_optionsv.3	1.08 KB	-rw-r--r--	2024-05-26 18:15
mariadb_stmt_execute_direct.3	2.56 KB	-rw-r--r--	2024-05-26 18:15
mariadb_stmt_fetch_fields.3	881 B	-rw-r--r--	2024-05-26 18:15
mysql_affected_rows.3	1.39 KB	-rw-r--r--	2024-05-26 18:15
mysql_autocommit.3	1.91 KB	-rw-r--r--	2024-05-26 18:15
mysql_change_user.3	1.96 KB	-rw-r--r--	2024-05-26 18:15
mysql_close.3	593 B	-rw-r--r--	2024-05-26 18:15
mysql_commit.3	880 B	-rw-r--r--	2024-05-26 18:15
mysql_data_seek.3	984 B	-rw-r--r--	2024-05-26 18:15
mysql_errno.3	899 B	-rw-r--r--	2024-05-26 18:15
mysql_error.3	1.04 KB	-rw-r--r--	2024-05-26 18:15
mysql_fetch_field.3	1.28 KB	-rw-r--r--	2024-05-26 18:15
mysql_fetch_field_direct.3	1.05 KB	-rw-r--r--	2024-05-26 18:15
mysql_fetch_fields.3	1.02 KB	-rw-r--r--	2024-05-26 18:15
mysql_fetch_lengths.3	1.15 KB	-rw-r--r--	2024-05-26 18:15
mysql_fetch_row.3	1.26 KB	-rw-r--r--	2024-05-26 18:15
mysql_field_count.3	1.19 KB	-rw-r--r--	2024-05-26 18:15
mysql_field_seek.3	1.12 KB	-rw-r--r--	2024-05-26 18:15
mysql_field_tell.3	770 B	-rw-r--r--	2024-05-26 18:15
mysql_free_result.3	854 B	-rw-r--r--	2024-05-26 18:15
mysql_get_character_set_info.3	1.04 KB	-rw-r--r--	2024-05-26 18:15
mysql_get_client_info.3	663 B	-rw-r--r--	2024-05-26 18:15
mysql_get_client_version.3	966 B	-rw-r--r--	2024-05-26 18:15
mysql_get_host_info.3	815 B	-rw-r--r--	2024-05-26 18:15
mysql_get_proto_info.3	759 B	-rw-r--r--	2024-05-26 18:15
mysql_get_server_info.3	868 B	-rw-r--r--	2024-05-26 18:15
mysql_get_server_version.3	806 B	-rw-r--r--	2024-05-26 18:15
mysql_get_socket.3	808 B	-rw-r--r--	2024-05-26 18:15
mysql_get_ssl_cipher.3	1.39 KB	-rw-r--r--	2024-05-26 18:15
mysql_hex_string.3	1.02 KB	-rw-r--r--	2024-05-26 18:15
mysql_info.3	1.46 KB	-rw-r--r--	2024-05-26 18:15
mysql_init.3	1.17 KB	-rw-r--r--	2024-05-26 18:15
mysql_kill.3	1.26 KB	-rw-r--r--	2024-05-26 18:15
mysql_more_results.3	1.19 KB	-rw-r--r--	2024-05-26 18:15
mysql_next_result.3	1.12 KB	-rw-r--r--	2024-05-26 18:15
mysql_num_fields.3	665 B	-rw-r--r--	2024-05-26 18:15
mysql_num_rows.3	919 B	-rw-r--r--	2024-05-26 18:15
mysql_options.3	982 B	-rw-r--r--	2024-05-26 18:15
mysql_options4.3	1023 B	-rw-r--r--	2024-05-26 18:15
mysql_optionsv.3	10.94 KB	-rw-r--r--	2024-05-26 18:15
mysql_ping.3	1.12 KB	-rw-r--r--	2024-05-26 18:15
mysql_query.3	1.43 KB	-rw-r--r--	2024-05-26 18:15
mysql_read_query_result.3	1 KB	-rw-r--r--	2024-05-26 18:15
mysql_real_connect.3	4.49 KB	-rw-r--r--	2024-05-26 18:15
mysql_real_escape_string.3	1.44 KB	-rw-r--r--	2024-05-26 18:15
mysql_real_query.3	1.22 KB	-rw-r--r--	2024-05-26 18:15
mysql_refresh.3	1.52 KB	-rw-r--r--	2024-05-26 18:15
mysql_reset_connection.3	1.43 KB	-rw-r--r--	2024-05-26 18:15
mysql_rollback.3	813 B	-rw-r--r--	2024-05-26 18:15
mysql_row_seek.3	1005 B	-rw-r--r--	2024-05-26 18:15
mysql_row_tell.3	789 B	-rw-r--r--	2024-05-26 18:15
mysql_select_db.3	1.77 KB	-rw-r--r--	2024-05-26 18:15
mysql_send_query.3	1.4 KB	-rw-r--r--	2024-05-26 18:15
mysql_server_end.3	781 B	-rw-r--r--	2024-05-26 18:15
mysql_server_init.3	1.03 KB	-rw-r--r--	2024-05-26 18:15
mysql_session_track_get_first.3	2.19 KB	-rw-r--r--	2024-05-26 18:15
mysql_session_track_get_next.3	1.69 KB	-rw-r--r--	2024-05-26 18:15
mysql_set_character_set.3	2.95 KB	-rw-r--r--	2024-05-26 18:15
mysql_set_server_option.3	1 KB	-rw-r--r--	2024-05-26 18:15
mysql_shutdown.3	1002 B	-rw-r--r--	2024-05-26 18:15
mysql_sqlstate.3	850 B	-rw-r--r--	2024-05-26 18:15
mysql_ssl_set.3	1.59 KB	-rw-r--r--	2024-05-26 18:15
mysql_stat.3	869 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_affected_rows.3	1.32 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_attr_get.3	2.01 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_attr_set.3	3.43 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_bind_param.3	1.4 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_bind_result.3	1.17 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_close.3	999 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_data_seek.3	1016 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_errno.3	935 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_error.3	1.02 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_execute.3	1.12 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_fetch.3	1.29 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_fetch_column.3	1.14 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_field_count.3	955 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_free_result.3	619 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_init.3	1.08 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_insert_id.3	1.08 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_more_results.3	1.01 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_next_result.3	1.09 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_num_rows.3	923 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_param_count.3	915 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_param_metadata.3	598 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_prepare.3	1.74 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_reset.3	1.11 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_result_metadata.3	1.55 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_row_seek.3	1005 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_row_tell.3	949 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_send_long_data.3	1.49 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_sqlstate.3	972 B	-rw-r--r--	2024-05-26 18:15
mysql_stmt_store_result.3	1.01 KB	-rw-r--r--	2024-05-26 18:15
mysql_stmt_warning_count.3	1019 B	-rw-r--r--	2024-05-26 18:15
mysql_store_result.3	1.1 KB	-rw-r--r--	2024-05-26 18:15
mysql_thread_end.3	864 B	-rw-r--r--	2024-05-26 18:15
mysql_thread_id.3	916 B	-rw-r--r--	2024-05-26 18:15
mysql_thread_init.3	1.03 KB	-rw-r--r--	2024-05-26 18:15
mysql_use_result.3	1.36 KB	-rw-r--r--	2024-05-26 18:15
mysql_warning_count.3	987 B	-rw-r--r--	2024-05-26 18:15

Rename

.\" Automatically generated by Pandoc 2.5
.\"
.TH "mariadb_stmt_execute_direct" "3" "" "Version 3.3.1" "MariaDB Connector/C"
.hy
.SS Name
.PP
mariadb_stmt_execute_direct \- prepares and executes a prepared
statement
.SS Synopsis
.IP
.nf
\f[C]
#include <mysql.h>

int mariadb_stmt_execute_direct(MYSQL_STMT * stmt,
                                const char *query,
                                size_t length);
\f[R]
.fi
.SS Description
.PP
Prepares and executes a statement which was previously allocated by
\f[B]mysql_stmt_init(3)\f[R], using the current values of the parameter
variables if any parameters exist in the statement.
.SS Parameters
.IP \[bu] 2
\f[C]stmt\f[R] \- A statement handle, which was previously allocated by
\f[B]mysql_stmt_init(3)\f[R].
.IP \[bu] 2
\f[C]query\f[R] SQL statement
.IP \[bu] 2
\f[C]length\f[R] Length of SQL statement
.SS Return value
.PP
Returns zero on success, non\-zero on failure.
.SS Notes
.IP \[bu] 2
Since the number of parameter of the statement is unknown before
execution it is mandatory to set the number of parameters via the
\f[B]mysql_stmt_attr_set(3)\f[R] function.
.IP \[bu] 2
If the SQL statement is a zero\-terminated string, you can also pass
\f[C]\-1\f[R] as length.
.IP \[bu] 2
The statement handle is intended for one\-time execution.
Reusing the statement handle might lead to unexpected behavior.
.SS History
.PP
This function was added in Connector/C 3.0 and requires MariaDB 10.2 or
later versions.
.SS See Also
.IP \[bu] 2
\f[B]mysql_stmt_attr_set(3)\f[R]
.IP \[bu] 2
\f[B]mysql_stmt_bind_param(3)\f[R]
.SS Example
.PP
\[ga]\[ga]\[ga]C static int execute_direct_example(MYSQL \f[I]mysql) {
MYSQL_STMT \f[R]stmt= mysql_stmt_init(mysql); MYSQL_BIND bind[2]; int
intval= 1; int param_count= 2; char *strval=
\[lq]execute_direct_example\[rq];
.PP
/* Direct execution without parameters */ if
(mariadb_stmt_execute_direct(stmt, \[lq]CREATE TABLE execute_direct (a
int, b varchar(30))\[rq], \-1)) goto error;
.PP
memset(&bind, 0, sizeof(MYSQL_BIND) * 2); bind[0].buffer_type=
MYSQL_TYPE_SHORT; bind[0].buffer= &intval; bind[1].buffer_type=
MYSQL_TYPE_STRING; bind[1].buffer= strval; bind[1].buffer_length=
strlen(strval);
.PP
/* set number of parameters */ if (mysql_stmt_attr_set(stmt,
STMT_ATTR_PREBIND_PARAMS, &param_count)) goto error;
.PP
/* bind parameters */ if (mysql_stmt_bind_param(stmt, bind)) goto error;
.PP
if (mariadb_stmt_execute_direct(stmt, \[lq]INSERT INTO execute_direct
VALUES (?,?)\[rq], \-1)) goto error;
.PP
mysql_stmt_close(stmt); return 0; error: printf(\[lq]Error: %s\[rq],
mysql_stmt_error(stmt)); mysql_stmt_close(stmt); return 1; }