err: = db.Where ("id =?", id). First (& activity) .Error
{"id": 30, "name": null}the name field of the database is null, but the name in & activity will become "", how to keep it still null
type Activity struct {
Id int
name string
} the xorm, I use has the same problem.
this problem cannot be assigned to null,golang using the find method that comes with orm. It does not support string-type nil assignment, so there must be a default value during initialization. The workaround for
is to write the sql sentence, IFNULL (name, "none"), and then use orm to execute the query sql sentence.
sql:= "select id,IFNULL(name,"") from table"
result,err:=db.Query(sql)updates and additions. The structure body is not assigned. After the insert statement of orm is inserted into the database, it will also be the corresponding default values of 0 and "
.sql:="update table set ....."
err:=db.Exec(sql)err: = db.Where ( "id =? ", id). First (& activity) .Error {"id": 30, "name": null} the name field of the database is null, but the name in & activity will become " ", how to keep it still null type Activity struct { Id ...