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

Mysql Table is readonly solution today, copy the Table of the next mysql Data to another folder. When the result is accessed, the error "Table is readonly" is returned. My host is centos5, Because I encountered many permission problems before. When

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

Mysql cannot be connected from the client to the server. The company uses Mysql for a test and starts to build a local Mysql database and connect it to it. No connection failure has been encountered.When the database is on the server, the connection

View the execution plan of mysql. The SQL statement is executed for 4 minutes, And the message_message contains 1000 million data. The execution plan of mysql is learned.Select * from message_message where id in (select message_idFrom

Mysql uses variables to batch modify data BEGIN declare I int; # query the table's number of columns declare column_name_temp varchar (100); # query the table's column name DECLARE column_un_change varchar (100 ); DECLARE table_temp_name varchar (100

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

In MySQL, records of pure values can be enclosed by no single quotation marks in the program. If only a number is included in a string type record, no single quotation marks can be added. The records after the as statement are the same as those

When I was doing A report yesterday, I encountered the requirement to horizontally display data of type A and data of type B in A table. There is no relationship between the two, and the amount of data is too large to be determined, after a while,

MySQL storage engine note storage engine overview plug-in storage engine is one of the important features of MySQL database, users can choose how to store and index data, whether to use things, and other features such as www.2cto.com based on

CREATE persons: create table 'persons '('Id _ P' int (11) not null AUTO_INCREMENT, 'lastname' varchar (10) default null, 'firstname' varchar (10) default null, 'address' varchar (50) default null, 'city' varchar (10) default null, primary key ('Id _

MySQL Slave data re-replication: an alert message indicating a synchronization error occurred on a server Load balancer instance. The SQL THREAD of the Server Load balancer instance is stopped and the status is as follows: 01 mysql> show slave

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 =

The Alter database processing logic of MySQL database is not as terrible as Alter table, and the processing logic is clear. First, check whether the database name is effectively called check_db_name () (table. cc: 2876) to check whether the database

How does mysql check which tables have a large amount of data? If there are dozens or hundreds of tables in the database, which tables have a large amount of data, you cannot query one table or one table, mysql also has a data dictionary table

An error occurred when unbinding the MySQL database to the local machine in Ubuntu: In Ubuntu, a MySQL account is added, full database operation permissions are granted, and the database is allowed to access external links.However, you still cannot

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

MySQL common skills Regular Expression -- whether to start with a select 'abcdefg' REGEXP '^ a' -- whether to end with fg www.2cto.com select 'abcdefg' REGEXP 'fg $' -- wow, select STAFF_Name, STAFF_NAME REGEXP '^ test' from g_staffselect STAFF_Name

For programmers who have just come into contact with mysql, they may have doubts about these two symbols, because some codes use the other one.Of course they are different. Their difference is also relatively simple: ": =" is a true value assignment

Mysql logical architecture view main storage engine: www.2cto.com engine Mysql version transaction lock granularity reference not to mention InnoDB all support Mvcc row-Level Lock transaction processing MyISAM all support concurrent insert table