MySQL

test BULK Insert Mysql", if (!mysql_query ($sql, $con)) {die (' Error: '. Mysql_error ())}} mysql_query (' Set Autocommit=1 ', $con); mysql_query (' Set Unique_checks=1 ', $con); Mysql_close ($con); $ex = Microtime ( true)-$st echo "". ' Time: '.

What is a transactionA set of SQL statements Action Unit group all SQL complete a business if the entire group succeeds, meaning that all the SQL within the group succeeds if either one fails, meaning the entire operation failsThe data goes back to

Streamlined beauty ...1. Install MySQL serverHttp://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.21-winx64.zipNote: The part of this URL that removes the file name is the path to almost all file downloadsThe following article can be borrowed from

Recently we have built a Java Webserver with Tomcat and MySQL and deployed the game's server logic on the server.Soon after the game was online, we found a large number of garbled characters in the database. This is a very serious problem and must

Source installation Mysql database : download mysql-5.6.15.tar.gzFirst set up the installation environment1. Create a mysql user group and system account Groupadd-r MySQLUseradd-r-G MySQL MySQL2.rpm-qa |grep MySQL To see if you have software

1. The index does not store null values.More precisely, a single-column index does not store null values, and composite indexes do not store all null values. The index cannot store null, so the IS null condition for this column, because the index is

After you change the MySQL parameters, restart the MySQL database and view the log to find the following error message141029 2:23:37 [ERROR] Plugin ' InnoDB ' init function returned ERROR.141029 2:23:37 [ERROR] Plugin ' InnoDB ' registration as a

The INFORMATION_SCHEMA database is a MySQL-band that provides a way to access database metadata. What is meta data? Metadata is data about the data, such as the database name or table name, the data type of the column, or access permissions. Some of

host:10-4-13-72 user:password:select_priv:n INSERT_PR Iv:n update_priv:n delete_priv:n create_priv:n drop_priv:n Reload_priv : N Reload Permissions table shutdown_priv:n process_priv:n Server Management file_priv:n load the file on the server

Installation:CentOS 7 's Yum source does not appear to be properly installed when MySQL mysql-sever file, need to go to the official Web download ( by installing the Yum Source address, and then install MySQL via yum)Note: Before installing, you

Installed MySQL Server 6.0, the login is always prompt: 1045-access denied for the user ' like ' @ ' localhost ' (using Password:yes), on-line search for a half-day final Solution, special records the solution:First step: Stop the MySQL service;The

Mysql error-Modify mysql. sock location 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 under/etc/my. cnf. If not,

Familiar with MySQL stored proceduresStored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database, you can call and execute a stored procedure by specifying its name and giving a parameter (if the

Slow mysql subqueryWhen you use the explain tool to view the execution plan of the SQL statement, if the select_type field contains "DEPENDENT SUBQUERY", you should note that, you have fallen into the slow mysql subquery "pit "... Let's look at a

Analyze Mysql InnoDB Indexes Abstract: This article introduces the InnoDB Index-related knowledge of Mysql, from various trees to the indexing principle to the details of storage. InnoDB is the default storage engine of Mysql (MyISAM before Mysql5.5.

Mysql storage engine types and differences (innodb and myisam) Find the database storage engine: Show engines Show variables like '% storage_engine %' Change Database Engine change configuration file/etc/my. cnf Modify default-storage-engine =

MySQL trigger foreachrowFor each, each row is affected and all triggers are executed, which is called a row-Level Trigger. In oracle triggers, row-level triggers and statement-level triggers can be executed only once regardless of the number of rows

Usage of input, out, And inout parameters in MySQL stored proceduresStored procedure parameters: You can declare parameters in the brackets of the stored procedure. Syntax: create procedure p ([in/out/inout] parameter name parameter type ..) in:

Mysql automatic backupMysql automatic backup batch processing command: Set "Ymd = % date :~, 4% % date :~ 5, 2% % date :~ 8, 2% "set" hMs = % time :~, 2% % time :~ 3,2% % time :~ 6, 2% "mysqldump-uroot -- password = password weixin> D: \ mysql_back

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