mysql日期between '' 报错:1525 - Incorrect DATE value: ''
- mysql报错:
日期 between ''的时候报错1525 - Incorrect DATE value: '' - 处理方法:
日期 between NULLIF('','') NULLIF(p1,p2)
如果p1 = p2,值为NULL,否则,值为p1
日期 between ''的时候报错1525 - Incorrect DATE value: ''日期 between NULLIF('','')NULLIF(p1,p2)p1 = p2,值为NULL,否则,值为p1SELECT *
FROM information_schema.ROUTINES
WHERE ROUTINE_SCHEMA = DATABASE(); $("#c-category_id").data("params", function (obj) {
return {custom: {course_id: $("#c-course_id").val()}};
});