MySQL

install to see if it has been installed:To see if there are any installation packages:To install the MySQL client:To install the MySQL server side:Yum install mysql-server yum install Mysql-develstart && Stop database character Set settingsMySQL

To solve the garbled method, we often use "set names UTF8", then why add this code can be solved? Follow me down here. The internal execution principle of set names UTF8First of all, the MySQL character set problem. Windows can be modified by

Table level: Engine MyISAM, understood to lock the entire table, during the lock, other processes cannot write to the table, if it is a read lock, other processes can read at the same time, if it is a write lock, then other processes are not allowed

In the home when the transaction rollback good, one to the company bad use, and then check the next, is the type of MySQL table is not InnoDB, and then change the table structure when found, can not change, report the following error. Modify the

Because you often have to do some development work in the environment of Ubuntu Linux. There are many times when MySQL-related development work is involved. So the whole process to do a collation, in order to facilitate the installation of the

A period of time to contact the MySQL server, about the query worry about the collation, optimization mainly only a few tool functions: show profiling, explain, index, limitIf the boss complains that the server query is too slow, you might say that

MySQL foreign key (foreign KEY constraint)FOREIGN key: To ensure consistency of data integrity, the implementation of unified operation between multiple tables--Create a main tableCREATE TABLE Users (ID int (4) Auto_increment primary key,Name

The database used by the software is MySQL, because it is free, open source, and is almost the best option under Linux.The first thing to do in MySQL is to create a new database for the root user and empower the user:1 CREATE database jchat; 2 '

First, the operationMySQL The default character set is latin1 , but the character set used by most of our programs is UTF8, We just need to change MySQL 's character set. 1 ) View the default encodingShowvariables like ' character% ';+---------------

PhpMyAdmin started to open, but I changed the root password in the permissions, and then opened PhpMyAdmin to show: "PhpMyAdmin tried to connect to the MySQL server, but the server refused to connect. You should check the host, user name, and

• View the size of each library The code is as follows Copy Code SELECT SUM (data_length) +sum (index_length) from information_schema.tables WHERE table_schema= ' database_name '; The result is in bytes,

MySQL Delete all table method technology in databaseMaybe yes posted on 2015-01-23 12:16Original link: http://blog.lmlphp.com/archives/66 from: lmlphp backyardOutput the database table name and the SQL statement that needs to be executed by using

When multiple Web sites share a MySQL database, to make the database management is not confusing, the general use of different sites using different prefix name of the way to differentiate. And how to bulk modify the existing database prefix name it?

1. Download the source codewget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz2. UnzipTar zxvf mysql-5.6.23.tar.gz3. Install the necessary packagessudo yum install cmake gcc-c++ ncurses-devel perl-data-dumper4. Enter the MySQL

Install Mysql database on LinuxCheck whether the installation has been installed: yum list installed mysql* rpm -qa|grep mysql* Check whether the installation package is available: yum list mysql* Install the mysql client: yum install mysql

MySQL cursor operation guideThis article provides a detailed analysis of the usage of MySQL cursors. For more information, see Test Table level The Code is as follows: create table test.level (name varchar(20)); Insert some

Mysql metadata lock (3), mysqlmetadatalock Preface The MDL lock is mainly used to protect the metadata of Mysql internal objects. The MDL mechanism ensures the concurrency of DDL, DML, and SELECT query operations. MySQL Meta Lock (1) and MySQL Meta

Mysql adds, deletes, and adds PermissionsCreate mysql> insert into mysql. user (Host, User, Password) values ("localhost", "test", password ("1234"); adds a user name named test and Password of 1234, however, this user can only log on locally. If

MySQL database trigger) MySQL trigger: monitors a situation and triggers an operation I. Four Elements Trigger time: before/after Location: table Monitoring Operation: insert/update/delete Trigger operation: insert/update/delete Ii. Create a

Mysql installation in Windows Linux reports 1045 errors In the past, mysql was not installed in windows, but some problems occurred during installation in linux. The 1045 error also occurred during windows Installation yesterday, in my personal