MySQL

Mysql basics: mysql column type-time and DATE. The supported range is '2017-01-01 'to '2017-12-31 '. MySQL displays the DATE value in 'yyyy-MM-DD 'format, but allows you to assign a value to the DATE column using strings or numbers. · Combination of

A little understanding of MySQL Character Set Although this article aims to understand, but a little understanding can also, after all, Zhuge Kong Ming is only based on the character value can have the so-called character set concept, some character

The magic MySQL partition = first look at the result = There are two tables with the same structure, no_part_tab and part_tab. One uses the partition and the other does not use the partition. The result is as follows. Mysql> select * from

Quick installation of MariaDB in linux MariaDB is a MySQL branch version using the Maria storage engine. It is a free open-source database server developed by a company founded by Michael Widenius, the original MySQL author. This article introduces

Solution 1: Ignore errors. This method is applicable to situations where the data in the master and slave databases is not significantly different, or the data may be not completely unified. The solution should be implemented when the data

For tables with the same fields in mysql (used by union), cross-table statistics are required when multiple tables are maintained and used, after query, you can use the union and union all statements to implement union and union all. They combine

Mysql import csv file mysql load data infile command can import the DATA in the csv flat file to the database. In linux: Load data infile '/home/test/dump/ip_location.csv 'into TABLE ip_location character set utf8 fields terminated by', 'enabledby'

MySQL obtains the system performance and status. #! /Bin/ksh INTERVAL = 5 PREFIX = $ INTERVAL-sec-status touch/tmp/running RUNFILE =/tmp/running my-e 'show global variables '> mysql-variables while test-e $ RUNFILE; do file = $ (date + % F _ % I)

Mysql numeric data type MySQL numeric data types can be roughly divided into two categories, one is an integer, the other is a floating point or decimal. Many different subtypes are available for each of these classes. Each subtype supports data of

Mysql automatically backs up a series of problems. The test environment has finally been set up .. The server selected the MySQL-server-5.5.28 and the KEY verification information passed. It seems that the system is not installed correctly. Start

Stored Procedures for MySQL to execute search prompts with INOUT Parameters [SQL] DELIMITER $ USE 'b10k' $ DROP PROCEDURE IF EXISTS 'SP _ suggest '$ CREATE DEFINER = 'luth' @ '% 'Procedure 'SP _ suggest '( IN query_column VARCHAR (100 ), /*

MySQL update Error Code: 1093 and Error Code: 1175 solution MySQLSQLError Code: 1093. you can't specify target table 'ws _ product' for update in FROM clause, which is caused by the subquery added to the where condition when the update or delete

MySQL Chinese index plug-in mysqlcft installation and use 1. MySQL must be dynamically compiled and installed to load dynamic link libraries. 2. edit MySQL configuration file my. cnf: in the [mysqld] segment, add ft_min_word_len = 1 (meaning the

How to view mysql version 1: mysql-V at the terminal. The following code snippet: [shengting @ login ~] $ Mysql-Vmysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686) 2: in mysql: mysql> status; the following code snippet: mysql> status; ------

In MYSQL, take the first day of the current year and the current week, month, the first day of the quarter/the last day of mysql to obtain the format of the first day of the year, month, and day: SELECT DATE_SUB(CURDATE(),INTERVAL dayofyear(now())-1

The Application of mysql joint index has a log table with the following structure: CREATE TABLE `weblog` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ip` varchar(45) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE

Mysql modifies wait_timeout Mysql> show global variables like 'wait _ timeout ';  The default value is 8 hours for a mysql connection to be idle for more than 8 hours. mysql will automatically disconnect the connection. 1. modify vi/etc/my. cnf

Principle of synchronization latency of a MYSQL master1. Principle of master-slave synchronization latency in MySQL databases. To talk about the delay principle, we must start with the mysql database master-slave replication principle. mysql

The mysql efficient data import method simulates tests on the current network. A test environment needs to be set up to import hundreds of millions of data to the database. Make a simple record of the problem. Data: a database, 2000 tables, 2000

How to solve the problem of max_allowed_packet error when importing data in MySQL 5.1 when the information package is too large: 1153-Got a packet bigger than 'max _ allowed_packet 'bytes terminates data import. When the MySQL client or mysqld