MySQL

MySQL master-slave is also called replication, AB replication. Simply speaking is a and b two machines from the back, write the data on a, the other B will follow the writing data, both data in real-time synchronization. It is based on the Binlog,

Today, when querying database character fields in PHP, the syntax is exactly the same, but the query is not the result, and in the command line, the same statement can achieve the desired effect. After a lot of understanding, we found that the

MySQL Default link number is 100 maximum is 16384. principle: Try every means not to restartCause:This error is obviously mysql_connect after forgetting Mysql_close;When a large number of connect, there will be too many connections error, mysql

Transaction controlIn general, MySQL turns on the transaction autocommit feature by default, and each SQL execution commits the transaction. You can turn off the transaction autocommit feature by using the following statement.Show session variables

The replace operation is similar to insert. There is only one exception, if an old record in the table is used with a primaryA new record of key or a unique index has the same value, and the old record is deleted before the new record is

1, create schema [database name] default character set UTF8 collate utf8_general_ci;--CREATE database with Create schema and creation database The same as the fruit. 2, create user ' [user name] ' @ '% ' identified by ' [user password] ';--Create

Database and SQL ConceptsA database ( Database ) is a warehouse that organizes, stores, and manages data in accordance with its structure, which has been generated more than 60 years ago. With the development of information technology and market,

The first thing to say is that Jetprofiler is a great tool for analyzing MySQL problems and optimization in your project. But look at the online article, the introduction of Chinese really not much. Is it because there is no MySQL in the country now?

1. convert int to varchar often using concat function, such as concat (8, ' 0 ') to get string ' 80 'and menu_name like CONCAT (CONCAT ('% ', #{pd.keywords}), '% ')2. Convert varchar to int with cast (a as signed) a as varchar type stringSummary:

Official website: https://downloads.mysql.com/archives/gui/Available directly after decompression1, MySQLQueryBrowser.exeWhen you start MySQL Query Browser, a dialog box pops up asking you to fill in some basic information about the MySQL server you

One, date and time functionsConcept of function: input parameters in the specified format, return the correct result of the unit of operation1. Return the current date: Curdate ()Current_date ()Current_date () +0 to convert the current date to a

Why does MySQL have to master replication (read/write separation)?In layman's terms, the performance of a business system degrades if both the read and write of the database are operated on the same database server.In order to improve the

Today in the virtual machine Ubuntu on the night of the MySQL, and then try to connect with Java, did not succeed for a long time, but the students with a good Debian on the connection is successful, that is, I have a problem with the

Today's monitor shows MySQL master-slave replication error, the information is as follows:Mysql> Show slave status\g;*************************** 1. Row *************************** slave_io_state:master_host:192.168.33.230

1. Conditionsusing the WHERE clause to filter the data in a table, the rows with the result of true appear in the result set, with the following syntax:select * FROM table name where condition;Example: SELECT * FROM students where id = 1;The where

#!/bin/bash#auto Backup any one or all db#by Zhaoyanfeng#2017-8-15 11:17:54#definedAll_db= ' mysql-uroot-p123456-e "show databases;" | Grep-v Database | Xargs-n 1 'Mysql_user=rootMysql_passwd=

The default database engine before storage Engine Myisammysql 5.0 is most commonly used. has a high insertion, query speed, but does not support the transaction InnoDB transactional database of the preferred engine, support acid transactions,

A few days ago downloaded mysql5.7 Normal installation, with Navicat for MySQL connection when prompted "Access denied for user ' root ' @ ' localhost ' (using Password:yes)" "Error message, Because the first time the installation did not add the

1, control the appropriate data file size:The larger the amount of data, the larger the size of the data file, the larger the index file, and the impact on performance, the performance will be drastically reduced, so, to limit the database of single

| MySQL insert user error. mysql insert When you add a user using insert, an error may be returned: ERROR 1364 (HY000): Field 'ssl _ cipher 'doesn' t have a default value The my-default.ini has a statement: SQL _mode = NO_ENGINE_SUBSTITUTION,