MySQL

I was asked a question: what is the maximum varchar length in MySQL? This is not a fixed number. This article briefly describes the restrictions.1. Restrictions on Rule fields The following rules apply when defining a field: a) the storage

Local or remote connection to mysql: Unable to connect to any of the specified MySQL hosts solution: 1. firewall Enabled, and allow remote connection 2. the connection string is different for mysql versions or drivers. note that even the local

MySQL full-text retrieval Notes 1. MySQL 4.x and later provide full-text retrieval support, but the table storage engine type must be MyISAM,The following is a TABLE creation SQL statement. Note that the storage engine type CREATE TABLE articles (id

Use MySQL mysqlhotcopy to implement automatic database backup. the sh script source code can be added to the cortab at every day. Back up and package the MYSQL database. Set the source code of the file # crontab-e 0 1 ***/usr/local/src/backmysql. sh

Mysql binary non-root users start mysqld after Installation Problems 1. Non-root users install binary mysql distribution edition create users> useradd fc www.2cto.com> passwd fc enter password :... log On with fc and upload the binary mysql version.

MySQL database command line tool MySQL includes a server process to manage the database, as well as a series of tools for accessing the database and creating applications: mysql: Execute SQL queries in MySQL, you can also execute SQL commands stored

Ubuntu modify my. the cnf file causes mysql to fail to start. Recently, mysql was configured on the Virtual Machine. After installation, the character set is displayed as show variables like 'character % '; + bytes + | Variable_name | Value |

The problem that the MySQL table field name contains a minus signWhen inserting data into MySQL Data, the SQL syntax error is always prompted. After half a day of check, it turns out that the table name contains a minus sign. Original TABLE

Mysql slow query log process mysql slow query log is very useful for tracking problematic queries, you can analyze the resource-consuming SQL statements in code implementation, there is a high reference for our program optimization. This article

MySQL ERROR 1366 (HY000): Incorrect string value. This is the encoding problem. The default encoding or UTF8 encoding may be selected when MySql is installed, therefore, an Encoding Error occurs during data insertion. if the data in www.2cto.com is

The perfect solution for too many MySQL sleep connections is too many sleep connections. What will happen to the mysql server? It seriously consumes mysql Server resources (mainly cpu and memory) and may cause mysql to crash. What causes excessive

MySQL's "bug" on timestamp and mysqldump reproduce www.2cto.com. The problem that a colleague encountered when performing data dump is simplified as follows: 1. Create a table drop table if exists tb; create table tb (c timestamp not null default '20

Mysql master-slave replication technology (TEST) to start configuration: www.2cto.com Step 1: Create a replication account. Each slave uses the standard MySQL user name and password to connect to the master. The user who performs the copy operation

Mysql stored procedure thing management ACID: Atomic, Consistent, Isolated, Durable storage provides an excellent mechanism to define, encapsulate, and manage transactions. 1. MySQL transaction support is not bound to the MySQL server itself, but

Three methods for starting, stopping, and restarting the MySQL database in Ubuntu Server: ubuntu server 12.10x64 (mysql comes with the system). When we need to modify the MySQL configuration file my. cnf (my. ini). After the modification, We need to

Mysql show status command: show status; Aborted_clients indicates the number of dropped connections because the client fails to properly close the connection. The number of connection times of the MySQL server that failed the Aborted_connects

The problem of Count and index coverage in the MySQL optimizer indicates that an optimizer still needs to be improved. Based on the where condition and the fields in select_list, the optimizer determines whether to return to the clustered index to

Xtrabackup Backup and recovery mysql full Backup (1) Xtrabackup is an open-source project of percona. It is used to implement the innodb Hot Backup function similar to the InnoDB official Hot Backup Tool and can quickly back up and restore mysql

Mysql outfile infile import and export data (append mysqldump) Export [plain] SELECT * into outfile '/tmp/jason.txt 'fields TERMINATED by', 'From test. jason; or [plain] SELECT * into outfile '/tmp/jason1.txt' fields terminated by ', 'optionally

[Mysql] An example of subquery assumes that the table my_tbl contains three fields a, B, and c; now we need to query the minimum value of Column B under each different value of column a in the table. For example, the table record is: a B c1 3 'cd' 2