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

MysqlTheserverquitwithoutupdatingPIDfile exception solution bitsCN.com Mysql The server quit without updating PID file exception solution After installing mysql, use Java code /Usr/local/mysql/bin/mysqld_safe & When mysql is started, it is

MySQL study Note 11: operator bitsCN.com Mysql can use operators to perform operations on data in tables, such as age calculation by birth date. Operators include arithmetic operators, comparison operators, logical operators, and bitwise operators.

MySQL study Note 12: data type bitsCN.com Well, it's embarrassing to start writing data types only now. In the previous book, the data types in MySQL were too complicated. In fact, a beginner only needs to understand the basics and then use them.

BitsCN.com Query performance of a mysql database This week I encountered a problem. Similar to the following simple query in a MYSQL table, it takes nearly one second. 1 Select sum (col5), sum (col6) from table_name 2 Where col_key_2 = 'value1'

Use SQL scripts to add the field bitsCN.com safely Add fields safely using SQL scripts Create procedure safe_add_col (tname VARCHAR (50), cname VARCHAR (50 )) BEGIN SET @ a = ''; SELECT column_name into @ FROM information_schema.columns

Usage of Loaddata in mysql bitsCN.com Import the txt file to the mysql database: Table: View Code Create table 'pet '('name' varchar (20) default null, 'owner' varchar (20) default null, 'species' varchar (20) default null, 'Sex' char (1)

When querying multiple database field names, the results are duplicated. Solution: bitsCN.com Multiple database field names can be queried. The database query results are repeated. what should I do? When using mysql, you sometimes need to query

Instance testing improves the efficiency of using indexes in Mysql bitsCN.com Improved efficiency of using indexes for Mysql instances Create a database: [SQL] Create database 'SQL _ learn_db '; Create a table: [SQL] Create Table: create table

MySQL character set and copy_and_convert bitsCN.com MySQL character set and copy_and_convert About copy_and_convert During the business stress test on MySQL, we found in the perf results that copy_and_convert is a cpu-consuming operation. This

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

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