golang scan rows to []string，golang使用mysql，将结果写入到string列表中

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

rows, err := db.Query(sqlStr)

if err != nil {

    return

}

for rows.Next() {

    result := make([]string, len(readerResult.Columns))

    pointers := make([]interface{}, len(result))

    for i := range pointers {

        pointers[i] = &result[i]

    }

    err := rows.Scan(pointers...)

    if err != nil {

        logrus.Fatalf("scan have an err: %v, sql string: %s", err, sqlStr)

    }

}