PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe functionality). If mysqld does not want to start, verify that you have no my.cnf files ...
https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...
https://dev.mysql.com/doc/refman/5.7/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. To delete all ...
https://dev.mysql.com/doc/refman/5.7/en/deploy-mysql-nonlinux-docker.html
Warning The MySQL Docker images provided by Oracle are built specifically for Linux platforms. Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. This section discusses ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-concepts.html
This section explains the concepts introduced as part of using MySQL as a document store. Document A Document is a set of key and value pairs, as represented by a JSON object. A Document is represented internally using the MySQL binary JSON object, ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. If your intention is to use MySQL in a traditional (SQL) way, this chapter is probably not relevant to you. Important ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. It removes privilege rows for the account from all grant tables. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql ...