MySQL

CREATE PROCEDURE ' test '. ' New_procedure ' () begin--need to define a variable that receives cursor data DECLARE a CHAR (+); --Cursor DECLARE cur cursor for SELECT i from test.t; --Traversal data end flag DECLARE done INT DEFAULT FALSE;

First, the business 1. Submit 2. Rollback 3. Acid characteristics Second, the View 1. Create a View 2. Delete View 3. Update view 4. Using views Third, sub-query 1.

Installing navicat for MySQL software After you create a new database, create a new table 650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/9A/0E/wKiom1lQwm3yDZsbAAJMPgMZBuY583.png-wh_500x0-wm_ 3-wmp_4-s_2895721085.png "style="

1. Newly opened cloud server, need to detect whether the system comes with the installation of MySQL# yum list installed | grep mysql2. If you find a system that comes with MySQL, do it decisively# yum -y remove mysql-libs.x86_643. Wherever you

I. Overview1. Definition　　　　2, the Classification of locks① from the type of data operation (read \ Write)Read lock (Shared lock): For the same data, multiple read operations can be performed simultaneously without affecting each other.Write lock

New Date (); New SimpleDateFormat ("Yyy-mm-dd HH:mm:ss"); int seconds=1481194381; Long millions=new Long (seconds) *1000; Nedate.settime (millions); System.out.println (Dateformat.format (nedate));Time

1. Download the ZIP installation package (second: Windows (x86, 64-bit), zip Archive) on the MySQL website http://dev.mysql.com/downloads/mysql/.2. After the download is complete, unzip it and place it in the directory you want to install.Example: D:

Under Window1. Export the entire databaseMysqldump-u user name-p database name > exported file nameMysqldump-u dbuser-p dbname > Dbname.sql2. Export a tableMysqldump-u user name-P database name Table name > exported file nameMysqldump-u dbuser-p

Http://www.jb51.net/article/103841.htm1. Download the website. DMG installation Package2. Install MySQLAfter the download is complete, click Install, confirm all the way, and wait for the installation to succeed.During the installation process,

1. View the MySQL lock table process.1 View the lock table process. 2 SELECT * from information_schema. Innodb_trx\g3 trx_mysql_thread_id:1111145 kills the lock table process. 6111112. Global read-only1 #设置全局只读 2 Set Global read_only=1; 3 4

MySQL5.6 Master-slave replicationFive steps to complete MySQL master-slave replication1./ETC/MY.CNF configuration of master and slave server, set unique ID to enable binary log.2. Create a master-slave copy of the account and authorize replication

Master (Master) 192.168.1.10 machine settings:[Email protected] mysql]# VI my.cnfAdd the following configuration under the [MYSQLD] nodeServer-id=1Log-bin=mysql-bin #这个一定得设置, otherwise there is no log, from the database will be error[Email protected]

Master Master server:ip:192.168.5.112sudo vi/etc/mysql/my.cnf[mysqld]server-id=1log-bin=mysql-bin# must write down the following sentence, otherwise you cannot telnet to the server #bind-address = 127.0.0.1 #这里可以设置哪些库需要备份, which do not need, I am

First step: Download Https://dev.mysql.com/downloadsSign up for an Oracle account, occasionally you can use it, and get used to downloading it on the website.Choose version 5.7.18 hereThe latest version of the installation and the previous

1. Background* MySQL is a relational database management system developed by the Swedish MySQL AB company and currently belongs to Oracle products. MySQL is one of the most popular relational database management systems, and MySQL is the best RDBMS (

Older versions of MySQL's full-text indexes can be used only on fields of char, varchar, and text in the MyISAM table.However, the new version of the MySQL5.6.24 on the InnoDB engine also joined the full-text index, so the specific information you

Mysql-u root-p# allows local IP access to localhost, 127.0.0.1# insert into Mysql.user (Host,user,password) VALUES (' localhost ', ' Zhouz ', p Assword (' 1234 ')); # Allow extranet IP access # INSERT INTO Mysql.user (Host,user,password) VALUES ('% '

1. Create a log storage directory:Mkdir/var/log/mysql && chown Mysql:mysql/var/log/mysql2. Modify the MySQL configuration log:Vi/etc/my.cnf.d/server.cnfLog_output=fileGeneral_log = 1General_log_file

Common data types in MySQLone, character type①char (n): fixed N-character length string, if the length is not enough automatic space to be padded; Range of N 0~255②varchar (N): Storing variable-length strings, most commonly③text: Storing

Pt-query-digest (percona toolkit), ptquerydigestPt-query-digest can analyze MySQL query information through logs, processlist, and tcpdump. The basic syntax is as follows: pt-query-digest [OPTIONS] [FILES] [DSN]  Pt-query-digest is a simple and easy-