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/mysql-shell-tutorial-javascript-table-delete.html
Drop a Table The dropCollection() method is also used in MySQL Shell to drop a relational table from a database. For example, to drop the citytest table from the world_x database, issue: mysql-js> session.dropCollection("world_x", "citytest") ...The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-table-delete.html
Drop a Table The drop_collection() method is also used in MySQL Shell to drop a relational table from a database. For example, to drop the citytest table from the world_x database, issue: mysql-py> db.drop_collection("citytest") Related Information ... You can use the delete() method to remove some or all records from a table in a ...The X DevAPI provides additional ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. An event may not be altered, or dropped from within a stored program, if the event name is specified by means of a variable. An event also may not ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database contents. This type of backup is suitable for large, important databases that need to be recovered quickly when problems ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
The rows in these tables for a given account indicate the account privileges that apply on a global basis no matter what the default database is. For example, if the user table grants you the DELETE privilege, you can delete rows from any table in ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
Without the system user concept, a user who has the CREATE USER privilege can modify or drop any existing account, including the root account. Regular users with the CREATE USER privilege can still modify or drop existing accounts, but only regular ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
If you drop an AUTO_INCREMENT column and then add another AUTO_INCREMENT column, the numbers are resequenced beginning with 1. Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
Partitioned Table Support DELETE supports explicit partition selection using the PARTITION clause, which takes a list of the comma-separated names of one or more partitions or subpartitions (or both) from which to select rows to be dropped. Given a ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
To remove them, use the DROP FUNCTION statement: DROP FUNCTION service_get_read_locks; DROP FUNCTION service_get_write_locks; DROP FUNCTION service_release_locks; Using the Locking Service Function Interface Before using the locking service ...