MySQL

Statement: My articles are all written after I have encountered and solved the problem in my actual work. You may have been clear for a long time or have no help for you. If you like them, please stick to them first, do not spray either. Just like

I was asked a question: what is the maximum varchar length in MySQL? This is not a fixed number. This article briefly describes the restrictions.1. Restrictions on Rule fields The following rules apply when defining a field: a) the storage

A problem caused by a Time Zone in mysql was recently reported by the customer. During the use of ERP 2BizBox, the following problem was found: when viewing the report profit and loss statement of the financial module, modify the time parameter, the

When I use Mysql to reset the management password, I will inevitably forget the management password. How can this problem be solved?Here we will first introduce a more common solution, including Windows and Linux operating systems: 1. stop the

Mysql adds a foreign key RESTRICT: as long as the table contains data directed to the master table, the relevant records cannot be deleted in the master table. In general, restrict is the safest option. Of course, it depends on the specific business.

Modify the database character set: [SQL] ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE...]; change the default character set and all CHARACTER columns (CHAR, VARCHAR, TEXT) of the table to the new character set: [SQL] ALTER

Mysql knowledge expansion-database/table sharding MySQL Internet Oracle Enterprise Application Data Structure. database Replication can solve the access problem and cannot solve the large-scale concurrent writing problem. To solve this problem, we

The ultimate solution for Mysql garbled Code recently runs an SQL file in the Mysql database that comes with Linux. There is no problem in querying the database. You can see Chinese data, but in JSP page display but there is garbled, in spring

When using the innodb engine, Innodb shared tablespaces vs independent tablespaces face the management and selection of two tablespaces. Innodb has two ways to manage tablespaces: 1. shared tablespace (you can also split it into multiple small

Mysql (7) go deep into the select query link: Mysql (1) mysql Installation http://www.bkjia.com/database/201210/162314.html Mysql (2) Database Operations http://www.bkjia.com/database/201210/162315.html Mysql (3) operations on Data Tables http://www.

MySQL ERROR 1366 (HY000): Incorrect string value. This is the encoding problem. The default encoding or UTF8 encoding may be selected when MySql is installed, therefore, an Encoding Error occurs during data insertion. if the data in www.2cto.com is

MYSQL 3: Full text search 1. Full text search www.2cto.com 1. MyISAM supports full text search, but InnoDB does not. 2. When using full text search, MySQL does not need to view each row separately, and does not need to analyze and process each word

I. how to start mysql in Ubuntu:/etc/init. d/sudo mysqld 2. add bin> mysql-u rootmysql> grant permission 1, permission 2 ,... permission n on Database Name. table name to username @ user address identified by 'Connection password'; permission 1,

Using mysql command line to export SQL is actually very simple. You only need two steps. First, enter the mysql command line, enter the database name for use, and then enter source test. SQL can export all the data in the Test table. You can use

MySQL table structure replication, table data migration, temporary table and view creation 1. copy only the table structure, do not copy data www.2cto.com select * into B from a where 1 <> 1; 2. Table data migration table B already exists: insert

View the running mysql status to monitor the running mysql. One way is to view the mysql running status. Www.2cto.com (1) QPS (Queries per second) QPS = Questions (or Queries)/seconds mysql> show global status like 'Question % '; (2) TPS

MySQL master-master replication, online table structure modification has always been to think that the dual-master architecture can solve the mysql table online DDL requirements, but there is no practical test experience. Later I found that there

In the mysql-proxy read_auth method, replace the username and password in the mysql-proxy read_auth method to replace the username and password sent from the client with the real user name and password, for example, replace reapcript/me with

Problems with MYSQL-type ORACLE sequence implementation MYSQL implements the nextval method of ORACLE to create a function, as follows: -- -------------------------------------------------------------------------- Routine DDL -- Note: comments

Mysql foreign key creation problem mysql foreign key creation error 150 Mysql error: error Code: 1005. can't create table 'joblog. SC '(errno: 150) create table SC (id int (10) unsigned not null auto_increment comment 'id', Sno int (10) unsigned not