Rechercher dans le manuel MySQL
28.7.26 C API Prepared Statement Problems
Here follows a list of the currently known problems with prepared statements:
TIME
,TIMESTAMP
, andDATETIME
do not support parts of seconds (for example, fromDATE_FORMAT()
).When converting an integer to string,
ZEROFILL
is honored with prepared statements in some cases where the MySQL server does not print the leading zeros. (For example, withMIN(
).number-with-zerofill
)When converting a floating-point number to a string in the client, the rightmost digits of the converted value may differ slightly from those of the original value.
Prepared statements do not support multi-statements (that is, multiple statements within a single string separated by
;
characters).The capabilities of prepared
CALL
statements are described in Section 28.7.25, “C API Prepared CALL Statement Support”.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-c-api-prepared-statement-problems.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.