MySQL

In the daily operation of Linux, the backup of MySQL database is a very important part. With regard to MySQL backup and recovery, it is more traditional to use the Mysqldump tool. Today introduce another MySQL backup tool Innobackupex, use it to do

Ubuntu 16.04 LTS installation nginx/php 5.6/mysql 5.7 (LNMP) with Laravel1, MySQL Installation "Install MariaDB"MARIADB is a branch of MySQLFirst, update the upgrade system$ sudo apt update$ sudo apt upgradeInstall MARIADB:$ sudo apt install mariadb-

Today in the MySQL, when a sudden appearance of this error message, it was forced, but after careful observation of the cause of the foreign key, this is due to delete the table when there is a foreign key association when there is a delete error,

Believe that a lot of people who have been using MySQL for a long time, the concept of these two field properties is not very clear, the general will have the following questions:1, my field type is not NULL, why I can insert null value2, the

0. User management:1. New User:>create USER name identified by ' Ssapdrow ';2. Change Password:>set PASSWORD for Name=password (' FDDDFD ');3. Rights Management>show GRANTS for name; View name User Rights>grant SELECT on db_name.* to name; All

In a string, some sequences have special meanings. These sequences begin with a backslash (' \ '), the so-called escape character . MySQL recognizes the following escape sequences: NUL ASCII 0 () characters.

In the MySQL database, both the read-only state and the Master-slave settings and relationships are involved in data migration and read-only state settings from the library. after practical testing, for MySQL single-instance database and master

Reprinted from:Http://www.chinaxing.org/articles/Database/2015/10/23/2015-10-22-mysql-5.7.htmlPercona a test, in the case of MySQL5.7 innodb_page_size adjustment to 4k, can be improved than 16k performance of more than 70%;

after my last friend asked me how to quickly construct a table of 100 million records, I put the method in place, see: http://blog.csdn.net/mchdba/article/details/52938114, but because it takes 2 to enter 100 million tables hours, so still feel

The following statements may be used when inserting data into a condition in MySQL, summary. Let's start by building a simple table for testing:CREATE TABLE ' Books ' (' ID ' INT (one) not NULL auto_increment,' Name ' VARCHAR ($) Not NULL,PRIMARY

MySQL Gets the current date time functionGet the current date + time (date + times) function: Now ()Mysql> Select Now (); +---------------------+| Now () |+---------------------+| 2008-08-08 22:20:46 |+---------------------+Get the current date +

a multiple-table query using the SELECT clause Select field name from Table 1, table 2 ... WHERE table 1. Fields=table 2. Fields and other query conditions select A.id,a.name,a.address,a.date,b.math,b.english,b.chinese from Tb_demo065_tel as B,tb_

Driver: Mysql-connector-java-5.1.7-bin.jar.Examples of the program are: PackageCommonproject;Importjava.sql.Connection;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.sql.Statement; Public

Degree from strong to weak 1, drop table TB drop directly delete the form, no way back 2, truncate (table) TB Delete all data in the table, cannot be used with where 3, delete from TB (where) Delete data in a table (can make a row) difference:

A prefaceMySQL's master-slave replication as a high-availability feature for synchronizing the data from the main library to the slave library, as a full-time MySQL DBA when maintaining a master copy database cluster, I believe most people will

1 Data storage EngineThe concept of a storage engine is a feature of MySQL that specifies the type of table (such as how the table stores and indexes data, whether transactions are supported, foreign keys, and so on), and how the table is stored on

Problem Description:after starting the transaction, the Java code makes a query, then inserts, which is reported at this time:        java.sql.SQLException:could not retrieve transation read-only status serverresolution process:View MySQL 's things

Installing Apache Zeppelin1 wget http://apache.fayea.com/zeppelin/zeppelin-0.6.2/zeppelin-0.6.2-bin-all.tgz1 TAR-XZVF zeppelin-0.6.2-bin-all.tgzconfiguring MySQL Interpreter1. Under Interpreter in the Zeppelin directory, add the MySQL

Mysql too connector connections solution, mysqlconnections Mysql error prompt too many ons,I recently encountered this error and solved it by checking the information on the Internet. Here I will record it to help friends who need it, The solution

CentOS 7.2 Yum compile and install MySQL 5.6, centosyum The following example shows how to install mysql5.6 on CentOS 7.2 Yum. Configure the CentOS SCLo Source [3] add CentOS SCLo Software collections Repository. [root @ linuxprobe ~] # Yum-y