PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server and whether connections are encrypted. Command Options for Connection Establishment Command Options for ...
https://dev.mysql.com/doc/refman/5.7/en/constraints.html
MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot ...Because of this, constraint handling is a bit different in MySQL than in other ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/create-database.html
CREATE DATABASE is not permitted within a session that has an active LOCK TABLES statement. A database in MySQL is implemented as a directory containing files that correspond to tables in the database. Because there are no tables in a database when ... CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
For example, you cannot have a tablespace and a log file group with the same name, or a tablespace and a data file with the same name. You can verify that the UNDO files were created and obtain information about them by querying the Information ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table partitioning, such as ALTER TABLE t3 DROP PARTITION p2, where we must make certain that the partition is completely dropped and that ...MySQL uses this log to recover from a crash occurring in the middle of a partitioning metadata ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables are getting slower and slower you should try to optimize the table with OPTIMIZE TABLE or myisamchk. If you are ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...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/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL accounts. The mysql.user grant table defines the initial MySQL user account and its access privileges. The 'root'@'localhost' account also has a row in the mysql.proxies_priv table that enables granting the PROXY privilege for ''@'', that is, for all users and all ...
https://dev.mysql.com/doc/refman/5.7/en/differences-from-ansi.html
For example, in MySQL, privileges for a table are not automatically revoked when you delete a table. You must explicitly issue a REVOKE statement to revoke privileges for a table. We try to make MySQL Server follow the ANSI SQL standard and the ...