MySQL

[Email protected] ~]# mysqldump-uroot-pzaq12wsx discuz #查看discuz The contents of the database[Email protected] ~]# mysqldump-uroot-pzaq12wsx discuz >/data/discuz.sql#备份discuz Library Data[[email protected] mysql]# Vim/etc/init.d/mysqld # View the

Vim/var/log/mysqld.logA temporary password is generated for [email protected]: Yqtahsiw/9miMysql-u root-pPassword:yqtahsiw/9miCreate user ' aa01 ' @ ' 192.168.100.140 ' identified by ' 123456 '; Create a user for 192.168.100.140, that is, the user

Copyright notice: This article by the lacquer Honkela original article, reprint please indicate the source:Article original link: https://www.qcloud.com/community/article/119Source: Tengyun https://www.qcloud.com/communityRule 1: The MyISAM storage

Trigger (Trigger): Monitors a situation and triggers an action, the trigger must have a name, a maximum of 64 characters, and may be appended with a delimiter.It's basically like naming other objects in MySQL.Trigger creation Syntax four elements: 1.

Test table level;Create table Test. Level varchar ());Insert some data, code, initializeDrop procedure if exists //Create a stored procedure createCREATE PROCEDURE usecursor () BEGINDefinition of local variables declareDeclare varchar

In the previous article we contacted some common MySQL statements, when we need to produce complex logic, we need to combine the MySQL statement, this time the MySQL statement is smelly and long, then we need to know the order of the MySQL statement

recently encountered in the production of a paging query particularly slow problem, the amount of data is about 2 million of the appearance, turned to the last page performance is very low, almost 4 seconds to come out of the entire page, need to

10.29 to 10.31th new registered user orders over $600 gift coupon in October#3天内订单满600元且10月注册的用户订单明细SELECTA. City, a. User id,b. User name, date (b. Registration time) asRegistration date, B. User address, B. Contact number, A. Salesperson, A. Order

1, the basic concept of MySQL replication 2, the implementation of MySQL replication 3. mysql replication architecture and dual Master model demo 4. mysql Replication Monitor/FAQs and Solutions

Forgot the root user password for MySQL and prompted when trying to connect:Mysqladmin:connect to server at ' localhost ' failedError:access denied for user ' root ' @ ' localhost ' (using password:no).Stop MySQL Services # service mysqld stopStart

1. Installing Mysql5.7Method: Manually Install 5.7One: $ wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.debDownload the corresponding. deb package to this serverBoth: $ sudo dpkg-i mysql-apt-config_0.6.0-1_all.debInstallation

/*Create a table*/CREATE TABLEtb_test (IDint( One) unsigned not NULLAuto_increment COMMENT'self-increment primary key', namevarchar( -) not NULL DEFAULT "'COMMENT'name',user_id int( One) unsigned not NULL DEFAULT '0'COMMENT'User ID', Update_timeint(

First, download MySQLMySQL download pageI'm using 5.6, click Next to "Looking for previous GA versions?" button to see version 5.6Mysql-5.6.30-winx64.zip (Thunderbolt) 351.1MIt's green, unzip it to the appropriate directory.Second, configure

Unix_timestamp "2009-09-15 00:00:00" converted to a function classified as a long integer typeSelect unix_timestamp("2013-03-15 00:00:00") *1000, it is important to note that the long integer in the MySQL database is less than the number of

1. Learn from http://blog.chinaunix.net/uid-7374279-id-4255927.htmlField name blob with four types of Tinyblob (255B), blob (65k), Mediumblob (16M), Longblob (4G)Example:CREATE TABLE Test (ID int Auto_increment primary KEY,Photo blob);2. Read the

/*Reprint please indicate the source, ID: Cherish the youth when*/Turn on MySQL service: net start MySQLTurn off MySQL service: net stop MySQLFor this reason, if there is missing hope to inform the remedy. Follow-up will also increase or decrease

1. Authorize user root to connect to the MySQL server from any host using the password jb51:The code is as follows:GRANT all privileges on * * to ' root ' @ '% ' identified by ' jb51 ' with GRANT OPTION;Flush privileges;2. Authorize user root to

Mysqlbinlog is used for binlog display, backup and redo.By default, Mysqlbinlog is rendered in a base-64-encoded manner. Such as:Mysqlbinlog master_bin.000006, the He output ignores some additional rowsMysqlbinlog-v master_bin.000006, plus verbose

A few days ago the interview was asked the database index problem, did not answer. Back hurriedly check the next, check the time only to find some knowledge about the database has been almost forgotten, and then follow the words do not understand,

Mysql database operations (3), mysql database operations   1. duplicate records are not displayed in the query results. Duplicate records are not displayed during query. The DISTINCT keyword is used to delete duplicate records. When performing the