MySQL

1. Enable the Log_bin log for the main library, set the log format binlog_format=mixed, or Binlog_format=row,Enable the Server-id of the main library#主库上加Synchronization log #只记录 the Ka_app

View database table basic information.SELECT * FROM INFORMATION_SCHEMA. TABLES where INFORMATION_SCHEMA. TABLES. Table_schema = ' database name ' and INFORMATION_SCHEMA. TABLES. table_name = ' table name ';View MySQL Database sizeSELECT sum

When you import a database using phpMyAdmin, you may encounter problems that cannot be imported because the database file is too large!The English tips are as follows: File exceeds the maximum allowed sizeIf the host you are using can customize the

Transferred from: http://www.phper163.com/archives/368How to view Nginx, Apache, PHP, MySQL configuration file paths in Linux, if you receive an environment that someone else has configured, but leave no documentation. At this point how to determine

Features of several common storage enginesHere we focus on several common storage engines and compare the differences and recommended usage between each storage engine. features Myisam BDB Memory InnoDB

JDBC Connection Database • Create a program that connects to the database in JDBC with 7 steps: 1. Load the JDBC driver: Before connecting to the database, first load the driver of the database you want to connect to the JVM (Java Virtual

Reprint Please specify source: http://blog.csdn.net/l1028386804/article/details/46507735First go to MySQL website download page:http://dev.mysql.com/downloads/mysql/#downloadsSelect Platform Choose Oracle & Red Hat Linux 4 & 5Download the following

Primary master SynchronizationPrepare two hosts first, all installed on MySQL.Assume that the IP of a host is: 192.168.216.10The IP of Host B is: 192.168.216.11Goal: Synchronize all tables in the test libraryFirst Step: Configuration fileHost a

Date type Storage space Date format Date Range Datetime 8 bytes YYYY-MM-DD HH:MM:SS 1000-01-01 00:00:00 ~ 9999-12-31 23:59:59 Timestamp 4 bytes YYYY-MM-DD HH:MM:SS 1970-01-01

Insert into T1 (v1) VALUES (' CN China ');SELECT * from T1;1, input GBK, interactive latin1, database latin1Insert, the client to GBK input as latin1 to explain, to the service, service does not need to transcode, GBK as latin1 into the database,

A few days ago to the company's developers virtual out a MySQL server, using SSH login after show databases, show tables are quick, but colleagues use the connection tool to connect dataLibraries need to wait a few seconds, with the program to

problem Description: A new table was created today using MySQL. A syntax error was reported when inserting data. Because you are using the Mabits Code Auto-generation tool, and you do not overwrite the SQL statement. So be sure that the SQL

Yum Install version php5.3.0　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　+ mysql5.1.3 (My.ini--->character_set_server=utf8)Compiling and installing php5.3.0The above means: two different PHP environments, one compiled install a Yum installation, the same

Method 1:From book Select Greatest (@found: =-1, user_id) as user_id, ' user ' as which_tbl from user where user_id = 1union allselect user _id as user_id, ' user_archive ' as which_tbl from user_archive where user_id = 1 and @found is nullunion

"Copyright Notice: respect for the original, reproduced please retain the source: blog.csdn.net/shallnet, the article only for learning Exchange, do not use for commercial purposes"This section describes MySQL advanced syntax, including attempts,

1. Build the LibraryCreate DATABASE db_name;2. Delete the LibraryDrop database db_name;3. Build a tableCREATE TABLE Tb_name;4. Delete Tabledrop table tb_name;5. Set User password (change password)Mysqladmin-u Root [-P root-h 127.0.0.1] password '

Mysql-5.6.17-winx64 Operation steps:First, install MySQL database1, download.: Http://downloads.mysql.com/archives/get/file/mysql-5.6.17-winx64.zip.2. Unzip the MySQL archive packageUnzip to the specified directory, D:\Dev\mysql-5.6.17-winx64.3. Add

Copy table structure + table dataMysql> Create tables t2 like T1;mysql> INSERT INTO T2 select * from T1; MySQL IndexA, Alert Table is used to create a normal index, unique unique index (the current column value is not repeatable) or Primary key

Samsung index in high-performance MySQLI have a deep question about this:One star: What does the relevant record mean?? (The word is very esoteric, what is the department of "related department")Two stars: If the B-tree (B+tree) index is established,

Given that MARIDB and Oracle MySQL are fading away, only Percona server and Oracle MySQL are left to choose from.Because Percona server does better in terms of performance than Oracle MySQL, especially the thread pool feature and recent acquisitions