MySQL

I have never been very familiar with this aspect, when asked about the database engine, my brain despite the rapid operation of thousands of times, and finally can only shake their heads.After work, also search for this aspect of the content, look

Recently tried a small data migration. Local migration, Windows platform, modify the Data_dir entry in the configuration file, and then copy all the data files from the old database file to the past.After logging into the database, unexpectedly 1145

1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from

1234highcharts example5 6PHP7 $conn=mysql_connect("localhost", "root", "") or die("Connection Failed");8 mysql_query("Set Names UTF8",$conn);9 mysql_select_db("Office",$conn);Ten $sql= "SELECT Convert" (SUM (' Total2 '), Decimal (10,2

Run under the Mysql.exe.If yes, it may be necessary to add a definition DELIMITER//It means to tell MySQL that the statement ended after encountering//symbols.Otherwise, if MySQL encounters a semicolon, it thinks the statement is over and the

1. Querying dataSelect Property ListFrom table name and view list[Where Condition expression 1][Group By property name 1 [having conditional expression 2] [with rollup the last record is the sum of the above Records]]//The field specified by the

Recently in the study of MySQL index optimization, combined with some of our network system business, read some of the information, sorting out some of the following ideas:1, Index Establishment principle one: The leftmost prefix matching principle ,

First, resetting the MySql database root password L Modifying a configuration file   vim /etc/my.conf            # database location generated at installation # # # in [mysqld] This module Add code:skip-grant /etc/init.d/mysqld Restart #

Note: The index is generally suitable for frequently queried data, can improve the efficiency of the query, but not suitable for frequent use of the increase, deletion, modification of the data, the impact of inefficient.1.unique key-> (unique index)

"MySQL stored procedures and triggers--don't An Shu" *********************1. Under what circumstances are stored procedures used?To complete some troublesome logic, such as multi-table in the MySQL side of the CPU is very idle, with the stored

Before the use of SQL statements are directly search commands, usually do not pay much attention to remember them, interview when the face of SQL statements but found how also write bad. So now is still the common list, in need of time can be

Binlog is the MySQL binary log, and its primary purpose is to recover the database with the maximum possible, because the binary log contains all the updates made after the backup . In addition,MySQL's master-slave replication feature also relies on

1, query numeric data: SELECT * from Tb_name WHERE sum > 100; Query predicate:>,=,,!=,!>,!,= 2. Query string SELECT * from tb_stu WHERE sname = ' cricode.com ' SELECT * from Tb_stu WHERE sname like ' Uncle%too '

"Go" MySQL Database for internal connection, left join, right connectionInternal connection: The data corresponding to two tables are isolatedOuter joins: Isolate the corresponding data based on a tableFirst create the table in the database with the

1.C:\Program Files (x86) \mysql\mysql-5.5.33-win32\bin>net stop MySQLThe MySQL service is stopping.The MySQL service has stopped successfully.2.C:\Program Files (x86) \mysql\mysql-5.5.33-win32\bin>mysqlERROR 2003 (HY000): Can ' t connect to MySQL

Reference Documentation:1-gearman Distributed Task processing System (vii) Problem research and performance optimizationhttp://blog.csdn.net/jiao_fuyou/article/details/16335857Use of 2-gearmanHttp://www.cnblogs.com/cocowool/archive/2011/08/18/2145144

Previously published an article on SQL Server full-text indexing. Now Log The configuration process for the MySQL full-text index. Step1: CreateStudentTableCREATE TABLE ' Student ' (' ID ' INT (one) not NULL auto_increment,' Studentname ' VARCHAR (+

1 CREATEDefiner=' Root ' @ ' localhost 'PROCEDURE' AAC ' (_idNVARCHAR( -), _startdayNVARCHAR( -), _enddayNVARCHAR( -))2 BEGIN3 4 DECLARETmpidNVARCHAR( -);5 DECLARETmpstartdayNVARCHAR( -);6 DECLARETmpenddayNVARCHAR( -);7 DECLARESQLTextNVARCHAR( the);8

First: Set parameters in initialization file (MY.CNF)The default character set for MySQL database is Latin. So it needs to be set in MY.CNF. Like what:[Email protected] test]# MORE/ETC/MY.CNF[Mysqld]Default-character-set=utf8Then connect to MySQL

Table status Query (1) If you find that a data exception is large, you need to see which of these tables are larger, you can use the following command sql> SHOW table status from database name like data table name; or Sql>select