qiuchuan1的博客

select date_format('2013-03-09','%y-%c-%d');select STR_TO_DATE('2013-03-09','%Y-%c-%d'); %W 星期名字(Sunday……Saturday) %D 有英语前缀的月份的日期(1st, 2nd, 3rd, 等等。） %Y 年, 数字, 4 位 %y 年, 数字, 2 位 %a 缩写的星期

导入数据文件60m，查看日志发现可能是数据太大导致1.命令行下操作：mysql -uroot -p;use mysql;show variables like '%max_allowed_packet%';set global max_allowed_packet = 2*1024*1024*100;2.重启mysql，重新打开命令行，重新查询值才有变化。...

[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kzry.m_merchant_bank.mb_bank_name' which is not functionally dependent on columns in GROUP BY cla...