MySQL

MySQL (MySQL certified MySQL training) because of its small size, fast, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownership of the Web site MySQL as the site

SELECT T1.name, t2.salary from employee as T1 INNER JOIN info as t2 on t1.name = T2.name; You can use aliases for data tablesSelect T1.id,t2.idfrom T1Left JOIN T2 on t1.id = T2.id and t1.id>1 and

=========================================================Method One: This method I am using, hehe, compare like this kind of instant sex.Versions above Mysql5.0 can support the recording of slower-performing SQL statements.Mysql> Show variables like

MySQL connection operationEstablish a connection$con = mysql_connect (' localhost ', ' root ', ' 123456 ');Determine if the connection is successfulif ($con) {Die (' Connection failed! '). Mysql_error ());Exit}Select a character SetMysql_set_charset

A database is like a water source, storing a lot of data. The connection is like a faucet that extends into the water and is connected to it. The command is like a pump that provides power and execution for pumping, and then returns the water to the

My 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 MySQL learning experience (v) operatorMy MySQL learning

MySQL basic Operation 1.mysql table copy MySQL table structure replicationCREATE table t2 like T2Replication of MySQL table dataINSERT INTO T2 select * from t1Operation of the 2.mysql index2.1 Increase of the indexALTER TABLE Tb_name Add index index_

Many MySQL default encoding is latin1, if MySQL in the installation time did not change the code, directly to its input in Chinese is not possible, will be garbled,First, the encoding of the field to be stored in Chinese is changed from Latin1 to

Related URL:http://willvvv.iteye.com/blog/1563345http://lxneng.iteye.com/blog/451985 This article on the use of variables and status write very well!---------------------------------------------------------Landing-------------------------------------

During the week:SELECT * FROM Wap_content where week (created_at) = Week (now)Query Day:SELECT * FROM table where to_days (column_time) = To_days (now ()), select * FROM table where date (column_time) = Curdate ();Query 7 days:SELECT * FROM table

MySQL Database data correctionhttp://blog.itpub.net/22664653/viewspace-717175/The need for data revisions is often encountered during the course of work, and the operation itself is not difficult. Operation requires the ability to keep rolling back ~

Mysql error-Modify mysql. sock location, mysqlmysql. sock Sometimes Mysql. sock location errors may occur in mysql, resulting in the inability to connect to the database. When an error is reported in mac: First modify my. cnf The location is

Use the GROUP_CONCAT function of MySQL to implement aggregate multiplication.The MySQL aggregate function provides addition, average, minimum, and maximum, but not multiplication. Here we use the existing MYSQL GROUP_CONCAT function to implement

Shell to export each mysql stored procedure as a single file # Shell implementation: export the Stored Procedure Code in mysql as the file dbcn = "mysql-h172.16.1.194-uroot-p123456"; db = BCReport_Sync_Executor; ii = 0; ct = '$ dbcn-N-e "select

Due to insufficient disk space in the 'default' file group, a new page cannot be allocated to the database 'tempdb '. After receiving a friend's question today, SQL server reported "unable to allocate a new page for the database 'tempdb' due to

MySQL multi-instance configuration (2) For centralized O & M of MySQL databases, you can deploy multiple MySQL instances on one MySQL database server. This function is implemented through mysqld_multi. Mysqld_multi is used to manage multiple mysqld

MySQL multi-instance configuration (1) For centralized O & M of MySQL databases, you can deploy multiple MySQL instances on one MySQL database server. This function is implemented through mysqld_multi. Mysqld_multi is used to manage multiple mysqld

Create a MySQL slave Database We know that Oracle has DataGuard to back up data in real time, which can be used for master-slave switchover. MySQL also has its own backup database solution, which is called master-slave replication. The MySQL slave

Question about using % (percentage) after like in mysql statements Question: Is the more mysql statements use the % (percent sign) after like, the slower the execution efficiency! Total time: 0.0489 seconds 0.0691 0.0485 0.0467 SELECT 'goods _

Mysql generates a complete Stored Procedure Definition Statement Select concat ('pr _ ', p. db ,'. ', p. name) FileName, CONCAT ('delimi', 'TER $ USE '', p. db, ''$ drop procedure if exists'', p. name, ''$ create definer = ', ''', LEFT (DEFINER,-1 +