MySQL

MYSQL in Ubuntu is installed with apt-get, and the configuration process is skipped. Therefore, Chinese characters cannot be entered by default. 1. Find the cnf File Location of MySQL.Find/-iname '*. cnf '-print/etc/ssl/openssl. cnf/etc/mysql/debian.

Recently I want to create a testing environment with a large amount of data, so I found out how to insert million data records. I used 20 fields. For comparison, we first use the mysql stored procedure: mysql> delimiter $ mysql> set autocommit = 0 $

The master-slave replication of the MySQL 5.5 database is studied based on the online data. The data on the Internet is already very detailed, but I still encountered many problems in practice, the following is a summary based on the information on

1. Compared with interface operations, SQL statement operations are more flexible and powerful. Set character_set_client = gb2312; set character_set_results = gb2312; www.2cto.com 2. once the database and table are created, the next step is to

An article library contains two tables: category and article. There are 10 classified data entries in category. There are 0.2 million articles in articles.There is a "article_category" field in article that corresponds to the "category_id" field in

InnoDB and MyISAM are the two most common table types used by many people when using MySQL. The two table types have their own advantages and disadvantages, depending on the specific application. The basic difference is that the MyISAM type does not

When creating a temporary table, you can use the temporary keyword. For example, create temporary table tmp_table (name varchar (10) not null, passwd char (6) not null) 'www.2cto.com or create temporary table if not exists sp_output_tmp ENGINE =

Basic understanding of triggers and stored procedures in mysql: 01 trigger: a trigger that is triggered upon a certain operation (or before ), the attached operation is executed immediately. 02 purpose: monitor a situation and trigger an operation. 0

To disable a MySQL (Version 5.1) server process, we recommend that you use the mysqladmin client tool Background:It is very important to close the MySQL server process correctly. Improper methods will cause database damage. crash Method 1: Use the

MYSQL remote connection Configuration modification method ERROR 1130: Host '192. 168.1.3 'is not allowed to connect to this MySQL server solution: Change the table method. It may be that your account is not allowed to log on remotely, but only on

Differences between int and integer in MySQL: MySQLSever 5.1 question: What is the difference between int and integer in MySQL: www.2cto.com · INT [(M)] [UNSIGNED] [ZEROFILL] an integer of the normal size. The signed range is-2147483648 to 2147483647

MySQL Database Export SQL garbled solution environment: NavicatforMysql8.2 + MySQL Sever 5.1 problem: MySQL Database Export SQL garbled solution: Method 1: The database encoding into UTF-8. Database --------> right-click --------> database

Mysql operation primary key 1. query the primary key [html] SELECT t. TABLE_NAME, t. CONSTRAINT_TYPE, c. COLUMN_NAME, c. ORDINAL_POSITION FROM www.2cto.com INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS t, INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS c WHERE t.

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

Transient appearance on the MySQL server (5 ~ 30 seconds) when the performance fluctuates, it is difficult for general performance monitoring tools to grasp the fault site, and it is difficult to collect the corresponding fine-grained diagnosis

MYSQL's pseudo-row locks have always assumed that the row-level locks supported by mysql's innodb engine are the same as those supported by oracle and postgresql, and are used to lock data rows. But it is actually different. Different understandings

MySql LAN connection permission problem solution: you only need to execute a command on the MySql console, that is, assign the LAN connection permission command: grant all privileges on *. * to identified by '1'; Explanation: you can log on to the

MySQL gets the current time of the system function environment: MySQL Server 5.1 problem: MySQL gets the current time of the system function solution: NOW () function to 'yyyy-MM-DD HH: MM: ss' returns the current date and time, which can be

We all know the statements used to connect to MySQL in the LAN are jdbc: MySQL: // localhost: 3306/database, but when you want to connect to mysql on other machines, it is useless to change the localhost of the preceding statement to the

MySql stored procedure-4. Parameter-related links: MySql stored procedure-1. Basic knowledge of SQL stored procedure-1. Parameter classification parameters, same as programming, mySql stored procedures can also contain parameters. In the previous