Search Results
https://dev.mysql.com/doc/refman/8.4/en/commit.html
MySQL enables extra optimizations for queries on InnoDB tables when the transaction is known to be read-only. SET autocommit disables or enables the default autocommit mode for the current session. This means that, when not otherwise inside a ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL Shell. For information on establishing connections using command-line options, for ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper credentials. A failure at either step causes the server to ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-foreign-key.html
Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. The ...
https://dev.mysql.com/doc/refman/8.4/en/corrupted-myisam-tables.html
Try to repair it Queries don't find rows in the table or return incomplete results. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The ...
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/8.4/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 ...