MySQL

MySQL wildcard charactersThe pattern match for SQL agrees that you use "_" to match any single character, while "%" matches the random number of characters (containing 0 characters). In MySQL, the default mode of SQL is to ignore uppercase and

MySQL Automatic backup Batch command:Set "ymd=%date:~,4%%date:~5,2%%date:~8,2%"Set "hms=%time:~,2%%time:~3,2%%time:~6,2%"Mysqldump-uroot--password=password weixin> D:\mysql_back\weixin_%Ymd%_%hMs%.sqlCommand explanationTo use mysqldump to set

The code that follows the tutorial (2)The first step is to create a new database in the local MySQL database ZhyoulunStep two, create a new table in the database and insert several dataCREATE TABLE ' country ' ( ' Code ' char (2) NOT null PRIMARY

Sample data table: CREATE TABLE Test_bin (bin_id BINARY (+) not NULL) Engine=innodb; Insert data (content is a 32-bit UUID string value): Insert into Test_bin (bin_id) VALUES (Unhex (' fa34e10293cb42848573a4e39937f479 ')), insert into Test_bin (bin_

There is no detailed description of key_length in the MySQL manual, and the calculation method of Key_length is verified by experiments. When the index field is a fixed-length data type, such as Char,int,datetime, if there is a null tag, this

1. Build statementBuilding Tables is the most basic function of the database, the commonly used table statements are as follows:CREATE TABLE ' staff_info ' ( ' id ' int (one) not null auto_increment COMMENT ' PK ', ' job_number ' varchar (+) ' NOT

Pre-Preparation:CREATE TABLE T9 (A int, b text,c text,fulltext index Fix_test_for_t8_b (b)); #在定义表的时候加索引Create unique index ix_test_for_t8_a on T9 (A); #加朴素索引Create FULLTEXT Index Fix_test_for_t8_c on T9 (C); #加全文索引-----------------------------------

Select A.receiveid, (A.num-ifnull (b.num,0)) as Num from (SELECT Num,receiveid from Dog_giftnumrecord where Giftid = 1) as A LEFT join (SELECT Num,receiveid from Dog_giftnumrecord where Giftid = 2) as B on a.receiveid = B.receiveid　　Structure of the-

Familiar with MySQL stored proceduresStored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database, you can call and execute a stored procedure by specifying its name and giving a parameter (if the

Configuration steps for mysql dual-machine hot standby Set dual-machine Hot Standby: First, you must create a synchronization user on the two machines: Grant replication slave on *. * to 'repdcs '@ '192. 168.21.39' identified by '123 ';Grant all

Differentiation between after and before for MySQL triggerAfter: add, delete, modify, and then trigger the data. The triggered statement is later than the added, deleted, and modified statement, which cannot affect the previous add, delete, modify,

Back up the MySQL database in linux and delete the Backup Data seven days ago #! /Bin/bash # backup database hz jshuabo sdhuaboname =$ (date + % Y % m % d) /alidata/server/mysql-5.1.73/bin/mysqldump-u root-p123456 hz>/root/sqlBackup/hz. $ name. SQL/

Use the GROUP_CONCAT function of MySQL to implement aggregate multiplication.The MySQL aggregate function provides addition, average, minimum, and maximum, but not multiplication. Here we use the existing MYSQL GROUP_CONCAT function to implement

Shell to export each mysql stored procedure as a single file # Shell implementation: export the Stored Procedure Code in mysql as the file dbcn = "mysql-h172.16.1.194-uroot-p123456"; db = BCReport_Sync_Executor; ii = 0; ct = '$ dbcn-N-e "select

Basic mysql knowledge ReviewCreate a databaseCreat table test (# An integer usually uses an int.Test_id int,# Decimal is usually used for decimals.Test_price decimal,# Common text is usually used and Default is used to specify the Default

Question about using % (percentage) after like in mysql statements Question: Is the more mysql statements use the % (percent sign) after like, the slower the execution efficiency! Total time: 0.0489 seconds 0.0691 0.0485 0.0467 SELECT 'goods _

[Practice]: Synchronize SQL server data to mysql in real time 1. install and install mysqlconnector2. configure mysqlconnectorODBC data Manager-> system DSN-> Add-> mysql ODBC 5.3 ANSI driver-> Fill in data source name such as jt, mysql ip address,

Implement MySQL database backup in Java After work, I will take my spare time to summarize how to back up MySQL databases using Java: Import java. io. bufferedReader; import java. io. file; import java. io. fileOutputStream; import java. io.

10 skills and experience on databases1) Field Length and type: the data from the external system must be consistent with the external system to avoid insertion failure or truncation. Do not use large fields such as Blob, Clob, Text, and Image. 2)

Mysql database read/write splitting Grant replication slave on *. * to 'rep '@ '192. 172. %' identified by '12qazxcvfr34 '; Change master to master_host = '192. 17.1.150 ', master_user = 'rep', master_password = '12qazxcvfr34', master_log_file =