MySQL

Step 1: SET max_sp_recursion_depth = 12; Step 2: CREATE createChildDept process SQL code www.2cto.com DELIMITER $ USE 'zhiku '$ DROP PROCEDURE IF EXISTS 'createchilddept' $ CREATE DEFINER = 'root' @ '% 'Procedure 'createchilddept' (IN rootId INT, IN

Mysql text import and export data to establish a test table. Prepare the data. First, create a table for testing to indicate the student information. The fields include id, name, age, city, and salary.The Id and name cannot be empty. Www.2cto.com

Mysql provides a complete set of log record configuration items, but many of them are disabled by default. I was wondering why Mysql does not have a query listener like SQL Server. After searching for information, it is found that Mysql can also

Use the local environment to build a MySQL master-slave database. First of all, let's introduce my configuration environment. The local machine is equipped with the MySQL5.5 IP address 192.168.1.101 (this address is self-applicable and will change

Mysql multi-column Index (Multiple-Part Index) when Multiple columns range scan, use the in SQL code show create table 20130314t1 CREATE TABLE '3030314t1 '('id' int (11) NOT NULL, 'col1' int (11) not null, 'col2' int (11) not null, primary key ('id')

In redhat, MySQL master-slave backup is used as a Java programmer in a small company. In addition to coding, the backup is also very complicated. This time, I have the opportunity to access the master-slave backup of MySQL Data, in the past, the

The mysql-proxy read_query method implements authentication connection after special SQL is executed. In mysql-proxy, you can set session variables, this function allows you to perform Secondary authentication by executing the specified SQL

Mysql database summary and review 1. enhanced mysql database Review 2. mysql transaction trigger 3. mysql index foreign key enhancement 4. zendstudio Installation and Use 5. svn version controller usage 1. mysql database review enhancement 1. Export

Delete/truncate/drop differences 1. delete/truncate only deletes data, does not Delete the table, the index structure. Drop will delete the table structure and the index/constrain/trigger that depends on the table. The procedure/function will be

Mysqldump: Couldn't execute 'select @ GTID_MODE... when MySQL 5.6 mysqldump is used to back up MySQL versions earlier than MySQL 5.6, an exception occurs. 1 mysqldump: Couldn't execute 'select @ GTID_MODE ': unknown system variable 'gtid _ mode' (119

The method for accelerating MySQL import and export the SQL statement exported by MySQL may be very slow during import. It may take several hours to import millions of data records. Using a few parameters properly during export can greatly speed up

Sp_object MYSQL obtains the content of the specified object and Definition Statement in the current instance [SQL] DELIMITER $ USE 'test' $ DROP PROCEDURE IF EXISTS 'SP _ object' $ CREATE PROCEDURE 'SP _ object '(p_OBJECTNAME VARCHAR (255 ),

In MYSQL, each user reads one record in three ways (group by xxx) and asks me about the SQL statements in this regard. I remember it specially, after all, this is also quite common [SQL] select * from (select * from member_payment order by id desc)

SQL optimization: Join two tables of millions. The process from 40 minutes to 3 seconds [SQL] the table structure is as follows: [SQL] CREATE TABLE 'deviceback' ('id' int (11) NOT NULL AUTO_INCREMENT, 'imei' varchar (100) NOT NULL comment' unique

Optimizer_switch is introduced in mysql 5.1 to control the behavior of the mysql optimizer_switch. He has some result sets that enable and disable optimizer behavior through on and off control. The global validity period and session are used. The

Mysql master-slave setup and Mysql O & M related commands 1, install mysql, a lot of ways, rpm installation yum-y install mysql-server mysql-devel mysql-plugin mysql-test2, start/etc/init. d/mysqld start3, master edit/etc/my. cnf # Make sure that

Mysql outfile infile import and export data 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 enclosed by' "'Lines

Ubuntu Server used the automysqlbackup script. The Server was accidentally shut down yesterday, causing damage to the database file in the development environment. So I remembered the automatic backup task. I originally planned to write a script

Mysql xtrabackup Incremental Backup mysql Incremental backup policy full backup on Monday, other Incremental backup, according to business needs, set the retention date, such as to retain January. Incremental Backup steps; 1. Create full backup; 2.

Log_bin_trust_function_creators error solution when mysql establishes a function locally or remotely or procedure, the preceding error is reported. The test result is that the value of log_bin_trust_function_creators is off: Set global