mysql sum return err

[lvphpwb]

SELECT sum(total) FROM user WHERE xxxxxx=xxx

sql: Scan error on column index 0, name "sum(total)": converting NULL to uint64 is unsupported

[lvphpwb]

When there is no matching data in the table

[kesonan]

use sql.NullInt64 instead

[lvphpwb]

thanks