存储过程 Data truncation: Incorrect date value: ‘1988‘ for column ‘date‘ at row 1

最新推荐文章于 2024-04-01 20:35:20 发布

纯洁的麦田

最新推荐文章于 2024-04-01 20:35:20 发布

阅读量1.6k

点赞数 1

分类专栏： mysql 报错文章标签： mysql

本文链接：https://blog.csdn.net/qq_33668999/article/details/108394191

版权

报错同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

mysql

4 篇文章 0 订阅

订阅专栏

最近写存储过程报错

网上搜都是说mysql sql脚本格式不对

我这里是存储过程，我在想时间也是对的啊，时间格式，为啥

原来的

 SET updateSQL = CONCAT("INSERT INTO data_bi.bi_user_catch_partake_day_static(date, room_id, vip, user_type, fish_id, factor_type, acc_num, first_acc_num)
            SELECT date, room_id, vip, user_type, fish_id, factor_type, count(account_id), count(if(is_new_acc = 1,account_id,null))
            FROM data_bi.bi_user_catch_partake_day_active WHERE date = ", theTime, "
            GROUP BY ", groupBySbStr, "
            ON DUPLICATE KEY UPDATE acc_num = VALUES(acc_num),first_acc_num = VALUES(first_acc_num)");
            call data_tslog.execute_sql(updateSQL);

大家有没有发现

其实少了引号，这里解析为2020-08-11，引号没有解析

SET updateSQL = CONCAT("INSERT INTO data_bi.bi_user_catch_partake_day_static(date, room_id, vip, user_type, fish_id, factor_type, acc_num, first_acc_num)
            SELECT date, room_id, vip, user_type, fish_id, factor_type, count(account_id), count(if(is_new_acc = 1,account_id,null))
            FROM data_bi.bi_user_catch_partake_day_active WHERE date = '", theTime, "'
            GROUP BY ", groupBySbStr, "
            ON DUPLICATE KEY UPDATE acc_num = VALUES(acc_num),first_acc_num = VALUES(first_acc_num)");
            call data_tslog.execute_sql(updateSQL);

希望能帮到你，我的博客：idearyou.cn