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/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. By default, the server interprets ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. If the OR REPLACE clause is present, you must also have the DROP privilege for the view. By default, a new ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--ignore, -i Command-Line Format --ignore See the description for the --replace option. --replace, -r Command-Line Format --replace The --replace and --ignore options control handling of input rows that duplicate existing rows on unique key values.
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
character_set_database System Variable character_set_database Scope Global, Session Dynamic Yes Type String Default Value latin1 Footnote This option is dynamic, but should be set only by server. If there is no default database, the variable has the ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT X'616263', HEX('abc'), UNHEX(HEX('abc')); -> 'abc', 616263, 'abc' mysql> SELECT HEX(255), CONV(HEX(255),16,10); -> 'FF', 255 INSERT(str,pos,len,newstr) Returns the string str, with the substring beginning at position pos and len ...For ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a database. These ...
https://dev.mysql.com/doc/refman/5.7/en/create-database.html
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name } CREATE DATABASE creates a database with the given name. To use this statement, you need ...For information about character set and collation names, see Chapter 10, Character Sets, Collations, ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. Important When a database ...TEMPORARY tables are automatically removed when the session that created them ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
To perform such a standard, basic installation, go to the folder that contains all those packages (and, preferably, no other RPM packages with similar names), and issue the following command for platforms other than Red Hat Enterprise Linux/Oracle ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...