Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
The string in the from argument is encoded to produce an escaped SQL string, taking into account the current character set of the connection. Return Values The length of the encoded string that is placed into the to argument, not including the ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
For those cases where trailing pad characters are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting into the column values that differ only in number of trailing pad characters results in a ...For ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: mysql> INSERT INTO geo VALUES(@point3); ERROR 3819 (HY000): Check constraint 'geo_chk_1' is violated. MySQL supports validation ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
For binary or case-sensitive collations, lettercase is taken into account when assigning values to the column. For example, you can retrieve numeric values from a SET column like this: mysql> SELECT set_col+0 FROM tbl_name; If a number is stored ...
https://dev.mysql.com/doc/internals/en/innodb-field-contents.html
Helpful Notes About NULLs: For the third row, I inserted NULLs in FIELD2 and FIELD3. The Field Contents part of the record has all the data. There are no markers between fields, and there is no marker or filler at the end of a record. I made a ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-event-handling.html
The source code for this program may be found in the NDB Cluster source tree, in the file storage/ndb/ndbapi-examples/ndbapi_event/ndbapi_event.cpp. #include <NdbApi.hpp> // Used for cout #include <stdio.h> #include <iostream> #include <unistd.h> ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
Can you insert into views that are based on joins? A.6.1. Can you insert into views that are based on joins? It is possible, provided that your INSERT statement has a column list that makes it clear there is only one table involved. You cannot ...
https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html
(This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column of the same type but having fewer fractional digits results in ... MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or TIMESTAMP, and fsp is the fractional seconds ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
mysql> START TRANSACTION; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO customer VALUES (10, 'Heikki'); Query OK, 1 row affected (0.00 sec) mysql> COMMIT; Query OK, 0 rows affected (0.00 sec) mysql> -- Do another transaction with ...If ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. When you insert any other value into an AUTO_INCREMENT column, the column is set to that value and the sequence is reset so that the ...(AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...