MySQL

Brief introduction to the underlying statement:1. Description: Create DATABASECREATE DATABASE Database-name2. Description: Delete DatabaseDrop Database dbname3. Description: Back up SQL Server---to create a device that backs up dataUse masterEXEC sp_

MySQL Common commandsA long time not to write a blog, it is time to write a summary of recent learning things.Let's summarize some common commands for MySQL today:Login: Mysql-uroot-p-p3306-h----(-u means user name,-p for password, can not lose,-p

Recently in the MySQL database of two-way master and slave, learned that keepalived can automatically determine and switch to the available database, try it yourself, to sort out the document.Just declare the environment.Iptables turn on port 3306

MySQL installation files are divided into two types, one in MSI format and one in ZIP format. If the MSI format can be directly clicked on the installation, according to the installation prompts it to install (I believe you can read English tips),

DELIMITER $$ and DELIMITER;DROP PROCEDURE IF EXISTS ' pro_follow_getbookbeforeexpired ' $$DECLARE P_servicecode VARCHAR (50);SET p_servicecode = ' Yygh ';IF P_expiredminute = 0Then...;ELSE IF p_expiredminute > 0Then...;ELSEThen...;END IF;The Where

Regular expressions are special strings (character sets and) that are used to match text. For example, extracting a phone number from a text file.Basic character MatchingSELECT NameFrom CustomerWHERE name REGEXP ' Li 'The important difference

SHOW databases returns a list of available databases, which may be included in the MySQL database for internal use (such as MySQL and Information_schema)SHOW TABLESReturns a list of tables within a databaseSHOW COLUMNS from Customers,describe

Since the work of the company does not have a professional DBA and often need to establish a variety of tables to meet their business logic, so often check the MySQL manual or Google to view the relevant information, so I based on my work experience

1, after installing MySQL on Linux, there are a lot of MySQL related files.2,/etc/rc.d/init.d/mysql is the MySQL service startup script, is the Mysqld_safe package, Mysqld_safe is a script, is the executable file mysqld encapsulation3,/usr/bin/mysql

I've been thinking about how to incrementally back up binary logs, so we can use mysqldump + binary full or take advantage of xtrabackup+ binary backupThought: Using Mysql-bin.index, if it is the first backup, copy all the files in the

Recently in the process of doing struts project, need to use the MySQL database, in accordance with the original BS and CS project experience I first want to install MySQL, think of the embarrassment of installing SQL Server, but this time brother

1. Turn on and off the MySQL serviceWin platform: net start MYSQL55; net stop Mysql55linux platform: service MySQL start ; service MySQL stop2. Command log in to MySQL databaseMysql-h Localhost-u Root-p3. View all database names and all tables for

High-performance MySQL Reading Notes-lock, transaction, isolation level1. Why should I lock the lock? Because the database needs to solve the concurrency control problem. At the same time point, multiple clients may operate on the same row of

How to modify the character encoding of mysql5.6.24 decompressed (Installation-free or zip) 1. When We decompress the zip file format to the specified directory and complete the basic environment configuration, open mysql 5.6.24 will find the file

Nodejs + mysql get the automatically generated id when inserting a record Recently, when writing the back-end interface of the student reporting project, we found that the primary key automatically generated by the database needs to be obtained,

Usage of using in mysql database, mysqlusing The usage of using in mysql is as follows: Using () is used for join queries on two tables. The columns specified by using () must exist in both tables and use the join conditions. Example: Copy

MySQL database Triggers 1. Trigger with only one row of statements executed Trigger triggers are events that trigger certain operations, such as insert, delete, and update.   For example: create trigger t_user_trig before inserton t_user for each

Sorting and using MySQL built-in functions See mysql Official Website: Introduction to functions and operators For time and date functions, see Mysql5.5 official documentation. General examples 1. view the current system date Call the date

LAMP + Proftpd + data migration, lampproftpd  On Centos 6.5 64bit minimalInstall mysql[Root @ ftp ~] # Yum install-y mysql-server mysql-devel -- Installation[Root @ ftp ~] #/Etc/init. d/mysqld start -- start[Root @ ftp ~]

NoSQL non-relational databases, nosql Databases Disadvantages of relational databases: With the rise of Internet Web websites, traditional relational databases are dealing with Web websites, especially ultra-large-scale and high-concurrency SNS type