MySQL

MySQL is more and more used in database applications because of its small size and efficient operation. I used to develop a peer-to-peer application of the use of MySQL to save Peer-to-peer nodes, due to peer-to-peer applications, knot points are

Installation guide for MySQLthe easiest way to experiment with MySQL and PHP is to buy some space on a common Web page host. Although you can set up MySQL manually in your home computer, it can be quite difficult for beginners to do so and

When you apply a database in PHP, you typically use DDL statements to create databases, datasheets, and modify table structures in your Web site in a MySQL client's console, and then apply them in your PHP scripts. It is rare to execute DDL

Today, while doing a mini-letter wall lottery program, I encountered a problem, I need to query the difference set of scale, the business situation is this A table is used to save lottery users (www.111cn.net a person may have more than one piece

Index, it can be said that database-related optimization, especially in query optimization, one of the most common optimization means, although so, but the index is not a solution to query optimization of the Bible, can not only find query run fast

To help colleagues deal with a tricky business today, the problem is this: Regardless of which version of the MySQL client the client connects to the server, it is found that as long as the server side is set After character-set-server = UTF8,

Same: Consistent display format: YYYY-MM-DD HH:MM:SS; Different: Scope: DateTime support range for ' 1000-01-01 00:00:00′ to ' 9999-12-31 23:59:59′ Timestamp value cannot be earlier than 1970 or later than 2037 Stores: TIMESTAMP 1.4-byte

The correct PHP SQL statement should be written as: The code is as follows Copy Code $sql = "INSERT into table (datetime) VALUES ('". Date ("Y-m-d h:i:s", Time ()). The DateTime field is of type DateTime,

(1) To improve the database insert performance Central idea: as far as possible to write data to the database file and reduce the checkpoint operations. The following four configuration entries were modified this time:1) Set the

MySQL command line parameters full version The MySQL tutorial supports the following options: ---help,-?Displays a help message and exits. --batch,-bPrints the results, using the TAB key as the column separator, and each row occupies a new row.

There are three standard loops in the statements of the MySQL stored procedure: The while loop, the loop loop, and the repeat loop. There is also a non-standard way of cycling: GOTO, but this cycle is best not to use, it is easy to cause confusion

Say PHP can not mention MySQL, but to talk about MySQL, then PHP is bound to be mentioned. The rapid rise of PHP can not be separated from MySQL, and MySQL is widely used, but also closely related to PHP. The following is a detailed analysis of PHP4

Mysql-5.6.14-win32 for the installation of uncompressed version, installation version (http://dev.mysql.com/downloads/installer/5.5.html) there are many drawbacks.MySQL 5.6.14 Win7 32-bit free installation version configuration 1. Download mysql 5.6

Different points: 1. Truncate and delete Delete only the data do not delete the structure of the table (definition) The DROP statement deletes the table's structure-dependent constraints (constrain), triggers (trigger), indexes (index); That depends

Objective In the overall performance of the site benchmark, you can use a variety of tools, such as the famous AB (Apache bench), http_load and other tools. Here we are not concerned about their use, if you want to know, you can find the answer

The problem is this: A test table, the character set used by the latin1. Select to_id from test where to_id= ' cn like _ King '; +---------------+ | to_id | +---------------+ | CN Ceramics _ Pottery | | cn like _ King | +---------------+ 2 rows in

Original: Http://www.111cn.net/database/mysql/48888.htm This article summarizes a variety of solutions that cause the MySQL prompt to fail to start the MySQL service "1067 process unexpected termination", You can try to refer to a classmate who has

Mysql explain usage (use explain to optimize the query statement), mysqlexplain First, I will give a simple example and then explain the information in the explain column. Table 1: catefory document category table: Create table if not exists

This article has been tested by ourselves. The system is Ubuntu 14.04 server, and the Mysql database is Mysql 5.5. We are preparing to migrate it to Maria DB 10.1, for details about the migration methods of other versions, go to the official website.