MySQL

As a Java developer, a database backup estimate is a must-learn.Unfortunately, I have been doing business logic processing of front and back, database operation is not how to contact.Today saw a bat file, is a DOS file copy and MySQL data backup

Share a small case in a job: Windows hosts use SQLyog to log in to the MySQL database (built on a Linux system), resulting in an error, as they often use host names on Windows to access resources, Telnet, and so on. Thought Linux should also be

First, install MySQLThere are so many different ways.Second, excerpt from: https://linux.cn/thread-14135-1-1.html1) First add the following in the [Mysqld] field on DB1 my.cnf:Server-id = 1//database ID number, 1 is represented as master, where

1. And there are two main strategies for registering: ① is testing MySQL (but component benchmark single-component) for the entire system's overall test (integrated Full-stack) ② alone.2. Get system performance and status (data that needs to be

MySQL: Client Connection tool-U,--user=name???? Specify User name-P--password???????? Specify password-h–host=hostname Specify the server IP or domain name-p–port=???????????? Specify portOf course, you can also specify the user name and password in

I. Types of locksThere are many kinds of locks in MySQL, there are common table locks and row locks, there are new metadata lock and so on, the table lock is a full table lock, although can be divided into read lock and write lock, but after all, is

When the MySQL service starts, not only listens to the Ip:port, but also listens to a socket, our installation mysql is the monitorListen to the/tmp/mysql.sock. If PHP is local, then PHP and MySQL communication can be communicated through the socket,

The installation files are installed in the DMG format of the Mac under MySQL, but no files are uninstalled ... It's a very depressing thing.Search the Internet, found that the method originally had to be manually deleted.Many articles account for

MySQL InnoDB table is the index organization table this should be the knowledge that every MySQL learner will learn first, which means that the data in this table is stored in the primary key order, that is, the btree leaf node stores all the data

Several concepts related to the transaction isolation level:Dirty read: Read data that has not yet been committed by another transactionNon-repeatable READ: Read the data submitted by other things, the focus of non-repeatable reading is to modify

You can blur the search first, put it in the container, deleteImport java.sql.Connection;Import Java.sql.DriverManager;Import java.sql.PreparedStatement;Import Java.sql.ResultSet;Import java.sql.SQLException;Import java.util.ArrayList;Import

Unlike SQL SERVER creating temporary tables, you cannot write directly to the CREATE TABLE #Test_TableInstead, you need to add the temporary (temporary) keyword between Create and tableCREATE Temporary TABLE test_table (NAME VARCHAR (Ten) is not

Typically, after inserting an insert operation on MySQL in the app, we need to get the self-increment primary key for the inserted record. This article describes the 4 ways in which the Java environment obtains the value of the record primary key

Format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. 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 lose the password.

1. The MySQL database does not have a mechanism for incremental backups, which is a big problem when the amount of data is too large. Fortunately, MySQL database provides a mechanism of master-slave backup, in fact, all the data of the primary

MySQL 5.7.9 Installation-free configurationEnvironment: WIN10 64-bitMySQL version: Mysql-5.7.9-winx64.zip (http://dev.mysql.com/downloads/mysql/)First of all, 5.7.9 This version is configured differently than the previous install-free version. (The.

Http://www.cnblogs.com/bruceleeliya/archive/2012/05/04/2482733.htmluse mysqldump to back up the database, upload to the backup server via FTP, and keep the backup files locally. Create a new Shell script filevi/home/work/backup.shAdd the following

Mysql Log learning SummaryI. Log introduction mysql logs are mainly divided into four types. Using these log files, you can view what happened in mysql. These four types of logs are: error logs record problems that occur when mysql service is

MySQL clears slow Query filesThis chapter describes how to generate a new slow Query file online when the slow Query file is large. Test environment: mysql 5.6.21 step configuration slow query default my. the cnf file is in the/etc/directory vim/etc/

Query in English Original article link: http://www.cnblogs.com/lyhabc/p/3732942.html This section describes basic queries in MYSQL (MYSQL official reference manual) The basic syntax of select in MySQL: Select attribute list from Table Name and