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/innodb-redo-log.html
Otherwise, the following error is returned: ERROR 3846 (HY000): Redo log archive directory 'directory_path1' is accessible to all OS users Directories cannot be those defined by datadir, innodb_data_home_dir, innodb_directories, ...Redo log files ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. The .txt file contains the table data, one line per table row. The following command dumps the ...If you invoke mysqldump with the --tab=dir_name option, it uses dir_name as the output directory and dumps tables individually in that directory using two files for each ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-types.html
The BIT data type stores bit values and is supported for MyISAM, MEMORY, InnoDB, and NDB tables. These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, ...The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED are synonyms for ...
https://dev.mysql.com/doc/refman/8.0/en/loading-tables.html
You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement. To represent these in your text file, use \N (backslash, ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html
The other spatial data types hold collections of values: MULTIPOINT MULTILINESTRING MULTIPOLYGON GEOMETRYCOLLECTION GEOMETRYCOLLECTION can store a collection of objects of any type. For other examples showing how to use spatial data types in MySQL, ... MySQL has spatial data types that correspond to OpenGIS ...Spatial columns with no SRID ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-native.html
To start the MySQL server use systemctl: $> systemctl start mysqld The database tables are automatically created for you, if they do not already exist. Note Before installing, make sure that you update your apt-get index files to ensure you are ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-parallel-data-node-backup.html
In the general case, no additional special arguments are required; ndb_restore always checks for the existence of parallel subdirectories under the directory indicated by the --backup-path option and restores the metadata (serially) and then the ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For information about storage requirements of the temporal data types, see Section 13.7, “Data Type Storage Requirements”. Although ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...