PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/mysqlpump.html
mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL ...
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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
A number of changes are made in the ndbinfo database, chief of which is that it now provides detailed information about NDB Cluster node configuration parameters. In addition, the ndbinfo database no longer depends on the MyISAM storage engine. The ... Major changes and new features in NDB Cluster 7.5 which are likely to be of interest are shown in the following list: ndbinfo ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
Replacing a database directory with a symbolic link works as long as you do not make a symbolic link between databases. On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create ...If one client updates db1.tbl_a and another client updates db2.tbl_a, problems are likely to ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME USER, CREATE (all forms except CREATE TABLE ...
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/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 ...