MySQL

1. First create a local database (for backup).Log in to MySQLsudo mysql-u root-p rootCreate DATABASE test; The test here is the same name as the remote database.2. Back up the remote database to a local testbackup.sqlMysqldump-h 172.26.100.145-uroot-

The SQL standard defines 4 levels of isolation. Lower levels of isolation can perform higher concurrency and lower system overhead.　　READ UNCOMMITTED (UNCOMMITTED)A transaction can read uncommitted data, called dirty reads. Rarely used.　　Read

First enter MySQL using rootMysql>use MySQL; Go to MySQL TableMysql> selecthost,user from user; //See if the root user is allowed to log on locally (localhost) onlyIf you do not perform the following statement modificationmysql> Update user Set

The problem, because the UTF-8 encoding could be two, three, four bytes. Emoji emoticons or some special characters are 4 bytes, and MySQL UTF8 encode up to 3 bytes, so data is not plugged in.That's my solution.1. Locate the My.ini in the MySQL

1, partitionSpecifically visible: http://blog.csdn.net/open_data/article/details/468933311, Partition type:Range Partition: Assigns multiple rows to a partition based on column values that belong to a given contiguous interval.List partitioning:

database table xxx is marked as crashed and should be repaired error resolution server Power off and other reasons may cause data table corruption, resulting in access to prompt: Table xxx is marked as crashed and should be repaired where xxx is the

Principle of a master-slave configurationMySQL replication is an asynchronous replication process that replicates from one MySQL instance (master) to another MySQL instance (Slave), where the entire replication process between Master and Slave is

How does MySQL performance optimization find problematic SQL? monitoring efficient SQL with MySQL slow log the following is the SQL statement associated with the slow query: show variables like ' show_query_log '//Use this to see if it turns on the

First, mathematical functionsMathematical functions are mainly used for processing numbers, including integers, floating-point numbers, and so on.ABS (x)Returns the absolute value of XSELECT ABS (-1)--return 1Ceil (x), CEILING (x)Returns the

1, installation check has been installed:Yum List installed mysql*Rpm-qa | grep mysql*To see if there are any installation packages:Yum List mysql*To install the MySQL client:Yum install MySQLTo install the MySQL server side:Yum Install Mysql-server

First, mathematical functionsMathematical functions are mainly used for processing numbers, including integers, floating-point numbers, and so on.ABS (x)Returns the absolute value of XSELECT ABS (-1)--return 1Ceil (x), CEILING (x)Returns the

First, the database storage engine IntroductionThe database storage engine is the database's underlying software component, and the database management system (DBMS) uses the database storage engine to create, query, update, and delete data

1. View the database encoding format 1 mysql> show variables like‘character_set_database‘; 2. View the encoding format of the data table 1 mysql> show createtable ; 3. Specify the

Webpy_web.database ModuleThere are two ways to use the MySQL management database in the WEBPY framework, one is to use the MySQLdb module in Python:Import MySQLdbThere is also a web.database module with Webpy, the function is basically the same as

MySQL database entry (database creation and table creation) -- Chen yuanbo and mysql Chen yuanboCreate databases and tables1. database creation (1) SQL statement Command database creation: Create database Name (encoding garbled characters are not

Important Mysql database knowledge points (zhitang learning experience) and mysql learning experienceMysql database knowledge point1. Manage database statements: Database usage: Use test; Add database: Create database name; Create database

Fatal error: Can't open and lock privilege tables: Table 'mysql. host' doesn' t exist, Today in the one-click installation of mysql shell script installation of mysql-5.1.73 software found that mysql can never start, many times after the execution

How does linux CentOS6.5 yum install mysql5.6? 1. Check whether mysql is installed on the new ECS instance. # Yum list installed | grep mysql 2. If you find that the system comes with mysql, do it with determination. # Yum-y remove mysql-libs.x86_64

SQL Calculation of timestamp difference SQL Calculation of timestamp difference Overview Sometimes we need to find some records by time, for example, calculate the record one hour before the sales time. SQL Calculation of timestamp difference

Mysql trigger usage example MySQL trigger syntax explanation: Trigger is a special stored procedure that triggers execution when inserting (inset), deleting (delete), or modifying (update) data in a specific table, it provides more refined and