PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
This can be called the pet table, and it should contain, as a bare minimum, each animal's name. MySQL provides functions for doing date arithmetic, so this is not difficult. You want a table that contains a record for each of your pets. Because the ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a ... Data ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
For example, a database like this could be used by a farmer to keep track of livestock, or by a veterinarian to keep track of patient records. For this reason, you should probably ask your MySQL administrator for permission to use a database of your ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
What if you want to know which animals have birthdays next month? For this type of calculation, year and day are irrelevant; you simply want to extract the month part of the birth column. MySQL provides several functions that you can use to perform ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
This is true even if the condition occurs in an inner block. This is relevant within the context of cursors and is used to control what happens when a cursor reaches the end of a data set. To detect this condition, you can set up a handler for it or ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. DROP DATABASE has no effect in this regard, even if the operation drops all tables belonging to the ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-syslog.html
To do so, use these system variables: log_syslog: Enable this variable to send the error log to the system log. log_syslog_tag: This variable defines a tag to add to the server identifier (mysqld) in syslog messages. For syslog output, a tag can be ... It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
In this case, if the server tries to update a table that myisamchk is using, the server waits for myisamchk to finish before it continues. (See Section 8.12.1, “System Factors”.) To avoid this requirement, use the CHECK TABLE and REPAIR TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
This might be zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = ...A ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
In this example, the my_tablespace directory is at the same level as the data directory: mysql> CREATE TABLESPACE `ts1` ADD DATAFILE '../my_tablespace/ts1.ibd' Engine=InnoDB; Note The ENGINE = InnoDB clause must be defined as part of the CREATE ...