1 回答

TA貢獻(xiàn)1841條經(jīng)驗(yàn) 獲得超3個(gè)贊
為什么不把值掃描成這樣的結(jié)構(gòu):
type Log struct {
ID int64
Name string
}
db, _ := sql.Open("mysql", "root:passwd@tcp(127.0.0.1:3306)/log")
rows, err := db.Query("SELECT * FROM logs ORDER BY log_id DESC LIMIT ?,? ", 1, 3)
if err != nil {
fmt.Println(err)
}
defer rows.Close()
var values []Log
fmt.Println("Reading data:")
for rows.Next() {
var log Log
err = rows.Scan(&log.ID, &log.Name)
if err != nil {
fmt.Println(err)
continue // you need to handle error
}
values = append(values, log)
}
fmt.Println(values)
- 1 回答
- 0 關(guān)注
- 88 瀏覽
添加回答
舉報(bào)