Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/thread-information.html
Time indicates how long the thread has been in its current state. The thread's notion of the current time may be altered in some cases: The thread can change the time with SET TIMESTAMP = value. For a thread running on a slave that is processing ...
https://dev.mysql.com/trigger-syntax.html
It also includes clauses that specify the trigger action time, the triggering event, and what to do when the trigger activates: The keyword BEFORE indicates the trigger action time. The statement following FOR EACH ROW defines the trigger body; that ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.22, “CREATE TRIGGER Statement”, and Section 13.1.34, “DROP TRIGGER ...
https://dev.mysql.com/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. As a development technique to guard against a ...
https://dev.mysql.com/binary-log.html
The number increases each time the server creates a new log file, thus creating an ordered series of files. The server creates a new file in the series each time it starts or flushes the logs. For more information about the binary log and recovery ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/bug-reports.html
Writing a good bug report takes patience, but doing it right the first time saves time both for us and for yourself. This section helps you write your report correctly so that you do not waste your time doing things that may not help us much or at ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/c-api-prepared-statement-data-structures.html
The MYSQL_TIME structure is used to transfer temporal data in both directions. For date and time data types, buffer should point to a MYSQL_TIME structure. MYSQL_TIME This structure is used to send and receive DATE, TIME, DATETIME, and TIMESTAMP ...
https://dev.mysql.com/charset-connection.html
These session system variable values are initialized at connect time, but can be changed within the session. With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/controlling-query-plan-evaluation.html
However, when larger queries are submitted, the time spent in query optimization may easily become the major bottleneck in the server's performance. The general idea is that the fewer plans that are investigated by the optimizer, the less time it ...
https://dev.mysql.com/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For statements that can be determined at function definition time to return a ...To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create ...
https://dev.mysql.com/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Can a table have multiple ...
Nederlandse vertaling
U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.
Bij voorbaat dank.
Document heeft de 26/06/2006 gemaakt, de laatste keer de 26/10/2018 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/mysql-rf-fct-time-p-18.html
De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.
Referenties
Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.
