MySQL table name and other case sensitive issues: http://blog.csdn.net/postnull/article/details/72455768;
1 MySQL under Linux database name, table name, column name, alias casing rules are like this: 2 1 , database name and table name are strictly case-sensitive; 3 2 , the alias of the table is strictly case-sensitive; 4 3 , the name of the column and the alias of the column are ignored in all cases; 5 4, the field content is case insensitive by default.
=========================================================================================================
MySQL in timestamp related, date time Related:
MySQL in timestamp format field set current DateTime: http://www.cnblogs.com/lhj588/p/4245719.html;
MySQL Date and time type: http://www.cnblogs.com/panxuejun/p/6222138.html;
MySQL also sets multiple field types to timestamp: (1) http://www.cnblogs.com/xbdeng/p/5679026.html;
(2) http://blog.csdn.net/javastart/article/details/52048430;
1 ALTER TABLE' Test_time '2MODIFYCOLUMN' Time1 'timestamp not NULL DEFAULT Current_timestamp ,3MODIFYCOLUMN' Time2 'timestamp not NULL DEFAULT 0After ' time1 ',4MODIFYCOLUMN' Time3 'timestamp not NULL DEFAULT 0After ' time2 ';5 6 Insert intoTest_time (Id,time2,time3)Values(6,NULL,NULL);7 8 Insert intoTest_time (ID)Values(6); --In this case, the other two time periods set to 0 are assigned the default value of 0000-xx-xx xx:xx:xx
==============================================================================================================
MySQL bulk modifies table name sql:http://www.cnblogs.com/baby123/p/5958579.html.
MySQL string intercept function substring use: http://www.jb51.net/article/27458.htm.
=========================================================================================================
Querying Oracle's historical operations record: http://www.cnblogs.com/love540376/p/6339639.html.
1 Select from where like ' 2010-05-30 ' Order by desc;
Case sensitive issues such as MySQL table name, field type timestamp, bulk modification table name, Oracle query history operation record, etc.