MySQL

First, both functions are used to process databases. First, mysqli connections are permanent connections, while MySQL does not. What does it mean? MySQL will re-open a new process whenever it is used for the second time, while mysqli only uses the

I believe that you have had reinstallation experience when using MySQL. If you reinstall MySQL, it is basically the last step. Unless you reinstall the operating system, the reason is that the registry in the system is not deleted. The following is

Today, I will continue reading the book "mysql database development" recommended by the instructor. I encountered a problem when I saw the foreign key association problem with the innodb database, in the book, you can modify the parent table and

Mysql 5.5 is installed, and the character set is faulty. The previous mysql servers can be configured in the my. cnf configuration file. However, an error is reported even though this is not the case: At that time, no error logs were configured in

I believe most people have encountered too many instances to install mysql. I believe most people only need to find a multi-instance installation tutorial and it will be easy to solve, but the more smooth the installation process, the more

I. Basic ConceptsThe event concept was introduced in MySQL. The event is a time trigger, which is different from triggers event triggering. The event is similar to a linux crontab scheduled task for time triggering. It can be used independently or

I accidentally found such a Mysql connection class on my computer, and I can't remember where to add it to my favorites. paste it. Next several show_databases and show_tables .... and other methods use a bunch of echo, it seems that I have never

The mysql password has expired. Today, when I encounter a connection to mysql, the connection is always unavailable, Error 1: An attempt by a client to checkout a Connection has timed out The connection timeout error occurs for the first time.

Balanced data The fixed-length or variable-length string can be used for string type data. The difference is that a string of the fixed length is filled with spaces to the right to ensure the same number of bytes. The variable-length string does not

I don't know if anyone has encountered such a disgusting problem: two tables are connected to the query and limit. SQL is very efficient. However, after order by is added, the statement execution time has become very long, extremely low efficiency.

The positioning result is as follows: Customer environment:Windows server 2003 r2 standard edition sp2Mysql Ver 14.12 Distrib 5.0.18, for Win32 (ia32)In apache 2.2RisingWebshield client 1.08 The problem has been reproduced. It can be optimized. It

MySQL does not allow the select from statement to point to the table used for UPDATE. Of course, there is a better way than creating an endless temporary table. This article explains how to UPDATE a table and use SELECT in the query clause. Problem

The memory table is a table in the memory. The size of the memory used can be calculated by using My. specify max_heap_table_size in cnf. For example, max_heap_table_size = 1024 M. The memory table is different from the temporary table. The

Source: mysqlpub.com MySQL has two functions to calculate the number of rows affected by the previous statement. Unlike SqlServer/Oracle, do not cause functional problems due to this difference: 1. Use the found_rows () function to determine the

Copy codeThe Code is as follows :#! /Bin/bash # Mysql autobackup shell # # # -------------- Set the mysql login parameters Dbuser = root Dbpasswd = Dbserver = localhost Dbname = fwserver2008 Dbopt = -- opt Backupdir =/dbbackup/ # --------------- Set

The innodb engine is different from myisam in terms of statistics. Myisam has a built-in counter. Therefore, when using select count (*) from table, you can directly retrieve data from the counter. Innodb must scan the entire table once to obtain

Mysql is often used in the development process to export and import Chinese tables. This article will detail how to use it. If you need it, refer 1. Export data for utf8 first: (1) Export all tables of the source database: Copy codeThe Code is as

First, create a table to describe the problem. Copy codeThe Code is as follows: create table 'result '( 'Name' varchar (20) default NULL, 'Subobject' varchar (20) default NULL, 'Score 'tinyint (4) default NULL ) ENGINE = MyISAM default charset = utf8

Preface: With the popularization of innodb, innobackup has become a mainstream backup method. Physical backup can easily meet all database recovery requirements when creating a new slave. However, when a single table is accidentally deleted or a

Open Terminal Switch to the root directory [Shell @ localhost ~] # Su-uninstall Mysql5.0 from CentOS before installing Mysql5.5. [Root @ localhost ~] # Yum remove mysql Install cmake Download the cmakesource code package cmake-2.8.5.tar.gz [Root @