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/create-view.html
That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
UPDATE WHERE CURRENT OF and DELETE WHERE CURRENT OF are not implemented, because updatable cursors are not supported. Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result ...
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. We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
Persisting Data and Configuration Changes Docker containers are in principle ephemeral, and any data or configuration are expected to be lost if the container is deleted or corrupted (see discussions here). A MySQL Docker installation is different ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
SQL Changes A trigger can have triggers for different combinations of trigger event (INSERT, UPDATE, DELETE) and action time (BEFORE, AFTER), but before MySQL 5.7.2 cannot have multiple triggers that have the same trigger event and action time.
https://dev.mysql.com/doc/refman/5.7/en/drop-event.html
The event immediately ceases being active, and is deleted completely from the server. DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. If the event does not exist, the error ERROR 1517 (HY000): Unknown event ...
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system database because it removes the row from the mysql.func system table that registers the function. DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named ...
https://dev.mysql.com/doc/refman/5.7/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. It is supported with all MySQL NDB Cluster 7.5 releases, and with InnoDB in the standard MySQL Server as ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system database. The DROP USER statement removes one or more MySQL accounts and their privileges. It removes privilege rows for the account from ...