MySQL

Preface: With the popularization of InnoDB, Innobackup has become the mainstream backup way. Physical backup for the new slave, the need for a full library recovery can be easily addressed. But when the single table data mistakenly deleted, or a

The scope of this article: a comprehensive description of MySQL database operations, divided into virtual host and server two situations. Virtual Host 1, through the phpMyAdmin import and export function, this software generally only supports the

In Navicat for Mysql,postgresql and Oracle The error occurred because the MySQL account does not have sufficient permissions to connect to the remote MySQL server. Only "localhost" connections are allowed by default after MySQL installation.

Learn MySQL database, MySQL table types are what you need to know, the following for you to introduce seven types of MySQL table, I hope you can learn the MySQL table type Help. MySQL has been in vogue for a long time as the most popular free

Previously thought that from the top to the next unified use of UTF-8 on the rest of the peace of the day, but today in the crawl Sina Weibo data is still encountered the exception of characters. The data captured by Sina Weibo throws an exception

For Windows platforms, when the MySQL database is installed, the system defaults to generating the license tables and accounts, and you do not need to execute mysql_install_db scripts to generate accounts and appropriate permission tables as you

Change the data type of a column [SQL] ALTER TABLE Visitor MODIFY Nam VARCHAR (30); Append new Column [SQL] ALTER TABLE Visitor ADD age INT; ALTER TABLE Visitor ADD age INT A; ALTER TABLE Visitor ADD age INT after Nam; Change the position of a

Problem description: After getting code, you cannot request the micro-trust API data with Ajax. This is related to Ajax Cross-domain access to the user information to save to MySQL, found that the Chinese all become?? Garbled By accessing the

The default behavior of timestamp before MySQL 5.6.6: Timestamp column if the null attribute is not explicitly declared, the default is not NULL. (Other data types, if not declared as NOT NULL, allow null values.) Sets the timestamp column value to

In the last two articles (MySQL backup and restore cold standby, MySQL backup and restore real-world use Lengbei), we mentioned the use of cold standby in the Lengbei and real environment. So starting from this article, let's look at the hot standby.

First, connect MySQL Format: mysql-h host address-u user name-P user Password 1, connected to the MySQL on the computer. First open the DOS window, and then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the

Recently, a very strange MySQL problem, using different SELECT statements to query all datasets actually get different number of records. SELECT * Gets 4 records, and the Select field gets 3 records.Specific questions can be seen in the following

This paper introduces the use of Group_concat functions in MySQL, such as select Group_concat (name). Group_concat function in MySQL The complete syntax is as follows: Group_concat ([DISTINCT] The field to connect [order by Asc/desc sort field]

MySQL 5.1 supports triggers as well as custom function interface (UDF) features, and can implement memcache Automatic Updates if combined with Libmemcache and memcached functions for MySQL. Simply record the installation test steps. Installation

The InnoDB engine is different in statistics and MyISAM, and MyISAM has a built-in counter, so when you use the Select COUNT (*) from table, you can directly retrieve data from the counter. And InnoDB must be scanned all the time to get the total

1. IntroductionIn the Web application architecture, the data persistence layer (usually a relational database) is a key core part that has a very important impact on the performance of the system. MySQL is currently the most used open source

The MySQL query cache is analyzed in detail from five angles: The working principle of query cache, how to configure, how to maintain, how to judge the performance of query cache, and the suitable business scenario analysis. Working principle The

#!/bin/bash #this is a script of MySQL backup if [!-d/mydata/data1/backup]; then mkdir/mydata/data1/backup fi CD /mydata/data1/backup file=$ (find.-type f-mtime-7 | grep. *all.sql) #查找7天内是否有备份的文件 echo $file if [-Z $file]; then echo "Backup all

Overview Log files are an important part of the MySQL database. MySQL has several different log files, usually including error log files, binary logs, common logs, slow query logs, and so on. These logs can help us locate events within MYSQLD,

I. Preface: Version information: okphp BBS v1.3 Open source version Because of PHP and MySQL itself, php+mysql injection is more difficult than the ASP, especially in the injection of the structure of the statement is a difficult, this article is