MySQL

PHP and MySQL transaction processingIn general, transactions should have acid characteristics. The so-called acid is Atomic (atomicity), consistent (consistency), Isolated (isolation), durable (persistent) four words written in the first letter, the

Execute SQL as follows:CREATE TABLE `qcloud_sms_template` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ctime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(`id`),) ENGINE=InnoDB DEFAULT CHARSET=utf8;Execution Result:ERROR 106

Export DatabaseOpen the Navicat, right-click on the data we want to go around, then click "Dump SQL File" on the shortcut menu that pops up, and select the first "data and Structure" in the submenu item that pops up again. 650) this.width=650; "

Today's problem is this, has been installed before MySQL, has been used well, but today opened the service times abnormal, unable to start. In order to save trouble, so think of unloading load, in the process of installation found that 3306 has been

In web development, we often need to insert data from one table into another, and sometimes we need to specify an import field, which only needs to import records that do not exist in the target table, although these can be broken down into simple

MySQL deletes data in several cases and whether to free disk space:1, DROP table table_name immediately free disk space, whether it is InnoDB and MyISAM;2. TRUNCATE TABLE table_name immediately frees up disk space, both InnoDB and MyISAM. Truncate

Use MySQL to insert data containing Chinese in usercase table, error [ERR] 1366-incorrect String value: ' \xe5\xb0\x8f\xe5\xb0\x8f ' for column ' name ' at row 1The table statement and the inserted data statement are as followsCREATE TABLE usercase (

first, have the original MYQL of the Root the password;Method One:Outside the MySQL system, use the Mysqladmin# mysqladmin-u root-p Password "test123"Enter Password: "Enter the original password"Method Two:By logging into the MySQL system,mysql> use

1) First, why should I turn on Binlog log and slow query log?Binlog log will be recorded in the database, so adding and deleting the operation, when accidentally delete, empty data, or database system error, this time you can use the Binlog log to

Method One:1. Enter or in the DOS window net stop mysql5 net stop mysql 2, open a DOS window, this need to switch to the MySQL bin directory. In the bin directory, typically create a batch 1.bat, the content is Cmd.exe run a moment to switch to the

If the number of records that meet the criteria in Table B is greater than 1, there will be a case of 1:n, so the result after the left join will be more than the number of records in Table A.For example: The structure of member and Member_login_log

Problem starts with using MySQL command to insert Chinese data cannot be plugged inERROR 1366 (HY000): Incorrect string value: ' \xd6\xd0\xce\xc4 ' for column.Start viewing questions about the character set.If you use Set names ' GBK ';or set

"Pt-table-checksum"Pt-table-checksum is one of the Percona-toolkit series tools that can be used to detect the consistency of the data in the master and from the database. The principle is to run on the main library, checksum the synchronized tables

MySQL slow query log can record the query time is too long SQL, for performance problem positioning is very important, this article is intended to introduce the slow query log management use.Parameters1, Slow_query_log:on indicates slow query log on,

MySQL allows you to quickly delete all tables without deleting databases. This example describes how MySQL can quickly delete all tables without deleting databases. We will share this with you for your reference. The details are as follows: If you

Detailed description of MySQL master-slave database construction methods and mysql master-slave Database Construction This article describes how to build a MySQL master-slave database. We will share this with you for your reference. The details are

MySQL query cache and MySQL Cache MySQL query cache improves the performance of a single node in just a few ways. The cache is the first, because the memory performance is much higher than the disk performance. Cache is also a typical space-for-time

Mysql operator and function (fat instructor), mysql operator Function Use test;Create table 'Employee '(Emp_no int unsigned,Emp_name varchar (30 ),Emp_sex varchar (3 ),Emp_age tinyint unsigned,Sal double,History datetime);Insert into employee values

Mysql transaction processing details, mysql Transaction Processing I. Mysql transaction concepts MySQL transactions are mainly used to process data with large operations and high complexity. A logical execution unit consists of database operation

Basic MySQL tutorials-stored procedures-Basic mysql tutorials Note: 1. When using phpMyAdmin to create a stored procedure, change the delimiter '//'.   2. You can only create a stored procedure in the database management tool, but cannot