MySQL

1. Terminal Start mysql:mysql-uroot-pxxxx2. View all database names: show databases;3. Select a database operation: use database_name;4. View all the table names under the current database: show tables;5. Creation of a database: create databases

Using LNMP to install WordPress in the phpMyAdmin database when the strange appearance of phpmyadmin#1045 unable to log into the MySQL server, the solution is as follows:1 change root password-No Line 2 skip-grant-tables, no new user behind-Failed 3

Reprint: http://www.cnblogs.com/lyhabc/p/3691555.htmlMy MySQL learning experience (a) simple grammarMy MySQL learning Experience (ii) data type widthMy MySQL learning Experience (iii) View field lengthMy MySQL learning experience (iv) data typeMy

This paper mainly explains MySQL performance bottleneck analysis, performance indicators, performance index information collection tools and methods, analysis of the use of tuning tools.The article has not been completed, the following is an outline.

Damn it, it's weird, write a stored procedure. Damn, that's a simple thing. It's just a few more spaces. That's a real problem. I've been doing this for half a day.DELIMITER//create PROCEDURE pro11 () BEGIN DECLARE i INT DEFAULT 0; REPEAT

1.Create UserSyntax:CREATE USER 'username ' @ ' host' identified by ' password '; egCREATE USER ' pig ' @ ' 192.168.1.101 ' idendified by ' 123456 '; this restricts the IP of the accessible host to 192.168.1.101CREATE USER ' pig ' @ '% ' identified

CREATE DATABASE db_test; CREATE TABLE ' tb1 ' (' id ' int () unsigned not null auto_increment COMMENT ' auto-increment id ', ' rank ' int (ten) unsigned NOT NULL DEFA ULT ' 0 ' COMMENT ' rank ', ' add_time ' timestamp not NULL DEFAULT

Http://www.21andy.com/new/20100917/1952.htmlMySQL exported SQL statements can be very, very slow to import, and may take several hours to import when processing millions data. Reasonable use of several parameters during export can greatly speed up

Two different ways:The first type:Sort them first, and then merge the results with the temporary table nesting, noting that the order must be preceded by a limit, otherwise the order by does not workSELECT * FROM (SELECT * to T1 WHERE ID in (1,3,6)

Ubuntu uses apt-get after installing MySQL, the server's default encoding is Latin1, the following changes the server's code to UTF8.View MySQL and encoded informationLook at the MySQL message:Mysql> select version ();

1.usage PermissionsThis permission can only be logged into the database, cannot perform any operations, and usage permissions cannot be recycled2.select PermissionsThis permission is a field-level permission to query the data in the table3.insert

MySQL may have this error when performing a delete, update, such as you wrote a SQL similar to the following:UPDATE SET Col=col+1where in (SELECTfromWHERE Othercol=0)OrDELETE from WHERE inch (SELECTfromWHERE othercol=0)This time will appear table '

Exec_master_log_pos:the position of the last event executed by the SQL thread from the Master ' s binary Log (relay_master_ Log_file). (Relay_master_log_file, Exec_master_log_pos) in the Master's binary Log corresponds to (Relay_log_file,

MySQL master-slave replication and read-write separation based on mysql-proxy (bottom)　　Yesterday talked about MySQL to achieve master-slave replication, but because of time is not said about the implementation of read and write separation, the

Differences between InnoDB and MyISAM In the Mysql storage engine (network arrangement)1. innodb supports transaction processing, not myisam. Myisam is faster and has better performance.2. select, update, insert, and delete operationsMyISAM: If you

Common mysql operations1. mysql insert update on duplicate If the update key conflict occurs, update the data according to the specified rules. Sometimes this is more convenient. Another method is to update data in a table. In this way, the status

Record the SQL statement executed by MySQL Comparing Oracle functions to learning Mysql will always discover highlights Using the log mining skill in Oracle, you can find all records that have been executed; Mysql also provides 3 methods

Install mysql In debian Apt-get install mysql-client mysql-server In the middle, you will need to set the password. After the password is set, mysql will be automatically started. You can use ps-ef | grep mysql to view related mysql processes.

Compile and install MySQL5.6.23 on CentOS7 1. Download source code wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz 2. Extract tar zxvf mysql-5.6.23.tar.gz 3. install necessary packages sudo yum install cmake gcc-c++

Php operation mysql -- connect to the database to create a table Filling Table