MySQL table name and other case sensitive issues, field type timestamp, batch modification table name, Oracle query history operation record, etc.

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.