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/select-optimization.html
Scalability means that your application can handle more simultaneous users, larger requests, and so on without experiencing a big drop in performance. Queries, in the form of SELECT statements, perform all the lookup operations in the database. NDB ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
For nonbinary strings, the unit is the character and some character sets support multibyte characters; comparisons use numeric character code values. These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; ...Every binary string has a character set and collation named ... A string is a sequence of bytes or characters, ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
You may also find the MySQL User Forums to be helpful. Is there a discussion forum for INFORMATION_SCHEMA? See the MySQL User Forums. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Can I add to or otherwise modify ...Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
<in_optimizer>(query fragment) This is an internal optimizer object with no user significance. <ref_null_helper>(expr) This is an internal optimizer object with no user significance. For SELECT statements, the EXPLAIN statement produces extra ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
MySQL Server has a practical set of features developed in close cooperation with our users. The database structures are organized into physical files optimized for speed. The database enforces these rules, so that with a well-designed database, your ... MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html
If the MySQL server is started with --innodb-read-only but the data directory is still on writeable media, the root user can still perform DCL operations such as GRANT and REVOKE. To prepare an instance for read-only operation, set ...How to Enable ... You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
For example: SET time_zone = 'MET'; Unique UTC values stored in the TIMESTAMP column are not unique in the session time zone due to DST shifts. (This is the same type of conversion performed by the CONVERT_TZ() function. If the session time zone is ... Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and ...
https://dev.mysql.com/doc/refman/5.7/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. This is common for options that you want ...List the options in an option file that the program reads when it ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ...--defaults-extra-file=file_name, --extra-file=file_name, -e file_name Read this option file after the global option file but (on Unix) before the user option ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
See X DevAPI User Guide for in-depth tutorials on using X DevAPI. Relational databases such as MySQL usually required a document schema to be defined before documents can be stored. This differs from working with a relational database and storing ...