MySQL

1, check MySQL and related RPM Package, whether installed, if there is installation, then remove (rpm–e name)[Email protected] ~]# Rpm-qa | grep-i MySQL mysql-libs-5.1.66-2.el6_3.x86_64 [[email protected] ~]# yum-y Remove mysql-libs*2, delete the

First, basic query, forget passwordInquire>show databases like ' MySQL ';>show databases like '%my% '; Query that contains my databasesSet Password#mysqladmin-u root password ' passwd ';Change Password#mysqladmin-u root-p ' passwd ' password '

Method 1: Use the Set password commandMysql-u Root　　mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');Method 2: Use Mysqladminmysqladmin-u root Password "Newpass"If Root has already set a password, use the following

1.mySQL Create stored process procedure as follows:/* The wonderful thing is to define a label [delimiter//] means procedure is not SQL, procedure's key word was eaten by the dog? */2. Process Control Language If then end if3.case when end

MySQL5.6.22: Click to download1. Run the Mysql-installer-community-5.6.22.0.msi installation package2.Developer default installation TypeServer only as ServerClient onlyFull fully installed typeCustom user-defined installation typeChoose the

Set character sets when creating databases and tables to avoid garbled Chinese methods:Create a databaseCREATE DATABASE test CHARACTER SET UTF8 COLLATE utf8_general_ci;--Note that there is an underscore between the following three wordsThe value

SELECT @ @tx_isolation; Viewing isolation LevelsSet session transaction ISOLATION level READ UNCOMMITTED; Set READ UNCOMMITTED levelStart transaction; Open transactionRollback Rolling backCommit SubmitSet session transaction Isolation level Read

Reference: http://blog.sina.com.cn/s/blog_4b93170a0100mbkm.htmlMySQL default maximum connection number is 100, add the default MySQL connection number method has twoMethod One: Enter the MySQL installation directory to open the MySQL profile my.ini (

MySQL Deletes the contents of the table, but does not delete the tables structureTRUNCATE TABLE DONGFANG_HK clears all data, primary key starting from 1Delete from Dongfang_hk deletes all data, the primary key continues to growMySQL add columns,

I almost did not write a blog, feel the knowledge to learn and to do too many things, no time. But found that the blog record their learning experience is very good, take time to write points for their future reference also share to some people, I

recently used a hospital server, but do not know the password MySQL, helpless under their own to find a solution, the process is very simple Oh! First enter the following line of statements: Mysqld--defaults-file= "E:\MySQL Server 5.1\my.ini(here is

Mysql stored procedures dynamically Execute SQL statements, mysqlsql Previously, we often concatenate SQL statements in the program. In fact, we can also splice SQL statements in the storage process for dynamic execution ~~ The Code is as

Create tens of millions of test tables in the mysql databasePreface: I have recently prepared to learn more about mysql, including the features, performance optimization, and database sharding of various engines. To facilitate testing performance

Introduction to MySQLMHA and its advantages MHA is the best choice for many enterprises that use MySQL databases for high availability. It is easy to use and powerful, and implements automatic master-slave failover Based on the MySQL replication

Linux installation MySQL-server-5.6.22 log I recently learned how to install Mysql, read a lot of online materials, and said that many methods of First Login with root fail. I checked the Installation Log carefully. In fact, people created a random

MySQL 5.6.22 installation tutorial   1. Run the mysql-installer-community-5.6.22.0.msi installation package 2. Developer Default installation type Server only acts as a Server Client only serves as the Client Full installation type Custom

Collection of exquisite SQL statements Some special usage is easy to forget when the SQL statement was previously written. I have sorted out the SQL statement operations to make it easier for me to write SQL statements. I want to paste them here and

Mysql Date and Time operations Select Curdate();-- Get the current dateSelect Last_day(Curdate());-- Obtain the last day of the current month.Select DATE_ADD(Curdate(),Interval-Day(Curdate() + 1Day);-- Obtain the first day of the monthSelect

Mysql storage engine Introduction # Not easy to write Mysql/fandb can find the table definition file frm data file MYD Currently, InnoDB uses the default storage engine of Mysql. The transaction engine supports the maximum performance of row

Modify the myslq Encoding Generally, myslq installation may cause garbled characters. latin1 is written in some environments by default. Latin-1 You can run the "show variables like 'character % '" command to run the "doc" command to view the