CODEWITHSUNDEEP
mysqlgo
Aravindan P
Aravindan P

Reputation: 1

Printing table name from MYSQL using Golang

package main

import (
        "fmt"
        "database/sql"
        _ "github.com/go-sql-driver/mysql"

)

type Tag struct {
        Table_name string `json:"table_name"`
}

func main() {
        db, err := sql.Open("mysql", "root:roadrunner@tcp(172.31.16.82:10002)/quote_data")
        if err != nil {
                //panic.(err.Error())
                fmt.Println("Connected Fail")
        }
        fmt.Println("Connected")
        defer db.Close()
        result, err1 := db.Query("SELECT table_name FROM information_schema.tables WHERE table_type = 'base table' AND table_schema='quote_data'")
        if err1 != nil {
                panic(err1.Error())
        }
        fmt.Println("Showing Tables",result)
        for results.Next() {
                var tag Tag
                err1 = results.Scan(&tag.Table_name)
                if err1 != nil {
                        panic(err.Error())
                }
                log.Printf(tag.Table_name)
        }
}

Upvotes: 0

Views: 735

Answers (1)

Puji Setiawan
Puji Setiawan

Reputation: 571

you must add type db with table_name to initialize database table

type Tag struct {
        Table_name string `db:"table_name" json:"table_name"`
}

Upvotes: 2

Related Questions