MySQL

Data is the most valuable resource of the enterprise, as the data of the operation and maintenance personnel to back up the database is a particularly important work, the following is the personal search and personal summary of the records of the

Core tools: mysqldumpLocal Backup table structureMysqldump-uroot-ppassword--no-data--databases database1 database2 database3> filenameLocal BACKUP Database:Mysqldump-uroot-ppassword databasename > FileNameBack up all databases locallyMysqldump-uroot-

such as the next two table update statementsUPDATE hzxm201610 a,xmhzylb1201610 b SET a.gk07_1_6=b.gk04_11,a.gk07_2_6=b.f06_1,a.gk07_3_6=b.f07_1,a.gk07_4_6= B.f08_1 where substring (a.gk01,1,4) in (' 5323 ') and a.gk01=b.gk01 and dqdm= ' 532300 'What

Some simple searches can be implemented by MySQL's own full-text index and MATCH against query statement. The experimental steps are as follows.1. Build a tableDROP table IF exists con_video_file_des_test;CREATE TABLE ' con_video_file_des_test ' ('

--MYSQL Gets the current node and recursively all ancestor nodes--parameter description: Resultfield: Query return field, IDD to query the resource ID value, idfieldname ID field name, parentidfieldname ancestor ID field name, TableName table name,

[Mysqld]Port= 3306Socket=/tmp/mysql.sockDatadir=/data/mysql/dataServer-id= 1Skip-name-resolveExpire_logs_days=15Log-bin=mysql-binBinlog_format=mixedReplicate-do-db=allin_platformReplicate-do-db=allin_platform_logSlow_query_log = OnLong_query_time = 2

---restore content starts--- C # operation of the MySQL database stored procedure, URL The DATEDIFF () function returns the number of days between two dates. syntax DateDiff (DATE1,DATE2) date1 and Date2 parameters are valid dates or dates /

First step: Stop the MySQL serviceUse the command service mysqld stop to stop MySQLto view the default path for the MySQL database:/var/lib/mysqlusing cp-afir/var/lib/mysql/*/usr/local/mysqlHere's a f i r parameter specifically refers to what to see

SummaryFirst, MySQL ReplicationIntroducing the basic concept of MySQL replication, from the MySQL websiteSecond, Replication Configuration2.1 Basic Steps in Configuration　　　　　　First, MySQL Replication1. What is Replicaiton?For the purposes of this

1. Create a function firstBEGINDECLARE stemp VARCHAR (4000);DECLARE stempchd VARCHAR (4000);SET stemp = ' $ ';SET stempchd = cast (PID as Char);While stempchd are not NULL doesSET stemp = CONCAT (stemp, ', ', stempchd);SELECT Group_concat (cmnt_id)

Reference: http://blog.chinaunix.net/uid-23215128-id-2951624.html1. Log in as root account2.grant all privileges in discuz.* to [e-mail protected] ' 10.110.1.100 ' identified by ' 123456 ';All privileges means giving all permissions to the specified

Data from the shared master is not obtained, error message: Waiting for master to send eventSolution:1. Get Prno data from V-tableSELECT * from Vendor_pricemaster where prno= ' PR16100012 ';2. Displays the status of connecting from slave to master

In MySQL, sometimes the columns that need to be indexed are very long, and if you apply the index directly it can cause problems with indexing too large. So we can take some of the fields to do the indexing, for example:Add index: ALTER TABLE * Add

1. Standard process for working with MySQLImportPymysqlconn= Pymysql.connect (host ="127.0.0.1", port = 3306,user ="Root", passwd ="*******", db ="Homework", CharSet ="UTF8") Cursor=conn.cursor () R= Cursor.execute ("Show Tables") Conn.commit ()

PymysqlNeed to install the Pymysql module to use MySQL in PythonInstallationPIP3 Install PymysqlIf the installation fails, you need to upgrade the PIP versionpython-m pip Install--upgrade pipUse1. Execute MySQL1 Import Pymysql2 3 # Create a

Note: Multi-table queries and connection queries (left JOIN, etc.) function Similarly, without much difference.Create DATABASE Test charset UTF8 collate utf8_bin;Use test;CREATE TABLE Tb_chengji (Xuesheng varchar () NOT NULL default ' primary

MySql database Select usage summary, mysqlselect I. Conditional Filtering 1. Digital Filtering: SQL = "Select * from [sheet1 $] Where sales unit price> 100" 2. Character condition: SQL = "Select * from [sheet1 $] Where item name = 'fenders '" 3.

How does mysql query the maximum number of consecutive logon days between two dates and the number of mysql days? Preface A requirement encountered in recent work is calculated based on the number of consecutive days of user record, and the maximum

Mysql implements a simple example of two data columns in the exchange table and two mysql Columns Because of the recent project, there is a need to swap the two columns of data in the database. It takes a long time to complete the problem. Here we

Bug of update trigger in pt-online-schema-change, onlineschemachange When pt-online-schema-change changes the table structure, Three triggers are created. Table t2 in the following test case. The table structure is as follows: mysql> show create