PHP

This article mainly introduces how to ignore the index prompt in SQLSERVER. For more information, see when we want a query statement to use an index, we usually add an index prompt in the query statement, just like this The code is as

This article describes how to solve the MySQL error ERROR1615. this problem is caused by improper Mysql configuration. if you need it, refer to the test of the server combination script today, this is a strange problem. Mysql reports ERROR: ERROR

This article mainly introduces how to install Mysql5.5 in Centos5.5. This article uses the compilation method to install MySQL and provides possible errors and solutions, for more information about how to download mysql from centos in the next few

This article describes how to obtain the row number of a record in the query result set in MySQL. the solution is to use predefined user variables, if you need to include a column in the column returned by the query statement to indicate the row

This article mainly introduces how to store UUID in Mysql to remove the horizontal line. This article provides three Mysql functions to remove the horizontal line from the UUID. For more information,

This article mainly introduces the summary of commonly used SQL statements for MySql operations. This article describes examples of commonly used SQL statements such as adding, deleting, querying, and modifying, if you need it, you can refer to the

This article mainly introduces how to solve the problem caused by modifying datadir in Mysql, which is caused by SELINUX. This article solves this problem by disabling SELINUX. if you need a friend, refer to centos6.2, stop mysqld and modify/etc/my.

This article mainly introduces the perfect location for MySQL database migration under Ubuntu, which is very detailed. if you need it, you can refer to the following to consider data security issues, prepare to migrate the database on the server to

This article mainly introduces three tips for MySqlinsert insertion. This article explains how to insert data from other tables and how to exclude data during insertion (ignore) there are three tips for record duplication and record update during

What checkpoint does: refresh the dirty pages in the buffer pool back to the disk. The difference is that the number of dirty pages Retrieved each time to the disk, and when to trigger the checkpoint. Checkpoint: 1. shorten the database recovery

Some time ago, my project was finally completed. The project mainly involves reports and a lot of SQL statements, so I would like to summarize it. I. basic 1 database related command a create database CREATEDATABASE Database name B create a database

What is a cursor? The select statement may obtain n statements at a time, so the cursor can obtain a record in the select statement at a time. Move down every time one is obtained! Complicated logic can be implemented! There is also a problem above.

This has never been encountered before. if the content inserted into the Mysql database is too long, this problem will occur. the solution is to find the [mysqld] option in the Mysql configuration file Myini, find the max_allowed_packet attribute 205

The LOADDATAINFILE statement reads a table from a text file at a high speed. 1. basic syntax LOADDATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE39; file_nametxt39; [REPLACE | IGNORE] The load data infile statement reads a table at a high speed from

Sometimes there are too many fields in the table, just remember the table comments. to search for the field name through field comments, you can use the following statement: SELECTCOLUMN_NAME,

Prerequisites: four mysql databases need to be installed on linux, and the corresponding information must be configured. Mysql01: Master mysql02: Slave Database slave01 prerequisites: four mysql databases must be installed on linux. Mysql 01: master

Find the database storage engine: showenginesshowvariableslike % storage_engine % Change database engine change configuration file etcmycnf modify default-storage-engineInnoDB (storage engine to be changed ), then restart the database se to find the

Stored Procedure parameters: you can declare parameters in the brackets of the stored procedure. The syntax is createprocedurep ([inoutinout] parameter name parameter type) in: 20540 is passed to the parameter, and the defined parameter is 20540;

Run SELECTtEVENT_TYPE_IDFROMRATABLE_EVENT_TYPEtWHEREtNAME in the program to report the error code: 1267 invalid mixed character set. Error message: mixofcollations (gbk_bin, executed in IM program" SELECT t. EVENT_TYPE_ID FROM RATABLE_EVENT_TYPE t

Mysqldump is a client program used by mysql to store databases. It mainly produces a series of SQL statements that can be encapsulated into a file. This package contains all the SQL commands required to reconstruct your database, such as