https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/replication-options-reference.html
The following two lists provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. The command-line options and system variables in the following list relate to replication ...
https://dev.mysql.com/batch-mode.html
Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute it. In the previous sections, you used mysql interactively to enter ...
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/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/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. The log consists of a set of binary log files, plus an index file ...
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/log-file-maintenance.html
As described in Section 5.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking place. However, you must clean up these files regularly to ensure that the logs do not take up too ...
https://dev.mysql.com/change-master-to.html
If both the default settings are used, the slave waits 60 seconds between reconnection attempts (MASTER_CONNECT_RETRY=60), and keeps attempting to reconnect at this rate for 60 days (MASTER_RETRY_COUNT=86400). ] CHANGE MASTER TO changes the ...
