We know that Oracle has dataguard real-time backup data, can switch, and MySQL has its own set of library solutions, called Master-slave replication.To build MySQL from the library is to synchronize the main library data in real time, but also can
If Table A's primary key is a field in table B, the field is called the Foreign key of Table B, table A is called the primary table, and table B is called from the table. Foreign keys are used to achieve referential integrity, and different foreign
1.mysql command line garbled: Enter set names UTF8 on the MySQL command line---UTF8 to be encoded in the same way as the database's character set,Indicates the ' client display ' or ' Send to server ' character set encoding method, the MySQL command
MySQL Open remote connectionToday in the server installed MySQL, ready to use Mysqlguitools remote login error, prompt: Host ' xxx ' is not allowed to connect to this MySQL server. Found some information on the Internet, is MySQL does
MySQL installation generally uses RPM or the source code installation method.The advantages of RPM installation are fast and convenient. The disadvantage is that you cannot customize the installation directory. If you need to adjust the location of
To view User rights:SELECT Host,user,password,grant_priv,super_priv from Mysql.user;Permissions depend on the value of the last recordIf you need to reclaim permissions:REVOKE all privileges on * * from ' root ' @ ' ip1 ';The above SQL will place
One, copy My.ini to MySQL extracted directoryExample: E:\MySQLSecond, modify the My.ini line 39th to 40thBasedir = "E:\\mysql"DataDir = "E:\\mysql\\data"Third, check whether the MySQL service is installed on the computerMy computer-with services and
Vi/data/mysql/my.cnfVi/etc/my.cnf1. Basedir ParametersThe original description is:Path to installation directory. All paths is usually resolved relative to this.Explain:This parameter specifies the installation path (MySQL installation directory)
GoalHow to create a function in the MySQL databaseGrammarCREATE FUNCTION func_name ([func_parameter])//parentheses are required, parameters are optional returns type[characteristic ...] routine_body
The CREATE function keyword used for
MySQL appears when you delete a single tableERROR 1217 (23000): Cannot delete or update a parent ROW:A FOREIGN KEY constraint failsIt is possible that MySQL has set the Foreign Key association in InnoDB, which makes it impossible to update or delete
1, connected to MySQL format: mysql-h host address-u user name-p user password 1, connected to the local MySQL. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
In some applications, you need to know who is working on the table, what has been done, and what is responsible for the pursuit. In MySQL, you can use a trigger implementation.1: Create a test table
Mysql> CREATE Table A (a
1.SELECT into Outfil:This method can not overwrite or append to the existing file, can only write to the new file, and establish the path of the file requires the MySQL process user has permission to create a new file. MySQL 61571 60876 Aug27? 3-10:5
MySQL provides standard SQL pattern matching and an extended regular expression based on Unix-like utilities such as VI, grep, and SEDpattern-matching format.The pattern matching of SQL allows you to match any single character with "_", while "%"
1. Select database table--Right-click Properties--Backup/Export--export table data as---Select CVS--Select the following "Change"--field--Variable length--the field is terminated --Enter a comma, ( This is the focus, otherwise the contents of the
The first part installs MySQLThe second section uses MySQL to manage metaInstall MySQLInstallationYum-y install MySQL Mysql-serverYum method installation requires the use of the network, can automatically continue to transmit, for the dependent
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service