1. 错误描述1 queries executed, 0 success, 1 errors, 0 warnings查询:SELECT t.`name`, DATE_FORMAT(str_to_date(‘2015’), ‘%Y’) as statisDate, ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS …错误代码: 1582Incorrect parameter count in the call to native function ‘str_to_date’执行耗时 : 0 sec传送时间 : 0 sec总耗时: 0 sec2. 错误原因SELECT t.`name`, DATE_FORMAT(STR_TO_DATE(‘2015’), ‘%Y’) AS statisDate, ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS amountFROM t_stu_info t DATE_FORMAT(t.statisDate, t.`name`, DATE_FORMAT(STR_TO_DATE(‘2014’), ‘%Y’) AS statisDate, ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS amountFROM t_stu_info t DATE_FORMAT(t.statisDate, ‘%Y’) = ‘2014’
MySQL内置函数str_to_date的格式是:str_to_date(字符串,日期格式); 在这个查询SQL中却是str_to_date(字符串),,导致报错
3. 解决办法
修改查询SQL语句
SELECT t.`name`, DATE_FORMAT(STR_TO_DATE(‘2015′,’%Y’), ‘%Y’) AS statisDate, ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS amountFROM t_stu_info t DATE_FORMAT(t.statisDate, t.`name`, DATE_FORMAT(STR_TO_DATE(‘2014′,’%Y’), ‘%Y’) AS statisDate, ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS amountFROM t_stu_info t DATE_FORMAT(t.statisDate, ‘%Y’) = ‘2014’
却不去主动改变,而是放任它的生活态度。