PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. For information about account representation in the user table, see Section 8.2.3, “Grant Tables”. Warning The MySQL user name length limit is hardcoded in MySQL servers and ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. When you store data into the table, the storage engine saves it into the data file in comma-separated ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
PartitionsPerNode: Determines the number of table partitions created on each data node; not used if ClassicFragmentation is enabled. DefaultHashMapSize: Set size (in buckets) to use for table hash maps. DiskDataUsingSameDisk: Set to false if Disk ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
You cannot specify that a user has privileges to create or drop tables in a database but not to create or drop the database itself. MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by ...The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and ...
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. Account names appear in SQL statements such as CREATE USER, GRANT, and SET ...This section describes the syntax for account names, including special values and wildcard ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. MySQL requires that foreign key columns be indexed; if you create a table with a foreign key constraint but no index on a given column, an ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
If you are using tablespaces with InnoDB, then the specific tablespace files you create are used instead. MySQL encodes any characters that are problematic in the corresponding file system objects when it creates database directories or table files: ... There is a correspondence between database and table identifiers and names in the file ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If the server uses temporary ... If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra ...
https://dev.mysql.com/doc/refman/8.0/en/windows-restrictions.html
DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the CREATE TABLE statement is supported on Windows for InnoDB tables only, as described in Section 17.6.1.2, “Creating Tables Externally”. For MyISAM and other storage engines, the ...File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir ... The following restrictions apply to use ...