PHP

Mysql User-defined method and cakephp paging join query method bitsCN.com Mysql User-defined method and cakephp paging join query method Step 1: set global log_bin_trust_function_creators = TRUE; If ERROR 1418 (HY000) is reported: This function

Method for resetting the auto-increment start value of various MySQL data table types bitsCN.com Methods for resetting the auto-increment start value of various MySQL data table types MyISAM data table After a record with the maximum number is

How to remotely clean up expired backup bitsCN.com on 48 sets of MySQLDBServer in Production How to remotely clean up expired backups on 48 MySQL DB servers in Production How to remotely clean up expired backups on 48 groups of MySQL DB servers!

Mysql log file usage and data recovery bitsCN.com Use and data recovery of mysql log files I. mysql log type MYSQL has different types of log files (each storing different types of logs), from which you can query what MYSQL has done and manage

Database System concepts reading notes-entity-contact model bitsCN.com Database System concepts reading notes-entity-contact model Preface To review the message system architecture I wrote, I need to reread the first three chapters of the database

MySQL limit query optimization bitsCN.com MySQL limit query optimization the following articles mainly introduce the specific content of MySQL limit query optimization. we all know that MySQL database optimization is very important. Limit is the

MySQLCluster-backup recovery preliminary test bitsCN.com MySQL Cluster-backup recovery preliminary test Data input on the SQL node: Create a test database and table Create database bg; Create table bgt1 (id INT, 'name' VARCHAR (20), primary

[MySQL] using mysqldump for text backup mysqldump BitsCN.com [MySQL] using mysqldump for text backup When using mysqldump to back up MySQL, the backup file is a text file in SQL format, which consists of a series of create table and insert

Usage of mysqlloaddatainfile (importing 40 W data to mysql in 3-5 seconds) bitsCN.com If you want to import Chinese data, the utf8 character set in mysql will save the UTF-8 character set for the xxx.txt file you want to import. the command load

This article describes how to use phpMyAdmin to modify the Mysql data table prefix in batches. if you want to share a Mysql database with multiple websites, generally, different websites are differentiated by different prefixes. How can I modify the

This article mainly compares the performance of distinct and groupby in MySQL. the content is more detailed and the comparison results can be seen intuitively, if you are interested, you can refer to some tests you have seen on the Internet recently.

MySQLStudy-MySQL common users cannot log on locally. after installing MySQL, we usually add common users with corresponding permissions to access the database. When a user logs on to the database locally, he or she often fails to log on to the

This article mainly introduces the sub-query operations in MySQL, and provides specific code examples. if you need them, you can refer to the following preparations: Create a test database TestDB; create database TestDB; Create Test tables

We can use percona's powerful weapon pt-heartbeat to monitor the master-slave replication latency of MySQL databases. Pt-heartbeat updates a specific table on the master database using timestamps, then read the updated timestamp from the database

By default, mysql users do not have the permission to remotely access mysql. Therefore, when the program is not on the same server as the database, we need to enable the remote access permission of mysql. There are two mainstream methods: table

The restoration process of the MYSQL backup database includes two sources of information-backup files and binary logs. backup files can be restored to the status when backup is executed, while binary logs can be restored to the status when a fault

MM. MySQLMySQL JDBC driver introduction mm. mysql is a Type 4 (pure java) mysql jdbc driver that complies with jdbc 2 specifications. The current version is 2.0 pre 5 (beta). you can download the latest driver from

EventScheduler, replace some timer tasks that can only be completed by the operating system Task Scheduler> yes. For example, crontabe in Linux can be executed only once per minute, while the MySQL event scheduler can execute a task every second,

Simple Guide to MySQL optimization 1. optimizing MySQL during compilation If you distribute and install MySQL from the source code, note that the compilation process will have an important impact on the future target program. different compilation

Use bitsCN.com for mysqlloaddatainfile Load data [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] Into table tbl_name [FIELDS [Terminated by 'string'] [[OPTIONALLY] enclosed by 'char '] [Escaped by 'char