MySQL

The saying goes, "工欲善其事, its prerequisite," we're going to use PHP today to implement pagination. Then our first task is to build a PHP working environment. Environmental preparedness Using PHP technology, the best partner is the amp (apache,mysql,

Recently in the study of PHP, want to record their learning experience, and write some experience, only for reference exchange. This article is suitable for those who just contact PHP, want to learn and want to build their own nginx+php+mysql

I. Source of the probleminstall MySQL If you can install one manually, but install multiple, manual installation is cumbersome, you need to write a shell program install_mysql.sh to install Two. Procedural notesInstall the MySQL5.1.45 to

Slow sql: Queries that run longer than a given time range are called slow queries.How do I record slow sql in MySQL?A: You can set the following information in MY.CNF: [Mysqld] ; Enable the slow query log, default

The most effective way to optimize group by IS to use the index directly to get the field that requires the group completely. When using this access method, MySQL uses the type of index that the keyword sorts (for example, the Btree index). This

0, what is a database partitionto say what is a database partition, take MySQL for example. The data in the MySQL database is documented as the situation exists on the disk, by default placed in the/mysql/ Data below (can be viewed through the

Below through an illustrated way to introduce the general equipment Management Information System database creation process, details please see below. Equipment table: ID, name, category, model, date of shipment, date of purchase, manufacturing

The following article mainly introduces the basic types of MySQL character set, the actual operation of the unified character set, and other related content of the introduction, the following is the MySQL character set related content description, I

This paper describes the method of InnoDB data recovery in the case of MySQL exception recovery without primary key. Share to everyone for your reference, specific as follows: MySQL in the InnoDB engine database abnormal recovery, generally require

This article mainly describes the MySQL attack tampering data, using the backup from the library and the Binlog of the main library for incomplete recovery. Welcome to reprint, please indicate the author, source.Author: Zhangqq:176036317If you have

When it comes to using Mysqli_set_charset (Mysqli:set_charset) instead of "Set NAMES", of course, this content is also described in the PHP manual, but it doesn't explain why. Recently several friends have asked me this question, in the end

stored Procedures , you can think of the SQL statement that we need special processing into a function, when needed we just call this function can achieve the operation we want, this process we can call the stored procedure. Of course, the

Objective Sorting is a basic function of the database, and MySQL is no exception. The user is able to sort the specified result set by the order BY statement, not just the order by statement, the Group by statement, and the distinct statement

DISTINCT is actually very similar to the implementation of a group by operation, except that only one record is taken out of each group by after the groups by. Therefore, the implementation of DISTINCT and GROUP by implementation is basically

This article starts at InfoQ Chinese Station。 Author: Munling (Dragon), fenng.Note: To reprint friends, please pay attention to the first author of this article! This article is a summary of what he did after a dragon friend came to discuss it.

There is a need today to implement automatic database backup under Windows, piecing together a solution. Characteristics of the implementation Multiple databases can be specified Organize backups on a yearly/month/day basis Optional use of WinRAR

Recently there is a business needs, multiple machines need to query data from a MySQL table at the same time and do follow-up business logic, in order to prevent more than one machine to get the same data, each machine needs to be in the acquisition

You know, we often need to use the MySQL database in Linux or Windows, but we often make a very low-level small error, small set also often make mistakes, suddenly forget the MySQL root password, then will bring a series of trouble, The following

MySQL log files believe that we all have a lot of understanding, MySQL log files in general:/var/log/mysqld.log, the following teach you to modify the MySQL log file location method for your reference. Today need to change the location of the MySQL

Case descriptionDuring a timed script run, it is found that when the SQL statement of the backup table runs concurrently with the SQL statement that deletes the data in the table, MySQL detects the deadlock and prints out the log.Two SQL statements