gomysqlclient

README

go-mysql-client

pure Go mysql client

Feature

• Single binary
• Complete table name
• Complete MySQL reserved words

Demo

Install

go get -u github.com/johejo/go-mysql-client/cmd/gomysql

Usage

execute SQL

gomysql -h [HOST] -P [PORT] -u [USER] -p [PASSWORD] [DATABASE] "[SQL]" 

prompt

gomysql -h [HOST] -P [PORT] -u [USER] -p [PASSWORD] [DATABASE] 

reading file

gomysql -h [HOST] -P [PORT] -u [USER] -p [PASSWORD] -f [SQL_FILE] [DATABASE] 

Documentation

Index

• func QueriesFromReader(r io.Reader) []string
• type Cli
  • func NewCli(c *Config) (*Cli, error)
  • func (c *Cli) Run(execute ...string) error
  • func (c *Cli) RunPrompt() error
• type Config
  • func (c *Config) String() string
• type Results
  • func (r *Results) String() string

Functions

func QueriesFromReader

func QueriesFromReader(r io.Reader) []string

Types

type Cli

type Cli struct {
	// contains filtered or unexported fields
}

func NewCli

func NewCli(c *Config) (*Cli, error)

func (*Cli) Run

func (c *Cli) Run(execute ...string) error

func (*Cli) RunPrompt

func (c *Cli) RunPrompt() error

type Config

type Config struct {
	Host     string
	Port     uint
	User     string
	Password string
	Database string
}

func (*Config) String

func (c *Config) String() string

type Results

type Results struct {
	Columns []string
	Rows    [][]string
}

func (*Results) String

func (r *Results) String() string