MySQL

1, extract to a directory (recommended root directory), such as: D:\mysql2. Add D:\mysql\bin in the system path3, this version without My-default.ini, need to write, put in D:\mysql\my.ini, relevant parameters can refer to

1. Create a replication user' Rep_user ' @'%.192.168.0.106'123456';2. Permission Grant' Rep_user ' @'%.192.168.0.106';3. Back up the main libraryC:\users\administrator>mysqldump-uroot--password--databases test01 >e:/temp/20170507/ ****Show master

1. MySQL Group_concat ()MySQL>SELECT pub_id,group_concat (cate_id), from book_mast GROUP by pub_id;Return Result: (default comma delimited)+--------+-----------------------+| pub_id | Group_concat (cate_id) |+--------+-----------------------+| P001

To display the database:SHOW DATABASES database_name;To create a database:CREATE DATABASES database_name;To delete a database:DROP DATABASE database_name;To create a data table:CREATE table(Field name 1, data type [column-level constraint] [default],

1. Tables with the same name are not allowed in the same database; tables with the same name can appear in different databases2. Each row of records uses a key (a column or a set of columns as key)3. The column as key is not allowed to be null (NULL)

ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using Password:no)ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using Password:yes)The steps are as follows:In the MySQL installation directory, locate the

Insert tone belongs to DMLSimple usage: INSERT INTO tb_name (field 1, Field 2, ...) VALUES (value 1, value 2, ...) Attentionthe number of fields must be the same as the number of values。 Characters are quoted in quotation marks, numbers are not used,

There are times when Windows servers need to be re-installed, and many of the software needs to be reinstalled. What to do without backing up MySQL data!Method/Step 1To stop the MySQL service:Stop and start MySQL under Windows through the '

1.mysql connections->threads cached->threads cachedmysql connections->threads  cached->threads connected (number of connections used, connection pool) mysql connections->threads cached-> Connections per second2. Table cache, number of tables already

Today, a colleague said that his MySQL database does not come, very depressed, the error is as follows#/etc/init.d/mysql StartStarting MySQL .... error! The server quit without updating PID file (/data/mysql/mysql3306/data/mysql.pid).The first time

? Copyright NOTICE: This article is the original blogger article, reproduced please indicate the sourceproblem Description: Execute SQL statement under MySQL database, error (although SQL is also successful, it's not cool to watch). The error

Introduction to the Views View command:View is the stored SELECT statement data1 . To create a view command format:CREATE[OR REPLACE][algorithm = {UNDEFINED | MERGE | TempTable}][definer = {User | Current_User}][SQL SECURITY {definer |

Method One:SELECT * from the users WHERE emails like "%[email protected]%";Method Two:Use the MySQL string function find_in_set ();SELECT * from Users WHERE find_in_set (' [email protected] ', emails);This is possible, how to understand it?MySQL has

1.cmd2.C:\USERS\ADMINISTRATOR>CD C:\Program files\mysql\mysql Server 5.7\bin3c:\program files\mysql\mysql Server 5.7\bin>mysql-h localhost-u root-p4.Enter Password: Database password5.use table name ;6.set Global optimizer_switch= '

Mysql5.7.18.zip installation-free version configuration tutorial (windows), mysqlwindows installation-free This is the installation tutorial of mysql5.7.18.zip. I will share it with you first. MySQL Official Website:

Solve the Problem of MySQL 5.7.9 SQL _mode = only_full_group_by, 5.7.9sql _ mode MySQL 5.7.9 SQL _mode = only_full_group_by Com. mySQL. jdbc. exceptions. jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in group by clause and

MySQL 5.7.18 installation-free configuration tutorial, mysql5.7.18 Install MySQL 5.7.18 without Installation MySQL is currently the most popular open source database in the world. The core storage of many large factories is often MySQL. To install

Configure the mysql database master and slave in windows Tools used: Mysql, Navicat Premium; Master database settings: 1. Set the my. ini file; 1. Find the my. ini file in the installation directory: Default path: C: \ Program Files \ MySQL Server 5.

Mysql 5.7.18 winx64 installation and configuration method graphic tutorial, 5.7.18winx64 After the mysql-5.7 compressed package installation has not small changes, this article for the previous installation mysql5.7.18 notes are summarized, share

I skipped the password policy of Mysql 5.7 and Mysql. Mysql has no password policy since mysql 5.6, so we can set the password for every user as we like, what is 123, abc, or even a space, that is OK. The mysql. user table also contains the password