Search Results
https://dev.mysql.com/doc/refman/8.4/en/year.html
The result of inserting a numeric 0 has a display value of 0000 and an internal value of 0000. To insert zero and have it be interpreted as 2000, specify it as a string '0' or '00'. In strict SQL mode, attempting to insert an invalid YEAR value ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
Ndb_conflict_fn_max_ins: Number of times that NDB replication conflict resolution based on "greater timestamp wins" has been applied to insert operations. Ndb_conflict_fn_max_del_win_ins: Number of times that NDB replication conflict resolution ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
Here is a simple example that inserts DATE, TIME, and TIMESTAMP data. The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME structure. The members ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-info.html
String format: Records: 100 Duplicates: 0 Warnings: 0 INSERT INTO ... String format: Records: 3 Duplicates: 0 Warnings: 0 LOAD DATA String format: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 ALTER TABLE String format: Records: 3 Duplicates: 0 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-send-long-data.html
It inserts the data value 'MySQL - The most popular Open Source database' into the text_column column. bool mysql_stmt_send_long_data(MYSQL_STMT *stmt, unsigned int parameter_number, const char *data, unsigned long length) Description Enables an ...
https://dev.mysql.com/doc/c-api/8.4/en/query-results.html
In addition to the result set returned by a query, you can also get the following information: mysql_affected_rows() returns the number of rows affected by the last query when doing an INSERT, UPDATE, or DELETE. mysql_insert_id() returns the ID ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
For aggregate functions that work like SUM(), you must also provide the following functions: xxx_clear() Reset the current aggregate value but do not insert the argument as the initial aggregate value for a new group. These statements require the ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-29.html
(Bug #106065, Bug #33726184) When inserting BigDecimal values into a database using rewritable server-side prepared statements with cursor-based fetching, the values suffered precision loss. (Bug #104349, Bug #33563548) When the connection property ... Version 8.0.29 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-triggers-tab.html
All triggers are organized within a tree structure by section, such as BEFORE INSERT and AFTER INSERT. The Triggers subtab opens a workspace that enables you to create new triggers or edit existing triggers. To add a new trigger, click the [+] icon ...
https://dev.mysql.com/doc/workbench/en/wb-using-table-tool.html
Tables can also be added to an EER Diagram using the table tool on the vertical toolbar. Make sure that the EER Diagram tab is selected, then right-click the table icon on the vertical toolbar. Clicking the mouse on this icon changes the mouse ...