PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
Use mysqlshow to see what databases exist: C:\> bin\mysqlshow +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ The list of installed databases may ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
It does not support ALTER TABLE, or any Data Definition Language statements that directly affect the structure of the table, other than DROP TABLE. The reason for this is that this table must work like a data file that would never be written to by ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
Instead, truncate the Performance Schema host_cache table: TRUNCATE TABLE performance_schema.host_cache; The TRUNCATE TABLE operation requires the DROP privilege for the table rather than the RELOAD privilege. This memory is not released by the ...| ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
When a given client session ends, the server logs a DROP TEMPORARY TABLE IF EXISTS statement for each temporary table that still exists and was created when statement-based binary logging was in use. If row-based or mixed format binary logging was ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This parameter defines the amount of space (in bytes) available for storing database records. For large databases, it may be preferable to use a 64-bit operating system for this reason. An important point for both IndexMemory and ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
Be sure that your application remains secure if a user tries to perform SQL injection by entering something like ; DROP DATABASE mysql; into a form. Sometimes people think that if a database contains only publicly available data, it need not be ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
In contrast with the InnoDB system tablespace, file-per-table tablespaces allow disk space to be reclaimed by the operating system when a table is truncated or dropped. Storage Requirements If you intend to make several temporary copies of your data ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ... MySQL Events are tasks that run according to a ...