How update column updateDate , value is null
Opened this issue · 0 comments
khanhnam99 commented
How update column updateDate , value is null
use mysql 8
Incorrect date value: '' for column 'updateDate ' at row 1
$data = [
'updateDate ' => null
];
$db->update('TB_DISCOUNT', $data)
echo $db->getLastQuery();
// show query
// UPDATE TB_DISCOUNT updateDate
= 'NULL'
how show query result like this:
UPDATE TB_DISCOUNT SET updateDate
= NULL