PHP

MySQL's time function bitsCN. comCURDATE () or CURRENT_DATE () returns the current date, in YYYY-MM-DD or YYYYMMDD format. Contains only the year, month, and day select curdate()+0;Result: 20140214 select curdate()+1;Result: 20140215 CURTIME () or

Difference between different Mysql master/slave formats (ReplicationFormats) bitsCN.com The reason why Mysql can synchronize between master and slave servers is that the events (events) on the master server are written to the binary log, and then

The real difference between Replaceinto and Insertintoonduplicatekeyupdate in MySQL is bitsCN.com. let's look at the following example: 1 Replace...1.1 enter raw data Mysql> use test; Database changed Mysql> Mysql> create table t1 SELECT 1 AS a,

MySQL optimization-application optimization: MySQL queries high-speed buffer bitsCN.com MySQL Query high-speed buffer The query cache stores the SELECT query text and the corresponding results sent to the client. If the same query is received

DATEDIFF function and TIMESTAMPDIFF time function in MySql bitsCN.com In MySql, there are many time processing methods. However, when I recently used the DATEDIFF and TIMESTAMPDIFF time functions, I found that I did not pay attention to them before:

MySQL learning NOTE _ 10_MySQL advanced operations (below) bitsCN. comMySQL advanced operations (below) V. MySQL pre-processing statements 1. set the pre-processing stmt and pass a data as the where judgment condition. Prepare stmt from "select *

Mysql method for exporting specified data or some data bitsCN.com In this case, mysqldump may be difficult to solve. the following method can be used to solve this problem.Method 1: Use insert and select in combination 1. create a new table, such

Explain can analyze the execution of select statements, that is, the execution plan of MySQL. The type column MySQL finds the required rows in the table. Including (from left to right, from worst to best): | All | index | range | ref | eq_ref |

Mysql connection query classic example bitsCN.com Mysql connection query: MysqlConnection query supports multi-table connection The same table can be connected multiple times (aliases are important when connecting the same table multiple

MysqlError: 1205 error diagnosis bitsCN.com Two days ago, I encountered a 1205 (ER_LOCK_WAIT_TIMEOUT) error. after half a day, I finally found the cause and mastered the principle + carefully discovered the guilt. Next I will share with you the

[MySQL] partition table bitsCN.com Unlike Oracle, MySQL does not have a global index and only has a partition index. Therefore, MySQL has more restrictions than Oracle: 1. the partition key must be part of the primary key. 2. the data type of the

How to modify the data folder storage location of mysql in Windows bitsCN.com After installing mysql according to the normal steps, it is found that the default directory of datadir isC:/Documents and Settings/All Users/Application Data/MySQL Server

Mysql optimization summary (insert and query) bitsCN.com 1. Speaking of mysql, we immediately think of its small size, fast speed, and open source features, so it is widely used. Today, we will summarize the two most frequent mysql operations:

MySQL download and installation 5.6.10.1 installation illustration bitsCN.com I ,: Http://dev.mysql.com/downloads/ Download version: Windows (x86, 32-bit), MSI InstallerII. installation steps: (1) system requirements: First, make sure that Microsoft.

MySQL configuration file my. cnf parameter optimization and explanation of Chinese bitsCN.com Mysql parameter optimization is difficult for new users. In fact, this parameter optimization is very complicated. for different websites, their online

Threadcache bitsCN.com for MySQL Recently, I was suddenly very interested in MySQL connections. according to the thread keyword, I can find the following status: show global status like 'thread%';+-------------------+-------+| Variable_name |

Mysql index and view bitsCN.com Original table student field: mysql> select column_name,data_type -> from information_schema.columns -> where table_name = 'student';+-------------+-----------+| column_name | data_type |+-------------+----------

Upgrade mysql from 5.0 to 5.1 bitsCN.com 1. Update method: directly overwrite the MySQL5.1.72 installation directory to the running Mysql directory.2. back up the database mysqldump-uroot-A-F>/data/mysql_upgrade_bak/all_databases. SQLPossible

The following describes four usage of fuzzy query in mysql: 1, %: represents any 0 or multiple characters. It can match any type and length of characters. in some cases, if it is Chinese, use two percent signs (%. For example, SELECT * FROM [user]

MySQL can use a slash to use the field name bitsCN.com. Today, MySQL can use a slash to use the field name, which is an unexpected result. Create table 'Op _ Day '( 'Id' int (11) not null AUTO_INCREMENT, 'Date' date not null default '2017-00-00