MySQL

From http://www.devshed.com/c/a/MySQL/Error-Handling-Examples/Error Handler ExamplesHere are some examples of handler declarations:If any error condition arises (other than a not found), continue execution after setting l_error = 1:DECLARE CONTINUE

1303-Can't create a PROCEDURE from within another stored routine.This error message is hard to understand, so it is okay to carefully check the content of the stored procedure. The Code is as follows:Copy codeThe Code is as follows:Create procedure

When backing up a database, the data table may have such a value array ('A' = 'B ','C' = 'D ')Value in this format. During data export, the newline is replaced with \ n (in windows, unix may be another symbol ). When you reply to data, if you use

1. Password modification: Use the mysqladmin command 1. For example, if your root user does not have a password and you want to change the password to abc, the command is mysqladmin-u root password abc.2. If your root account has a password, the

1. stop running mysql:/etc/init. d/mysql stop2. Use the skip-grant-tables option to start MySQL:/usr/bin/mysqld_safe -- skip-grant-tables &3. Now you can enter mysql without a password.# Myql> Use mysql;> UPDATE user SET password = password ('000000'

D: \ mysql-5.1.26-rc-win32 \ bin> mysql-X-utest test-e "select * from t1;" | tee f: \ out. xmlCopy codeThe Code is as follows: 1 2 -X: xml format-Utest (specify the user name and database, and there is no password here)"Select * from t1;" specifies

There is a server with a large volume of access traffic. There are nearly 600 million dynamic PVS per day, and the database query average is nearly times per second.On the other server, the program is the same as this one, but only about dynamic PVS

Unable to connect to mysql through mysql proxy If the host and password are correct, you may encounter a problem where you cannot connect to mysql. Check whether the mysql server uses old_password and whether there is a problem in my. cnf.PLAIN

/*** @ Purpose: Mysql database category* @ Package:* @ Author: lisen@sellingclub.cn* @ Modifications:* @ See:* @ Time: 2008.10.10*/Class DB_MYSQL{// ================================================ ======================================Private $

View parameters: show variables;SET parameter: set global parameter name = value. For example, SET the maximum number of connections to a database to set global max_connections = 1000.Use the shell> mysqld-help command to obtain a table with all

Or any of these methods can be applied to the database. I do not have a conditional test. If I have a conditional test, it is expected to solve the problem that the database reports this error.Preventive measures:1. Make sure to back up the database

The basic principle is to allow the primary database to process transactional queries, but to process SELECT queries from the database. Database Replication is used to synchronize changes caused by transactional queries to the slave database in the

I hope this book will be able to talk to you like an expert, so that you can learn the required knowledge with simple questions and examples. In order to achieve this purpose, I will gradually establish concepts for everyone from every detail, and

I have seen the implementation of MYSQL Data Synchronization, but I have not done it myself. Today I have nothing to do with it. There is another empty computer next to it, all under the same vro. Haha, exactly.But first, I got stuck in the

#1067-Invalid default value for 'xxx' This error occurs when a field in the table is modified. Display: The field name already has an error.You have to delete this field and add it again.UTF-8 import MYSQL Chinese no displayToday, I exported the

Because MYSQLDUMP adds a global lock for the entire database.If MYSQLDUMP is used for full-database backup, the following three factors may be affected.1. The server CPU is severely blocked.2. the disk I/O line is increased.3. All queries become

Step 1:1: high-speed hard drive (7200 RPM). In theory, 7200 channels are searched per second. there is no way to change this. The optimization method is to use multiple hard disks or store data separately.2: The read/write speed of the hard disk,

PS: The following is a transfer. It is used to record that this is not the original intention of a regular expression, but it only uses REGEXP. Regular Expressions are more flexible and convenient.Replace sohu with sina in the author_url record of

MySQL error code list:1005: An error occurred while creating the table.1006: database creation failed1007: the database already exists. An error occurred while creating the database.1008: the database does not exist. An error occurred while deleting

Copy codeThe Code is as follows:Create or replace view BLOG_V_ADMIN(ID, NICKNAME, SEX, EMAIL, PHONE, QQ, MSN, HTTP, REGISTER_TIME,IP, LAST_LOGIN_IP, LOGIN_TIME)ASSELECTA. ID, A. NICKNAME, A. SEX, A. EMAIL, A. PHONE, A. QQ, A. MSN, A. HTTP, A.