Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. Note mysql_real_escape_string() fails and produces an ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
Applicable Events Event Data Format MYSQL_AUDIT_COMMAND_START MYSQL_AUDIT_COMMAND_END command_id="id_value" MYSQL_AUDIT_GLOBAL_VARIABLE_GET MYSQL_AUDIT_GLOBAL_VARIABLE_SET name="var_value" value="var_value" MYSQL_AUDIT_QUERY_NESTED_START ... This ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-1-0.html
(Bug #36936407) When using PreparedStatements, negative DATE values were inserted as some positive values instead of being rejected. (Bug #113509, Bug #36154975) After using executeBatch() to insert rows into a table and adding more rows with ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements.html
If you do not know ahead of time whether the SQL statement will be a SELECT or an UPDATE/INSERT, then you can use the execute(String SQL) method. This method will return true if the SQL query was a SELECT, or false if it was an UPDATE, INSERT, or ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call to the stored procedure, passing parameters that can influence the procedure logic and query conditions, rather than issuing individual hardcoded ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-sql-command.html
This is because ExecuteNonQuery is only used for inserting, updating and deleting data. When a connection has been established with the MySQL database, the next step enables you to perform database operations. This task can be achieved through the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
#DELETED# Records Reported by Access Access reports records as #DELETED# when inserting or updating records in linked tables. If the inserted or updated records are shown as #DELETED# in Access, then: If you are using Access 2000, get and install ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-wordexcel.html
For example, to insert information from a table in the World test database into an Excel spreadsheet, using the DSN samples shown in Section 5.5, “Configuring Connector/ODBC”: Create a new Worksheet. Figure 5.34 Microsoft Query Wizard: Selecting ... You can use Microsoft Word and Microsoft Excel to access information from a MySQL database using ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-integrityerror.html
For example, a duplicate key was inserted or a foreign key constraint would fail. The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT ...