PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
It is safest (and often faster) to let the application ensure that it passes only valid values to the database. MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
The minimum requirements for a valid CREATE EVENT statement are as follows: The keywords CREATE EVENT plus an event name, which uniquely identifies the event in a database schema. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE FUNCTION requires the INSERT privilege for the mysql system database because it adds a row to the mysql.func system table to register the function. CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
A general tablespace is not associated with any database or schema. The precise syntax and semantics depend on the storage engine used. In standard MySQL 5.7 releases, this is always an InnoDB tablespace. MySQL NDB Cluster 7.5 also supports ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system database. CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
Normalization Normally, try to keep all data nonredundant (observing what is referred to in database theory as third normal form). Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
This is useful when you want to store a “possibly wrong” value which the user has specified (for example, in a web form) in the database for future processing. The date and time data types for representing temporal values are DATE, TIME, ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-server.html
Support for DTrace is deprecated in MySQL 5.7 and is removed in MySQL 8.0. The DTrace probes in the MySQL server are designed to provide information about the execution of queries within MySQL and the different areas of the system being utilized ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-troubleshooting.html
For examples, see Section 2.10.13, “Copying MySQL Databases to Another Machine”. If you downgrade from one release series to another, there may be incompatibilities in table storage formats. In this case, use mysqldump to dump your tables ...