MySQL

I changed the int type of id to bigint. In fact, it may be better to change it back. An error may occur during database backup.This problem occurs during the testing of the developed website background system:Invalid Query: Duplicate entry '000000'

Next, let's talk about the hardware and Forum information of my servers,CPU: 2 quad-core Intel Xeon 2.00 GHzMemory: 4 GB DDRHard Disk: SCSI 146 GBForum: the number of online members is generally about 5000-the highest record is 13264.Next, based on

Use case when for string replacementCopy codeThe Code is as follows:/*Mysql> select * from sales;+ ----- + ------------ + -------- + ------ + ------------ +| Num | name | winter | spring | summer | fall | category |+ ----- + ------------ + -------- +

1. Use mysqldump1. mysqldump backup database1. Go to the bin directory of the mysql installation file, for example, D: \ mysql5.5 \ bin>2. Use the mysqldump-uroot-p123 qh> d: \ qh. SQL command to back up the database.Mysqldump-uroot-p123 login to

Later, after referring to the documents on the Internet, the MYSql database on the server was connected through Http. Record:First download the latest version of NaviCat from the NaviCat official website (www.NaviCat.com.cn ).After the installation

If you want to connect to your mysql instance, this error occurs:Copy codeThe Code is as follows:ERROR 1130: Host '192. 168.1.3 'is not allowed to connect to this MySQL server Solution:1. Change the table. It may be that your account is not allowed

1. Load records in text files into mysql database tables(1) Text File Format: one record per line. The field values are separated by the tab operator. The field order is the same as the order in the table definition. The uncertain field values are

Ultimately, the following solutions are provided:1. Clear the installation directory of MYSQL. The default value is C: \ Program Files.2. Clear the MYSQL Data storage directory, which is generally in the C: \ Documents and Settings \ All Users.

1. Download the RPM installation package. Because the software requires a dependency when installing MySQL, we recommend that you download all the installation packages and then install the RPM packages in sequence.2. After installation in RedHat,

Recently, some troubles have occurred. The newly installed official PHPwind6.0 community found that the mail addresses of many Members seem to be filled out randomly when importing the previous Member account information, in PHPwind5.5, mail address

Copy codeThe Code is as follows:DELIMITER $USE 'servant _ 591up' $Drop procedure if exists 'SP _ move_data '$Create procedure 'SP _ move_data '()BEGINDECLARE v_exit int default 0;DECLARE v_spid BIGINT;DECLARE v_id BIGINT;DECLARE I INT DEFAULT

Description:When using mysqldump to export a Trigger, you may encounter a problem and paste it to avoid mistakes.When you perform the following operations:Copy codeThe Code is as follows:[Root @ ytt ~]

1. The concat function is often used to convert Int to varchar. For example, the concat (8, '0') string '80' is obtained'2. Convert varchar into an Int string of the varchar type using cast (a as signed).Summary: type conversion is similar to SQL

Directory1. Character Set Selection 12. Primary Key 13. Foreign key 24. index 24.1 The following conditions are suitable for creating an index 24.2. Index 3 is not suitable in the following cases4.3. Joint index 34.4. Index length 45. Special Field 4

Example:Copy codeThe Code is as follows:Create procedure 'justifygroupnum '()NOT DETERMINISTICSQL SECURITY DEFINERCOMMENT''BEGIN/* How to run: call justifyGroupNum ()*/DECLARE p_group_id int;Declare p_num int;Declare stopFlag int;DECLARE cursor_name

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

1. Design Principles1) standardization and standardization Data Standardization helps eliminate data redundancy in databases. There are several forms of standardization, but Third Normal Form (3NF) is generally considered to have achieved the best

If you have hundreds of thousands of data records, you can search for some popular words, and then read the last few pages to repeat the old dream. Mysql is so tragic that it does not stop operating hard disks.Therefore, you can try to make mysql

1After installing MYSQL, change the ROOT password and useNet startmysqlI encountered this problem at startup.C: \ mysql \ bin \ mysqladmin-u root-p shutdownNet start mysql does not have this error prompt!*************2MySQL error 1067Q: I

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.