MySQL

Job required to change all the MySQL table engines to InnoDBExecute the following SQLSET @DATABASE_NAME = ' name_of_your_db ';SELECT CONCAT (' ALTER TABLE ', table_name, ' engine=innodb; ') As Sql_statementsFrom Information_schema.tables as TBWHERE

After installing MySQL at night (System: Deepin WINXPSP2, MySQL version: 5.1.32), the default data storage path is configured with MySQL's own configuration tool: C:/Documents and Settings/all users/ Application Data/mysql/mysql Server 5.1/data/.

MySQL's order by it involves three parameters:A. sort_buffer_size sort Cache.B. Read_rnd_buffer_size the second sort cache.C. The maximum sort constraint for max_length_for_sort_data.Let me just briefly say MySQL's sort rules. If the query statement

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

According to the phonetic sorting of Chinese characters, the comparison is more in the sort of the name, according to the phonetic Alphabet of the surname, from A to Z sort;1. If the field that stores the name uses the GBK character set, it is good

Paip. Importing data into the English voice database MySQL road to solve the empty principle problem#---Reason: MySQL import tool bug#---Resolution: Do not use double quotes around phonetic notation.The author old Java Claw Attilax Ayron.

--Trigger is a special kind of monitor and delete operation, and produce corresponding operation--1, monitor who 2, monitor action 3, monitor time (before or after) 4, trigger event--simple syntax of triggerCreate TRIGGER Trigger name

Reference http://www.cnblogs.com/zhcncn/p/4027025.html1 Installing the JDK:sudo add-apt-repository Ppa:webupd8team/javasudo apt-get updatesudo apt-get instal oracle-java8-installerRun after installationJava-versionJava Version ' 1.8.20 'Set Work

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

When you encounter this MySQL save Chinese garbled problem, look forward to find the MySQL save Chinese garbled reasons and solutions such an article can solve the problem is how exciting.Perhaps 30% of programmers will choose their own Baidu, the

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

Several ways to determine if MySQL is normal#################################Method 1: Look at the portNetstat-lntup|grep 3306|wc-lLsof-i: 3306 |wc-lRemote:/telnet/nc/nmap#################################Method 2: See the processPs-ef |grep

(reproduced in this article from http://superve.leanote.com/post/Untitled-560d35b538f4117cf700031d)Linux generic binary MySQL installation Download the generic binary package > cd /usr/local/src > wget

Official data: Http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unixAnother value gets the reference to the MySQL device. http://hearrain.com/2011/01/498 with Python-mysql Pack blogAccording to official

1. Add your own data directory and XML file2.lib Dependency Commons-logging-1.1.1.jar Dbunit-2.4.8.jar Junit-4.9b2.jar Mysql-connector-java-3.1.12-bin.jar Slf4j-api-1.6.1.jar Slf4j-jcl-1.6.1.jar 3.ant file as

Several methods of MySQL data export Some questions from the web are about how to export data from MySQL for use on a local or other database system, and to import existing data into a MySQL database.Data exportThere are several ways to

Reprint Please specify source: http://blog.csdn.net/guoyjoe/article/details/48805847**********************************the management mechanism of MySQL lock**********************************some locks at MySQL server level? Table-level Locking

Install MySQL Latest version 56install mysql 1 Start errorben:~ soul$ which mysql/usr/local/bin/mysqlben:~ soul$ mysqlERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2SolutionsRunto the MySQL

The MySQL database data file is stored by default: C:\Documents and Settings\All Users\Application Data\mysql\mysql Server 5.1\datal, where can I see it?Of course, from the MySQL configuration file, find the MySQL installation directory, find My.ini,

Yesterday quickly off work, colleague Small T said X platform login not up, see the next error message, database is not connected. The database is mysql5.5, the database deploys a machine n on the intranet, the application is deployed on the