使用golang检查数据库表是否存在

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

db, err := sql.Open("mysql", "username:password@tcp(hostname:port)/database")
if err != nil {
    // 处理连接错误
}
defer db.Close()

tableName := "your_table_name"
query := "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?"
var count int
err = db.QueryRow(query, "your_database_name", tableName).Scan(&count)
if err != nil {
    // 处理查询错误
}
if count > 0 {
    // 表存在
} else {
    // 表不存在
}