MySQL

Yesterday wrote a Dongdong, share the next to everyone.Drop PROCEDURE if exists sp_cleanuserdata;CREATE PROCEDURE ' Sp_cleanuserdata ' ()BEGIN/* Define a cursor */DECLARE V_dt bigint (0) default;Declare v_num INT DEFAULT 0;  /* cursors are assigned

Tag:procedure    trigger    create   mysql    Stored procedure One, basic syntax create PROCEDURE sp_name ([proc_parameter[,...]) [Characteristic ...] Routine_body Beginendsp_name represents the name of the stored procedure proc_

I. Introduction to Data migrationThe so-called data migration refers to the migration of the original database system to another business systemThe reasons for data migration are varied and may be business changes, hardware upgrades, platform

Preface * DRBD (distributedreplicatedblockdevice) is an open source software that synchronizes and mirrors data directly on a remote server based on the block device level. Similar to RAID1 data mirroring, typically with HA software such as

First, master-slave replication worksThe process by which MySQL implements the entire replication between master and slave is done by 3 threads, of which two threads (SQL thread and IO thread) are on the slave side, and another thread (IO thread) on

1. query numeric data:SELECT * FROM tb_name WHERE sum> 100;Query predicate:>, =, ,! =,!> ,! , =  2. query stringsSELECT * FROM tb_stu WHERE sname = 'Liu'SELECT * FROM tb_stu WHERE sname like 'Liu %'SELECT * FROM tb_stu WHERE sname like '%

When you use the Navicat for mysql client to connect to a remote mySql database, the system may prompt 2003-Can't connect to MySQL on '100. 210.102.21 '(10061). How can I solve this problem? In fact, this problem occurs because MySQL does not allow

  My experiences with MYSQL (1) My experiences with MYSQL (2) My experiences with MYSQL (III) My experiences with MYSQL (4)   There are many operators in MYSQL. This section mainly describes some operators in MYSQL, but not those in SQL

My experiences with MYSQL (1) My experiences with MYSQL (III) My experiences with MYSQL (4) Display width   You can specify the display width for All Integer Data Types in MYSQL, but not for SQLSERVER.     Create a table tb_emp( id ()) The data

Recently, a MySQL 5.0 is installed on Ubuntu. Because phpMyAdmin must also be installed, we plan to directly use the remote management tool Navicat for MySQL to connect. Create a data table through the mysql Command Line in Ubuntu and assign

We know that in SQL, we can use the like predicate (expression) for fuzzy search, and support % ,?, _ And Other placeholders.However, the fuzzy search function has many restrictions, which are too vague.In MySQL, The REGEXP keyword is provided to

As we all know, drop table will seriously consume server I/O performance. If the size of the table to be dropped is large, it may even affect the normal online operation. First, let's take a look at why a table with a large drop capacity affects

Therefore, such errors often occur.Copy codeThe Code is as follows:Select * from [IND] where INDID> 10UnionSelect * from [IND] where INDID So far, no questions have been asked Later, someone may use similar queries.Copy codeThe Code is as

This article describes network performance management techniques for Linux systems. It mainly describes how to use route, netstat, and tcpdump network management test tools and their functions. Route When configuring the network, you must specify

Note: This document provides two MYSQL instances, multiple instance methods, and so on. LINUX: centOS6.3 64bit (default system development kit installed)Database 1:MYSQL version: mysql-5.0.56PORT: 3306System Directory:/usr/local/mysql3306Database

Databases are IO-intensive applications. Their primary responsibilities are data management and storage. We know that the time for reading a database from the memory is microseconds, while reading an IO from a common hard disk is in milliseconds.

It is unknown that the database design 3 paradigm, which was regarded as the "Bible" N years ago, has not been fully applied. Here I have sorted out some common optimization techniques for database table structure design, hoping to be useful to you.

The User-Defined Function of MySQL is similar to an API. You can use C/C ++ (or C-language) according to certain specifications) compile a set of functions (udfs), compile them into a dynamic link library, and load and unload udfs using the drop

  1. System Environment Description:1. Two database servers, A and B;2. Currently, A is in use and serves as the master server. B is used as the backup database server;3. The database for Hot Backup contains data tables of MyISAM and InnoDB type; Ii.

Basic differences:The MyISAM type does not support advanced processing such as transaction processing, whereas the InnoDB type does. MyISAM tables emphasize performance, and the execution speed is faster than that of InnoDB, but transactions are not