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/windows-testing.html
If you have set a password for the root account, deleted the anonymous account, or created a new user account, then to connect to the MySQL server you must use the appropriate -u and -p options with the commands shown previously. (Be sure that an ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Create_options shows the ENCRYPTION option specified when creating or altering a file-per-table tablespace. When creating a table with strict mode disabled, the storage engine's default row format is used if the specified row format is not supported. Create_options shows the row format that was specified in the CREATE TABLE ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. The number increases each time the server creates a new log file, thus creating an ordered series of files. The server ...It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates a table format file in the database directory. The setup for the source is: CREATE TABLE t1 (public_col_1, ..., public_col_N, secret_col_1, ..., secret_col_M) ENGINE=MyISAM; The setup for the ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Other Uses for Cast Operations The cast functions are useful for creating a column with a specific type in a CREATE TABLE ... SELECT statement: mysql> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE) AS c1; mysql> SHOW CREATE TABLE ... Table ...
https://dev.mysql.com/doc/refman/5.7/en/charset-column.html
CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci ) CHARACTER SET latin1 COLLATE latin1_bin; The character set and collation are specified for the column, so they are used. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8 ... Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column ...
https://dev.mysql.com/doc/refman/5.7/en/charset-examples.html
Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE latin2_bin; Here we have a column with a latin1 character set and a latin1_german1_ci ... The ...