MySQL

Can't create table 'xxx. # sql-1130_1 '(errno: 150) Cause: Check whether the two fields associated are of the same type. Solution: Change the field type to consistent   Cannot add or update a child row: A foreign key constraint fails ('xxx '. '#

We need to make an urgent request today,Algorithm4 million of the data is calculated (only Nick is included), and a customized database needs to be imported. 32 databases on MySQL (icluster_1 to icluster_32, calculate the remainder Based on

If you install the SDK according to the default configuration, you only need to follow the steps below. 1. CP/usr/local/MySQL/support-files/MySQL. Server/etc/init. d/MySQL copy the service file to init. d and rename it to MySQL. 2,Chmod +

Introduction   MySQL cluster is a technology that applies memory database clusters in a non-shared architecture system. This non-shared architecture can make the system use very inexpensive and minimum-configuration hardware. A MySQL cluster is a

MySQL has an error. You often guess before. Now we have this table. Check it out. [Chinese webmaster site] 1005: failed to create table [Chinese webmaster site] 1006: database creation failed [Chinese webmaster site] 1007: the database already

MySQL stored procedure basic functions 1. String charset (STR) // returns the string Character SetConcat (string2 [,...]) // connection stringInstr (string, substring) // returns the position of the first occurrence of the substring in the string.

MySQL getting started (4) -- Learning In the previous article, we learned how to create a database and a database table, and how to add records to a database table.How can we retrieve data from database tables? 1. Retrieve Information from a

How high is MySQL performance? I have been using PHP for more than half a year. I think this problem from the day before yesterday. Have been suffering, have been desperate, and are full of confidence now! MySQL is definitely suitable for DBA-level

Previously, MySQL had been plagued for a long time because it was resolved after tcmalloc. The problem is: the website traffic is not high, and the concurrency is between and during peak hours. The CPU usage is high, which fluctuates sharply

The uniq command can only remove repeated items. Test text [shuohai.lhl@v035114 bin]$ cat test 711[10.235.170.22:8123] 0 10.232.20.178 1648042 1648042 0 2013-07-29 20:01:35 711[10.235.170.22:8123] 11

Recently, MySQL-MMM was used in the production environment of the project to improve Database Availability and processing capabilities. In the initial stage of the project, MySQL-Mmm installation, configuration, and deployment were always

In the previous article "Configuring MySQL Mmm from scratch", install and configure mysql-Mmm in 64-bit rhel6. In the past two days, I got a 32-bit centos 5, and encountered some other problems during the configuration process. I. dependency

1. Install pure-ftpd and MySQL Apt-Get purge vsftpdApt-Get purge pure-ftpdApt-Get purge pure-ftpd-commonApt-Get purge pure-ftpd-MySQLApt-Get purge pure-ftpd-LDAPApt-Get install pure-ftpd-mysql-Server 2. Configure pure-ftpd Echo

Although this script is relatively simple, I think it will help us a lot!To put it simply:Db_user = "user" is the user name.Db_pass = "password" is the password Mkdir/home/mysqlbak/$ date specifies and creates the directory to be backed upBin_dir = "

Method 1PhpMyAdmin is the simplest. Modify the user table of the MySQL database,But don't forget to use the password function. Method 2Use mysqladmin, which is a special case stated above.Mysqladmin-u root-P password mypasswdAfter entering this

After a long time today, I finally successfully configured the tomcat5.0 Mysql Data Source. At first, the error "cannot create JDBC driver of class ''for connect URL 'null', cause: no suitable driver" always appears. Now I will write down my

If reproduced, please respect personal labor, be sure to indicate the original source: (http://blog.csdn.net/iihero/archive/2010/05/13/5585039.aspx) This article is original to iihero @ csdn.   I mentioned my in the previous article. INI/CNF:

All mathematical functions return null when an error occurs. -Subtract from a single object. Change the parameter symbol.Mysql> select-2; Note that if this operator is used with a bigint, the return value is a bigint! This means you should avoid

I am afraid I/O has contributed the most to database bottlenecks, I/O is the best practice for the optimization theory on the market and on the network. However, Moore's Law said: the hardware operation speed doubles every 18 months, and I/O is no

(1) lower_case_table_names ● Recommendation reason The GNU/Linux platform is case sensitive to names of databases, tables, stored procedures, and other objects. To reduce developer development costs, we recommend that you set this parameter so