Rechercher dans le manuel MySQL

Displaying 51 to 60 of 62 total results
https://dev.mysql.com/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/information-schema-optimization.html
The default is 86400 seconds (24 hours), but the time period can be extended to as much as one year. Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the ...
https://dev.mysql.com/time-zone-support.html
The example uses values that are appropriate for the 2007 DST 1-hour change that occurs in the United States on March 11 at 2 a.m. This section describes the time zone settings maintained by MySQL, how to load the system tables required for named ...
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 can be called only while the result set exists; that is, after a call to mysql_stmt_execute() for a statement such as SELECT that produces a result ...
https://dev.mysql.com/innodb-best-practices.html
While you don't want to commit too often, you also don't want to issue huge batches of INSERT, UPDATE, or DELETE statements that run for hours without committing. Specifying a primary key for every table using the most frequently queried column or ...
https://dev.mysql.com/timestamp-lookups.html
(The example shown earlier illustrates how this can occur.) The query specifies a search value that is within the hour of entry into DST in the session time zone. Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted ...
https://dev.mysql.com/group-replication-frequently-asked-questions.html
You can set a waiting period of up to 1 hour. Attempting to add another server to a group with 9 members causes the request to join to be refused. This limit has been identified from testing and benchmarking as a safe boundary where the group ...
https://dev.mysql.com/c-api-prepared-statement-date-handling.html
mysql_stmt_bind_param(stmt, bind); /* supply the data to be sent in the ts structure */ ts.year= 2002; ts.month= 02; ts.day= 03; ts.hour= 10; ts.minute= 45; ts.second= 20; mysql_stmt_execute(stmt); .. The binary (prepared statement) protocol ...
https://dev.mysql.com/group-replication-limitations.html
You can allow up to an hour after the initial 5-second detection period before a suspect member is expelled from the group. Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters ...
Displaying 51 to 60 of 62 total results

Rechercher dans le manuel MySQL

Traduction non disponible

Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.

Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-fct-hour-p-6.html

L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.

Références

  1. Consulter le document html Langue du document :en Manuel MySQL : https://dev.mysql.com/

Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.

Table des matières Haut