mysql修改null值的示例:
假设一个user表中second字段存在null值,我们可以通过以下语句将null值修改成0:
SELECT IFNULL(second,'1') as second FROM user;