MySQL

MySQL uses the value of the environmental variable TMPDIR as the path name of the directory for saving the temporary file. If TMPDIR is not set, MySQL uses the default value of the system, usually/tmp,/var/tmp, or/usr/tmp. If the file system that

Analysis of MySQL 7 types of logs (I) Error Log ① parameter log_error: Specify the log location and name ② function (I) Error/alarm information (ii) optimization help (ii) Slow query log ① parameter log_slow_queries: specify the log location and

MYSQL obtains the auto-incrementing primary key. [four methods] After we perform the insert operation on mysql in the application, we need to obtain the auto-incrementing primary key of the insert record. This article introduces four methods in the

When a MySQL user is created with SSL authentication and has SUBJECT and ISSUER, the error [Note] X509 subject mismatch: solution 1: simple SSL is OK: simple SSL verification is used, allocate account mysql> GRANT ALL PRIVILEGES ON test.* TO 'test'@%

MySQL learning footprint record 12-use subquery 1. subquery: Query raw data nested in other queries is as follows: Mysql> SELECT order_num FROM orderitems; + ----------- + | order_num | + ----------- + | 20005 | 20005 | 20009 | 20005 | 20009 | 20008

Mysql5.5.23 TYPE = InnoDB syntax error Create table if not exists 'ad _ aXXXX_test_delete '('payment' double () default '0. 0000 ', 'createdatetime' timestamp not null default '2017-00-00 00:00:00', primary key ('aspid ', 'date') TYPE = InnoDB; you

Programmer's mysql database auxiliary tool this database auxiliary tool (1.0) is completely open source and is a database auxiliary tool developed according to your company's needs, this tool helps programmers quickly search for database field

An interesting question: the maximum length of varchar in MySQLThe minimum heap of 1 K is obviously maintained, but only nine hundred rows of data are output to MySQL. Check the log and find the following content: 01stderr

In mysql, how to update a field value to its own value connected to a string CONCAT (str1, str2,...) returns the string produced by the connection parameter. If any parameter is NULL, the return value is NULL. There may be one or more parameters. If

Can't connect to MySQL server for linux tcp connection optimization recently two web machines are connected to mysql, sometimes there will be Can't connect to MySQL server, view the exception log: [message:protected] => SQLSTATE[HY000] [2003] Can’t

Mysqldump command note -- opt Mysqldump-uroot-p -- opt DATABASENAME [Table]> xxx. SQL  By default, the SQL file exported by Mysqldump contains not only the exported data, but also the structure information of all data tables in the exported

Modify the default Character Set of mysql in mac to utf8 1 and check the character set of mysql installed by default. mysql> show variables like '%char%';+--------------------------+--------------------------------------------------------+| Variable_

Mysql master-Slave problem handling records Slave server downtime, resulting in the slave server startup after the show Slave status \ G prompt error Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'binlog

Method 1 for Automatic Logon of MYSQL command line tool. It is required that the mysql (command-line tool) terminal be often used to connect to the mysql db service in the linux environment. The general syntax is as follows: mysql [options] db_name

The meanings of the Cascade, no action, Restrict, and set null foreign key constraints in Mysql to the sub-table: If NO candidate key is found in the parent table, the description of the parent table of the insert/update foreign key constraint on

Don't stick to the details-mysql Field Type Details mysql field type intvarchartext maybe you do not care at ordinary times, when designing the database, the number is set to int (10) string and set to varchar (20) or text is normal, but if you do

[SQL] MySQL performance optimization 1. Optimize the query cache. Most MySQL servers have enabled the query cache. This is one of the most effective ways to improve performance, and it is processed by the MySQL database engine. When many identical

MySql installation (rpm) and startup configuration installation steps: 1. Unzip the MySql installation package [Root @ bakdbserver mysql] # tar-xf MySQL-5.5.24-1.rhel5.x86_64.tar [root @ bakdbserver mysql] # ll total 373920-rw-r -- r -- 1 root 191242

Change the names of Mysql database tables to uppercase in batches [SQL] DELIMITER // DROP PROCEDURE IF EXISTS uppercase // CREATE PROCEDURE uppercase (IN dbname VARCHAR (200) BEGIN DECLARE done INT DEFAULT 0; DECLARE oldname VARCHAR (200 ); DECLARE

Last_Errno: 1062, Last_Error: Error 'duplicate entry '... 'for key'primary'' on query. in the detailed analysis process, I have never encountered 1062 problems in the online environment. the development environment of the test environment keeps