Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysql-cluster-install-example-data.html
There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. One of these is to modify the table definition before importing it into the Cluster database. Then modify the table ...
https://dev.mysql.com/mysql-num-fields.html
unsigned int mysql_num_fields(MYSQL_RES *result) To pass a MYSQL* argument instead, use unsigned int mysql_field_count(MYSQL *mysql). You can get the number of columns either from a pointer to a result set or to a connection handler. You would use ...In this case, you can call mysql_field_count() to determine whether mysql_store_result() should have produced a nonempty ...
https://dev.mysql.com/mysql-stmt-execute.html
int mysql_stmt_execute(MYSQL_STMT *stmt) mysql_stmt_execute() executes the prepared query associated with the statement handler. Those functions are not intended for processing results from prepared statements. The currently bound parameter marker ...
https://dev.mysql.com/mysql-stmt-fetch.html
int mysql_stmt_fetch(MYSQL_STMT *stmt) mysql_stmt_fetch() returns the next row in the result set. It returns the data in those buffers for all the columns in the current row set and the lengths are returned to the length pointer. Invoke ...It can ...
https://dev.mysql.com/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For example, INT(4) specifies an INT with a display width of four digits. This optional display ...
https://dev.mysql.com/optimizer-statistics.html
Here is a sample histogram object: { "buckets": [ [ 1, 0.3333333333333333 ], [ 2, 0.6666666666666666 ], [ 3, 1 ] ], "null-values": 0, "last-updated": "2017-03-24 13:32:40.000000", "sampling-rate": 1, "histogram-type": "singleton", ... The ...
https://dev.mysql.com/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/rename-table.html
If a table has triggers, attempts to rename the table into a different database fail with a Trigger in wrong schema (ER_TRG_IN_WRONG_SCHEMA) error. RENAME TABLE works for views, except that views cannot be renamed into a different database. RENAME ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...
https://dev.mysql.com/signal.html
Example: CREATE PROCEDURE p (divisor INT) BEGIN DECLARE divide_by_zero CONDITION FOR SQLSTATE '22012'; IF divisor = 0 THEN SIGNAL divide_by_zero; END IF; END; If the named condition does not exist in the scope of the SIGNAL statement, an Undefined ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-int-p-8.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
