MySQL

Test CREATE TABLE:DROP TABLE IF EXISTS person;CREATE TABLE Person (ID INT not NULL auto_increment PRIMARY KEY,Name varchar () not NULL DEFAULT ' COMMENT ' username ',Age SMALLINT not NULL DEFAULT 0 COMMENT ' ages ') Engine=innodb DEFAULT Charset=utf8

Table Association Update:UPDATE User_bank a INNER JOIN Bank as BON a.bank_code = B.bank_codeset a.bank_type =b.id WHERE A.bank_type is NULL and A.I d=1650;Pre-update query:SELECT * from User_bank WHERE id = 1650;select * from User_bank where

1. Turn off SELinuxVim/etc/selinux/config Change selinux=enforcing to selinux=disabled2. Change IO Schedule, no need to change for SSD driveecho Deadline >/sys/block/sda/queue/scheduler3. Change Ulimitvim/etc/security/limits.conf* Soft

First, create a new table1. Creating a new table: CREATE TABLE tablename;eg:create table Books;2. Create tables and properties:CREATE TABLE Books (title_id INT Not_null auto_increment,Title VARCHAR (150),Pages INT,PRIMARY KEY (title_id));3. Add data

Wu Bingxi Source: http://wubx.net/Contact: wubingxi#163.com Reprint Please specify AS/translator and source, and can not be used for commercial purposes, offenders must investigate. Download binary version

Recently wanted to try the new version of MySQL 5.7.10, and then began to try to play the next.In this installation, use source code compilation to install MySQL, the compiler uses CMake.The version chosen here is the version of Mysql-5.7.10,cmake

1. What is Binlog?The Binlog log is used to record all SQL statements that have updated data or to save the modified record row;With the Binlog, can be used for real-time backup, Master/slave master-slave synchronization;Support for text format and

The mysqladmin command (headings) format is as follows (where user is the username, password is the new password): mysqladmin-u user-p password Password The command will prompt for the original password, and you can modify it after you enter it

We want to make sure that the Ubuntu14.04 server is able to surf the internet, I do not operate here, this is relatively simple. Since my server is deployed with cobbler, I want to change the source.# vi/etc/apt/source.list I use the official

MySQL Common commands#----set Root user password----> mysqladmin-u root-p Password> Enter Password#----Login---Login:> Mysql-u root-p> RootRemote Link:> mysql-h 192.168.0.201-p 3306-u root-p123#----Creation---Create a database> CREATE Database

MySQL loose index scan, mysqlloose As we all know, InnoDB uses the index organization table (IOT), which is called the index organization table, and the leaf node stores all the data, which means that the data is always stored in a certain order.

MySQL backup and restoration database mysqldump instance and Parameter Details, mysqlmysqldump We will certainly encounter the situation of backing up the database and restoring the database during the operation of the project. We generally use the

MySQL Partition Table Management ~ 2I. Maintenance partitions: CHECK TABLE, OPTIMIZE TABLE, ANALYZE TABLE, and REPAIR TABLE. These methods also apply to partitions. Next, we will explain the functions of these products. 1. Rebuilding partitions:

How to optimize MySQL insert PerformanceFor systems with large data volumes, the query efficiency is low, and the insertion time is long. We have a business system. It takes 4-5 minutes to import data every day. This time-consuming operation is

MySQL Performance-Schema (1) configuration tablePerformance-schema was first introduced in MYSQL 5.5, but now more metrics are added to performance-Schema in MYSQL 5.6 and 5.7, and more statistics are available, more and more ORACLE-AWR statistics

Mysql master-slave SynchronizationPrinciple: connect the server's IO thread to the master server to obtain the binary log, save it as a relay log locally, and then execute the SQL statement in the relay log through the SQL thread, so that the slave

MySQL database common tuning methods and parameter settings, mysql Tuning 1. Disable SELinux Vim/etc/selinux/config change SELINUX = enforcing to SELINUX = disabled 2. Change IO Schedule, no need to change the SSD Hard Disk echo deadline >

Writing to a MySQL database from SSIS, databasessisWriting to a MySQL database from SSIS   Source: http://blogs.msdn.com/ B /mattm/archive/2009/01/07/writing-to-a-mysql-database-from-ssis.aspxMatt Masson-MSFT 7 Jan 2009 PM 16 A couple of users

Use shell to automatically back up mysql databases at regular intervals#! /Bin/bash id = "root" # username pwd = "123456" # password dbs = "blog.ewsd.cn dangjian.ewsd.cn idc.ewsd.cn shangfa.ewsd.cn" # list of database names, separate multiple

In-depth analysis of mysql logon principlesThe first step in using the mysql database is to establish a connection and log on, and then execute the SQL command above. Whether it is through the mysql client, or through the C-API, JDBC standard