? ????? go-sql-driver/mysql ????? ???? Golang ????? MySQL ??????? ???? ?????. ?? ??? ???? ??, ?????? ?? ? ?? ?????? ??? ?? ????.

?? ?? : MySQL? ???? ?????????. ????? mysql --version ?????? ??????. ??? MySQL ??? ???????.

Go MySQL ???? ?? :

??? ???? ??? ????? ??????.

go get -u github.com/go-sql-driver/mysql

?? ???? ????? ??? ?? ?? ? ?? ? ?????. ??? ??? Github ???? ??????.

???? ?? :

Golang ???? ????? ????. GO ?? ?????? ???? ???? ??? ???? GO ??? ???????.

go mod init test-sql go mod tidy

?? ?? ??? ??? ???? go.mod ? go.sum ??? ?????.

MySQL? ?? :

main.go ??? ??? ?? ??? ??????.

 ??? ??

?? (??)
    "??????/SQL"
    "FMT"
    _ "github.com/go-sql-driver/mysql"
))

func main () {
    db, err : = sql.open ( "mysql", "root :<your_mysql_password> @TCP (127.0.0.1:3306)/??? ")
    err! = nil {? ??
        panic (err.error ())
    }
    ?? DB.Close ()
    fmt.println ( "MySQL? ????? ???????!")
}</your_mysql_password>

???????<your_mysql_password></your_mysql_password> ?? MySQL ?????? ????. Secure Storage?? ???? ???? ???? ?? ????.

?? ??? (Coderunner? ??)? ?? ??? ??? ???? ??????. ?? ? ???? ???? ????? ???? ??????.

go run main.go

"MySQL? ????? ???????!" ???? ???? ??? ?????.

MySQL ?????? ??? :

? ????? ?? TablePlus? ?? ?????? ?? ??? ???? ?????? (? : "123begin") ? ??? (? : "TestTable2")? ????. ?? ??? ?? ?????? ? ??? ??? ??????.

?????? ?? :

??? ?? :

? ??? ???? ???? ?????.

 ??? ??

?? (??)
    "??????/SQL"
    "FMT"
    _ "github.com/go-sql-driver/mysql"
))

func main () {
    db, err : = sql.open ( "mysql", "root :<your_mysql_password> @TCP (127.0.0.1:3306)/123begin ")
    err! = nil {? ??
        panic (err.error ())
    }
    ?? DB.Close ()
    ??, err : = db.query ( "testTable2 ? ('23 ')? ??
    err! = nil {? ??
        panic (err.error ())
    }
    insert.close () ??
    fmt.println ( "????? ?? ? ???!")
}</your_mysql_password>

?? go run main.go ??? ??????.

??? ?? :

? ??? ????? ???? ?????.

 ??? ??

?? (??)
    "??????/SQL"
    "FMT"
    _ "github.com/go-sql-driver/mysql"
))

?? testtable2 struct {
    id int`json : "id"`
}

func main () {
    db, err : = sql.open ( "mysql", "root :<your_mysql_password> @TCP (127.0.0.1:3306)/123begin ")
    err! = nil {? ??
        panic (err.error ())
    }
    ?? DB.Close ()
    results, err : = db Query ( "testtable2?? id ??")
    err! = nil {? ??
        panic (err.error ())
    }
    Defer results.close ()
    results.next () {
        var testtable2 testtable2
        err = results.scan (& testtable2.id)
        err! = nil {? ??
            panic (err.error ())
        }
        fmt.println (testtable2.id)
    }
}</your_mysql_password>

??? ????? go run main.go . ??? ?? ? ???? ???????.

?? ?? :

• ??? ???? : ??? ???? ?????? go run main.go ??? ??????. cd ???? ??????.
• go.mod / go.sum : ? ??? ?? ? ?? go mod init ?? ???? go mod tidy .
• MySQL ?? : ?? ??? ?? MySQL? ?? ??? ??????.

? ??? ????? Golang? MySQL? ?????? ? ???? ???? ??? ???? ?????. ?? ?? ? ?? ?? ?? ?? ? ?????? ??? ??? ?? ?? ????. Coderunner, Tablus, SnippetsLab ? Secret? ?? ??? ???? ?? ??? ??? ? ? ????.

? ??? MySQL? ?? Golang? ???? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!