PHP MYSQL日常遇到的问题

1. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined.

错误代码：HY093,要么是字段名不匹配，要么是值类型或大小不匹配。

2. 记录mysql group by timestamp字段年月日的方式：DATE_FORMAT(created_at, "%Y-%m-%d" )

SELECT DATE_FORMAT(created_at, "%Y-%m-%d" ) as time, sum(order_actual_payment) as amount FROM `表名` WHERE `字段名` = '***' AND DATE_FORMAT(created_at, "%Y-%m-%d" ) BETWEEN '2018-08-13' AND '2018-08-16'  GROUP BY DATE_FORMAT(created_at, "%Y-%m-%d" );

结果：
time            amount
2018-08-13	3854
2018-08-14	3219800
2018-08-15	4937718
2018-08-16	11742186

3. SQLSTATE[01000]: Warning: 1265 Data truncated for column 'activity_expiry_time' at row 1

问题原因:插入数据库字段长度有误.