MySQL

Knowledge keywords: DATE_FORMAT select DATE_FORMAT (create_time, '% Y % U') weeks, count (caseid) count from tc_case group by weeks; select DATE_FORMAT (create_time, '% Y % m % D') days, count (caseid) count from tc_case group by days; select

Create database bbs2007; USE bbs2007; create table article (id int primary key AUTO_INCREMENT, pid INT, rootid INT, title VARCHAR (255), cont TEXT, pdate DATETIME, isleaf INT #1-not leaf 0-leaf); INSERT data to the table at www.2cto.com: insert into

Mysql triggers are in the format of create trigger trigger_name after/before insert/update/delete on one_table for each row your_ SQL. The red part is named by yourself, and the blue part is a value. The black part is required, the final green part

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 $

MySQL database synchronization. MySQL is an open-source relational database system. Master-slave Replication is a process that replicates data from a MySQL database server (master server) to another server (slave server. Configure the master server)1

The implementation of its own table foreign key trigger currently encounters such a foreign key definition: 't_ gir '. 'tb1 'straint' fk _ 1 'foreign key ('R _ id') REFERENCES 'tb1' ('id ') on delete cascade aims to restrict another field of the

Fedora 16 mysql (rpm) Installation user manual lychee install Mysql 1. Download MySQL Installation File install MySQL requires the following two files: MySQL-client-5.1.55-1.glibc23.i386.rpmMySQL-server-5.1.55-1.glibc23.i386.rpm: http://mirrors.sohu.

Today, the same data can be found in case-insensitive input conditions when querying data. For example, if you enter aaa, aaA, or AAA to query the same results, the query conditions are case-insensitive. Because the program uses the hibernate

An infinite classification table. The primary table field FID and parent class ID field FPID are simple columns. Retrieve the dataset's SQL statement with a as (select FID from table where FID = 'value' union allselect x. FID from Table x, a where x.

MYSQL is slow, and Web programs that record database statements are slow. The first object to be detected is the database, which has been known for a few years. What should I do if I want to track SQL statements that drag down the server performance

Debian apt mysql password-less installation in debian install mysql database only need apt-get install mysql-server-5.x, and then a dialog box will pop up during the installation process, ask you to enter the password of the mysql root Account. If

Precautions for using MySQL-Proxy read/write splitting before you start to install MySQL-Proxy and configure the MySQL Master/Slave server. Supplement: the new version of MySQL has built-in support for www.2cto.com. One of the issues that cannot be

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 stored procedure and function writing stored PROCEDURE 01 drop procedure if exists temp; 02 delimiter // 03 create procedure temp () 04BEGIN05 declare V_RETUR int; 06 www.2cto.com begin07 if exists (SELECT 1 FROM dual where 1 = 1) then08 IF 1 =

We know the optimization example based on MySQL horizontal partition that MYSQL5.1 began to support the horizontal partition function. Let's try to optimize the query on a partitioned table. In general, the optimization principle is the same as the

Basic MySQL table operations/*********************************/create table USER www.2cto.com (ID int unsigned, USERNAME varchar (10) not null, PASSWORD varchar (32) not null, GENDER tinyint, BIRTHDAY date, www.2cto.com IMAGEURL varchar (30),

Mysql binlog log optimization and ideas are completed after the database is installed. For binlog parameter settings, some parameter adjustments are made to meet business needs or maximize performance. Mysql logs mainly affect I/O performance. This

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 permission system analysis create user 'lib' @ 'localhost' identified by 'lib' www.2cto.com create table g_user (id varchar (10), username varchar (20 ), userpwd varchar (20); insert into g_user values ('1', 'lib', 'lib'); insert into g_user

Configuration of MySQL installation and remote connection configuration in Ubuntu 1. install MySQL in ubuntu and enter sudo apt-get install mysql-server in the ubuntu command line to install the mysql service, by default, mysql-client is