Gorm update query doubt?

The

gorm document has an update example: http://gorm.io/zh_CN/docs/upd.

db.First(&user)

user.Name = "jinzhu 2"
user.Age = 100
db.Save(&user)

//// UPDATE users SET name="jinzhu 2", age=100, birthday="2016-01-01", updated_at = "2013-11-17 21:34:10" WHERE id=111;

question:
the last line of comment, where did id=111 come from? The user above has an id field by default. Will the gorm framework automatically place this id field in the id of the sql query statement? What if it is not id, but uuid, can only be queried manually with where?

Gorm golang

Mar.04,2022

db.First is the first record obtained, which is equivalent to the sql statement limit 1
when the user variable is bound. In fact, the value of user.id already exists in the user object, and the value is 111
. So if the user object is directly save at this time, it is equivalent to update the record id=111.

Yes, the model of ORM will automatically generate id, if uuid needs to be processed manually

if you use gorm.Model, it will be filled automatically, if it is uuid

type User    struct {

    UUID string `gorm:"primary_key"`

}

will also help you automatically specify it as

of uuid.

Previous: The data returned by response is incomplete.

Next: After importing the data, why is the exported data still gray and cannot be clicked?

Gorm uses update to update database (postgresql) Boolean values
problem description: the problem we encountered this morning has been going on all morning, but we still haven t found out what the problem is. Come to ask purpose: use gorm to modify the Boolean value of a field in the database table Code f...

Gorm golang

Mar.25,2021
After go gorm select, the result set or all struct are returned, except that the other fields are empty.
after go gorm select, the result set or all struct are returned, except that the other fields are empty the environmental background of the problems and what methods you have tried related codes db.Debug (). Where (s). Select ([] string { "id ", ...

Select gorm golang

Mar.31,2021
Gorm and or hybrid query
problem description just used gorm for query but encountered some problems. I want to do some mixed query of and and or, but db.Where in gorm is an and query, but if you add .Or () to query, all the conditions will become or. Ask for help from the bos...

Gorm golang

Apr.02,2021
Using gin+gorm, to define the model with gorm, how to generate data tables?
using gin+gorm, to define the model with gorm, how to generate a data table? The gorm document only states that the definition model http: gorm.io zh_CN docs mod. generates a datasheet. Do you want to use other tools? ...

Gorm golang

Oct.17,2021
Golang+gorm pagination, returning 50 pieces of data per page, is this correct?
the frontend is pulled down and refreshed, and the backend returns 50 pieces of data at a time. I wonder if the api, written by go+gorm is correct? Please have a look at gorm: http: gorm.io zh_CN docs que.. func ListArticle(offset int) ([]*ArticleMod...

Gorm golang

Oct.29,2021
Gorm Association query
SQL I want to implement select * from movies left join server on movies.server_id = server.id here is my go code. I don t know what the problem is. The data of the queried server field is not correct . type Server struct { Id int64 `gor...

Gorm golang

Dec.30,2021
Golang's gorm library, what is the default size of string?
what is the default size of the gorm library for golang? what is the default size of string? Is it 255? http: gorm.io zh_CN docs mod. type:varchar(100)type:varchar(255) ...

Gorm golang

Jan.11,2022
Gorm sets foreign key constraints
two tables, one is category, and the other is product, defined as follows: type Product struct { ProductId uint32 `gorm:"primary_key;type:int(11) unsigned auto_increment;"` Category Category `gorm:"ForeignKey:CateIDRef;"` ...

Foreign-key gorm golang

Jan.29,2022
Query with gorm, how to keep the fields in the database with the value of null in struct or null? Struct will become an empty string or 0 by default.
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 ...

Mysql gorm golang

Mar.08,2022
Query with gorm, how to keep the fields in the database with the value of null in struct or null? Struct will become an empty string or 0 by default.
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 ...

Mysql gorm golang

Mar.08,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b372b3-2c066.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b372b3-2c066.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?