MySQL Tutorials

Recently migrated WordPress, the system upgraded to CentOS 6, a very strange problem, in the original CentOS 5.8 under the normal time to back up the database and sent by mail script can not send attachments, the other is normal, the message content

This article mainly introduces the MySQL implementation query results export CSV file and import CSV file to the database operation, combined with instance form analysis of MySQL related database export, import statements using methods and

This article focuses on the role of the view in MySQL and the question of whether you can change it. A view is a virtual table that is not the same as the table that contains the data, and the view contains only queries that retrieve data

On the MySQL database backup and restore method, here is the first to refer to the Backup tool: Mysqlhotcopy, using the Mysqlhotcopy tool for quick backup, then data restore, using the MySQL command restore, and finally need to export the database

Preface: The cornerstone of high performance: good logic, physical design, according to the system to execute the query statement design schema This chapter focuses on MySQL database design, introduces the difference between MySQL database design

Objective: Keep Empty cup spirit, use performance analysis, focus on measuring server time spent where, think 1, how to confirm that the server has reached the best performance state, 2, why a statement is not fast enough, the diagnosis is

This article lists the MySQL data type list, which consists of five main categories: integer type, floating-point type, String type, date type, and other data types, which are explained in detail in the following five data types. There are also the

MySQL has a lot of graphical management tools, in the end which is better to use it? This article will introduce several commonly used MySQL graphical management tools, some of the use and download methods, see below for details. If you feel useful,

MySQL query too slow is a very annoying thing, so, the author has spent some time to organize the MySQL Query speed optimization program, this article is all the author's personal views, such as questions or wrong welcome to communicate and correct,

This article details the download and installation of MySQL tutorial, the text with the download address, as well as the environment configuration of MySQL, each step has a detailed introduction, to everyone to reference, I hope to help you. 1.

Installation of YAF First, download the YAF installation package PECL, enter the official PHP Extension Module website, YAF is included in the Search: Yaf Yaf php Framework in PHP extension, you can download various versions of the YAF

Usually SQL database needs optimization analysis, and there are some techniques, SQL optimization of several methods here do not do a detailed introduction, this article will be summarized in SQL statement optimization, followed by an optimization

The four storage engines commonly used in MySQL are: MyISAM storage engine, InnoDB storage engine, memory storage engine, archive storage engine. This article focuses on these four storage engines, and finally compares the four storage

one of the toughest problems in MySQL is how to get the first highest value in the result set n , such as querying for the second (or third n ) expensive product, and obviously not using a function like Max or min to query for it. However, we can

Reverse engineering of MyBatis One: What is retrograde engineering. MyBatis is an excellent persistence layer framework that supports custom SQL, stored procedures, and advanced mapping. MyBatis avoids almost all JDBC code and manually sets

WordPress starts with a simple blogging platform that has evolved over more than 10 years into a content management system that is used by many novices and experts, and even many high-end sites are built on this platform, which integrates and

When you learn MySQL, you often meet the index, what exactly is an index? Before I was only vague will use, but let me explain it is really a bit difficult, so that in the free time to consult the next book, in case someone asked me, I sorted out

What is the slow query log for MySQL? Definition: MySQL provides a logging function to record the MySQL corresponding time over the long_query_time value of the SQL statement, long_query_time default value of 10 seconds, the corresponding time of

Understand SQL injection from scratch, and what is SQL injection? SQL injection is the only I can operate the database, originally just let you enter the content to go, but you enter the command, so I do not know the operation of the database SQL

MySQL Database sub-Library sub-table scheme, once the database is too large, especially when the write is too frequent, very difficult to be supported by a host, we will still face the expansion bottleneck. At this point, we have to find other