Simple learning mysql log management

This article mainly introduces mysql log management, the content of the article is carefully selected and edited by the author, has a certain pertinence, and is of great significance to everyone's reference, so let's learn about mysql log management with the author.

Create a table create table test_student (id int auto_increment, firstName varchar (10) not null, lastName varchar (10) nont null, addtime date, primary key (id)) engine=innodb character set=utf8 insert statements insert into test_student set firstName= "zhang", lastName= "san", addtime='2001-02-02 insert into test_student set firstName= "zhang", lastName= "tian", addtime='2001-03-02' Insert into test_student set firstName= "li", lastName= "tian", addtime='2003-03-02; find students whose addtime is equal to March select * from test_student where month (addtime) ='03; find students whose addtime is equal to 2001 select * from test_student where year (addtime) = '2001 scrambling / date function / / return date what day date is (1 = Sunday, 2 = Monday,. 7 = Saturday, ODBC standard) select dayofweek ('2017-04-22') returns 7

After reading the above about mysql log management, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.