PHP

For beginners: InnoDB bitsCN.com Beginner's note: One-Step InnoDB With the development of MySQL, the InnoDB engine has become an absolute main force. it is applicable to many scenarios except for the special requirements in fields such as big data

Install mysql5.5.27 bitsCN.com from mysql-cluster-gpl-7.2.8.tar.gz Install mysql5.5.27 from mysql-cluster-gpl-7.2.8.tar.gz #! /Bin/sh # Install mysql 5.5.27 through mysql-cluster-gpl-7.2.8.tar.gz # Add path Mkdir-p/var/lib/mysql # Add data

BitsCN.com I used windows for development, so I don't feel it. A problem found when I deployed my yii project to linux today, If the rbac table of yii cannot be found, the following error is returned:   CDbCommand cannot execute SQL statement:

Mysql master-slave synchronization architecture and principles bitsCN.com Architecture diagram Replication principlesMysql Replication is an asynchronous Replication process, from a MySQL node (called the Master node) to another MySQL node

MysqlInnodb learning experience: bitsCN.com Mysql Innodb learning experience For databases, most of the bottlenecks are due to I/O problems, so SSD-type devices can now become popular. Can I optimize the I/O of the database? I would like to give a

Mysql auto-index reset method bitsCN.com How to reset an automatic index in Mysql Because some record rows are deleted, the auto-increment field is not consecutive for 1, 3, 4, 5, 7, 10. In this way, to restore the sequential sorting of 1, 2

The hidden Max_allowd_packet parameter bitsCN.com Background: Today I saw a bug: http://bugs.mysql.com/bug.php? Id = 67448 After global & session max_allowed_packet is configured, the client still reports an ERROR such as ERROR 2020 (HY000): Got

Delete and truncate bitsCN.com in mysql Delete and truncate in mysql In MySQL databases, both the DELETE statement and the truncate table statement can be used to DELETE data, but the two statements are different, the following describes two

MySQL import and export common commands bitsCN.com Export script 1: Export of table metadata, stored procedures, functions, views, and small table data (excluding metadata) Rem exports data to the current date folder every time @ echo wscript. echo

Solve the MySql garbled problem by recording bitsCN.com Solve MySql garbled problem During the development process, you cannot avoid spam or a series of problems caused by spam. Garbled characters are the cause of character sets. they generally do

Navicat data modeling forPostgreSQL supports cross-platform Navicat BitsCN.com Navicat Data Modeler is a powerful and easy-to-use database design tool used to create and operate PostgreSQL Data models. Currently, Navicat Data Modeler for

MySQL configuration file: mysql. ini parameter description bitsCN.com MySQL configuration file mysql. ini parameters My. ini (my. cnf in Linux). when the mysql server starts, it reads this file and sets relevant runtime environment parameters. My.

ERROR1366 (HY000) in MySQL: Incorrectstringvalue problem bitsCN.com ERROR 1366 (HY000) in MySQL: Incorrect string value problem This is the encoding problem. the default encoding may be used when MySql is installed, or The UTF-8 file is

How to reset the automatic incremental column bitsCN.com of MySQL How to reset automatic incremental columns of MySQL The MySQL database provides a wonderful function of AUTOINCREMENT column index. Your database table can be defined as a primary

MySQL partition overview bitsCN.com MySQL partition overview Environment: [Html] Mysql> select version (); + ----------- + | Version () | + ----------- + | 5.5.28 | + ----------- + 1 row in set (0.00 sec) Partition is a table design

MYSQL 3: full text search bitsCN.com MYSQL 3: full text search 1. understand full text search 1. MyISAM supports full text search, but InnoDB does not. 2. when using full text search, MySQL does not need to view each row separately, and does not

How to assign a unique player ID in a region (continued) bitsCN.com Method for allocating a unique player ID in a region (continued) Related links: How to assign a unique player ID in a region Http: // database/201212/173832 .html In the past,

Reset the MySql password bitsCN.com in windows Reset MySql password in windows Operation in Windows 1. disable running MySQL. 2. open the DOS window and go to the mysql/bin directory. 3. enter mysqld -- skip-grant-tables and press

Mysql page garbled problem bitsCN.com Mysql page garbled Change the encoding format of the mysql database to the same, UTF8 or gbk. 1. database encoding 2. table encoding 3. my. ini Modify mysql character encoding to UTF8 Mysql database is an

Cancel the alarm bitsCN.com when an error occurs when a command is entered in MySQL. Cancel the warning when an error occurs when a command is entered in MySQL. When connecting to MySQL, you can add the-B parameter to cancel the alarm when an