mysql修改null值的示例:
假設一個user表中second字段存在null值,我們可以通過以下語句將null值修改成0:
SELECT IFNULL(second,'1') as second FROM user;