PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. It differs from DELETE in the following ways: Truncate operations drop and re-create the table, which is much ...To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
If you alter the database default character set or collation, stored routines that are to use the new database defaults must be dropped and recreated. By default, a stored routine is associated with the default database. To associate the routine ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. One of these is to modify the table definition before importing it into the Cluster database. To create a copy of the entire world database ... Note The information in this section applies to NDB Cluster running on both Unix and Windows ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
For example, if you try to select rows from a table in a database or drop a table from the database, the server verifies that you have the SELECT privilege for the table or the DROP privilege for the database. You cannot specify that a user has ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. The effect of the replication filtering options differs between binary logging formats because of the way the database name is ...It is also important ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
The binary log contains information about SQL statements that modify database contents. These events bring databases up to date from the point of the backup. The statements used to create and drop procedures, functions, triggers, and events are ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
How do I import an existing MySQL database into an NDB Cluster? A.10.28. What do “NDB” and “NDBCLUSTER” mean? “NDB” stands for “Network Database”. There must be sufficient memory on machines used for data nodes to hold each node's ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
Export your existing data from the previous MySQL installation: mysqldump -u root -p --add-drop-table --routines --events --all-databases --force > data-for-upgrade.sql Note Use the --routines and --events options with mysqldump (as shown above) if ...During this process, the server upgrades metadata for all database objects, including databases, tablespaces, system and user tables, views, and stored programs (stored procedures and functions, triggers, and Event Scheduler ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. Using prepared ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...