MySQL

MORE: http://www.webyang.net/Html/web/article_138.htmlMySQL is often used to query specific fields, and occasionally need to show a certain part of the value in a particular field, how to deal with it?Then there are fuzzy queries, if you need to

Master-Slave synchronization principle:Execution of any SQL statement on the primary server will write the statement to the Mysqlbinlog binary log, from the server will always synchronize to update the binary log file to the local, and then the log

1. Install/remove of the service denied! error occurred while installing MySQL serviceToday in a machine (OS for windows7 64bit) The MySQL5.6.16 database, looked at the next machine, before the installation of MySQL, but did not start the

1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. Avoid null-valued fields in the WHERE clause, which will cause the engine to

For automated operations, such as backup recovery, DBAs often need to encapsulate SQL statements into shell scripts. This paper describes several methods of SQL statements for shell scripts in MySQL database under Linux environment, for your

MySQL Master Copy Build1. Build1.1 MasterMaster configuration (MY.CNF)[mysqld] log-bin=/usr/local/mysql-5.6.16/log/mysql-binserver_id=1Start Master./bin/mysqld_safe--defaults-file=/usr/local/mysql-5.6. /my.cnf--user=mysql &Create a user for

1: You can view information_schema.index_statistics to view the usage information for the index. You can also use the Pt-index-usage tool to analyze the logs and combine explain to analyze the indexes used.2:innodb locks the row when it accesses the

The New Year's egg pain, so look at MySQL optimization, read a lot on the internet on the optimization method of pagination, but, I personally try on a time, did not appear they said the phenomenon ... Is it my machine problem?Take a look at my

Sometimes when the program is updated, the database load suddenly comes up, or the number of concurrent doubled. This time if with show full processlist; There is no full SQL at all. How to see what SQL is causing it, on the Internet to check the

1 definitionsThe Bin-log log records all of the DDL and DML statements, but does not include the query statement, which is saved as an event and describes the process of changing the data, which plays an important role in recovering data from a

Select_type: represents the type of select, the following are common Simple table, which does not use a connection or subqueryPRIMARY: main query, which is the outer queryUNION: The second or subsequent query statement in a unionsubquery: The first

Another methodWindows:1. Admin login system, stop MySQL service or end mysqld-nt process2. Go to the command line and come to the MySQL installation directory. Assuming that the installation directory is d:/mysql/, CMD enters the command line3. Run

Problem phenomenona MySQL table was created with a field of date type, the default value of 0000-00-00 00:00:00, the query was using preparestatement, the query result is resultset, Removing the date field from the result uses Resultset.getdate

To install the MySQL source package:(1). Install CMake(mysql5.5 is compiled by CMake later)Download Unzip cmake-2.8.5.tar.gzTar zxf cmake-2.8.12.2.tar.gz-c/usr/local/srccd/usr/local/src/cmake-2.8.12.2./configure--prefix=/usr/local/cmakeMake && make

1. DatabaseView Databaseshow databases;Working with databasesUse [database name]such as: Use MySQLCreate a databaseCREATE DATABASE Bruce DEFAULT CHARACTER SET UTF8Deleting a databaseDrop database BruceQuery MySQL versionSelect version ();Querying

Mysql connection error "unblock with 'mysqladmin flush-hosts'", unblockflush-hostsMysql connection error "unblock with 'mysqladmin flush-hosts '" An error occurred while connecting to mysql cluster:Java. SQL. SQLException MESSAGE: null, message

An exception is thrown when MySQL queries the default time.The problem occurs when a mysql table is created, with a field of the Date type in the table. The default value is 0000-00-00 00:00:00. PrepareStatement is used for query, and the query

MYSQL insert several methods for processing duplicate key values, mysql several methods     When a unique column inserts records containing duplicate values on a UNIQUE key, the default insert error 1062 is returned. MYSQL has three different

Ten special MySQL skills MySQL is easy to learn and easy to use with a wide range of technical documents. However, with the rapid development of MySQL, even a veteran of MySQL sometimes lamented the functionality of the software. This article will

MySQL queries the size of disk space occupied by all databases and the size of all tables in a single database. SQL statement used to query the disk space of all databases: Select TABLE_SCHEMA, concat (truncate (sum (data_length)/1024/1024, 2),