MySQL

Mapping MySQL Error Numbers to JDBC SQLState Codes MySQL Error Number MySQL Error Name Legacy (X/open) SQLState SQL Standard SQLState 1022 Er_dup_key S1000 23000

JDBC is a technology developed by Sun to connect databases in the Java language.First, the basic knowledge of JDBCJDBC (Java Data Base Connectivity,java database connection) is a Java API for executing SQL statements that provides unified access to

Original link: http://www.2cto.com/database/201303/195303.html, Mysqlslap introduction Mysqlslap MySQL5.1 is a benchmark benchmark tool, similar to the Apache Bench load generation tool, generates schema, loads data, executes Benckmark and queries

Add a table fieldALTER TABLE table1 add transactor varchar (ten) not Null;ALTER TABLE table1 add ID int unsigned not Null auto_increment primary keyModify the field type of a table and specify empty or non-emptyALTER TABLE name change field Name

One, NDB Cluster (distributed storage engine) storage Engine Brief IntroductionNDB storage Engine is also called NDB Cluster storage engine, mainly used for MySQL Cluster distributed cluster environment,Cluster is a new feature that MySQL has only

The server reads the comment table and returns the result set to the caller. The caller converts the result set to a JSON string list using JSON. dumps and returns it to the Web Front-end. After the datetime field dumps, it becomes a string

From: http://blog.chinaunix.net/space.php? Uid = 21144244 & Do = Blog & cuid = 1923636 Http://wwty.iteye.com/blog/698210 Let's first introduce the Oracle control statements.   If ElseElsifWhile For Loop The control

1. The main reason is that the iptables firewall is enabled in Linux and the TCP link from window to port 3306 of MySQL is initiated. Linux replied to ICMP server reject...The solution is to open port 3306 in the firewall; Linux uses the tool to

MySQL Index analysis and optimization solution 1. What is an index? Indexes are used to quickly search for records with specific values. All MySQL indexes are saved as B-trees. If no index exists, MySQL must scan all the records of the

Recently, an Apache + MySQL + PhP environment has to be installed. After Google, it is found that the current installation is becoming more and more simple. You don't need to bother with configuration and installation. You just need to execute a sh

L. a. m. p. (Linux, Apache, MySQL, PPH) is a golden combination of open-source software. Almost every Linux developer or administrator has the opportunity to access lamp. "How to install it? "Is the most asked question. This article will provide a

1. Overview of Xtrabackup: Percona Xtrabackup is an open-source and free mysql Database Hot Backup Software. It can back up InnoDB and XtraDB storage engine databases in a non-blocking manner (Table locks are also required for MyISAM backup ).

The following article mainly describes the actual operation process of JIRA + MySQL configuration and the sample code used in actual operations, there are also descriptions of the things that deserve our attention in actual operations. The following

MySQL WorkbenchIsDatabaseAdministrators, program developers, and system planners provide visual design, model creation, and database management functions. It contains the ER model used to create complex data modeling, forward and reverse database

MySQL database benchmark stress testing tool-MySQLSlap use Example 1. Mysqlslap introduction mysqlslap is a benchmark testing tool that comes with benchmark after MySQL5.1. Similar to Apache benchmark load generation tool, it generates schema and

Install mysql workbench in centOSStep 0: Install mysql before following workbench. The command is yum install mysql-server mysql-libs mysql-server. the functions of mysql packages are as follows: "mysql for the client tools, mysql-server for the

The difference between DATETIME, DATE, and TIMESTAMP in mysql is that the DATETIME, DATE, and TIMESTAMP types are similar. This article describes their characteristics and their similarities and differences. The DATETIME type can be used for values

In mysql, there are many methods for adding users other than root users. The simplest way for us to understand commands is to directly operate on the GUI, for example, phpmyadmin database management tool. If you know the command, you can directly

I feel that the string function of MySQL intercepts characters, which is more powerful than program interceptions (such as PHP or JAVA). So I want to make a record here and hope it will be useful to everyone.Function:1. Extract strings from the left

In North America, people are enthusiastic about PostgreSQL. With the development of PostgreSQL, PostgreSQL 8.x has already surpassed MySQL 5.x technically, and market transcendence is only a matter of time. In the end, users may have the opportunity