datatype

Documentation

Index

• Constants
• Variables

Constants

const (
	// 数值类型
	Bit       = "BIT"
	Tinyint   = "TINYINT"
	Smallint  = "SMALLINT"
	Mediumint = "MEDIUMINT"
	Int       = "INT"
	Integer   = "INTEGER"
	Bigint    = "BIGINT"
	Real      = "REAL"
	Float     = "FLOAT"
	Double    = "DOUBLE"
	Decimal   = "DECIMAL"
	Numeric   = "NUMERIC"

	// 字符类型
	Char       = "CHAR"
	Varchar    = "VARCHAR"
	Tinytext   = "TINYTEXT"
	Text       = "TEXT"
	Mediumtext = "MEDIUMTEXT"
	Longtext   = "LONGTEXT"

	// 时间类型
	Date       = "DATE"
	Datetime   = "DATETIME"
	Time       = "TIME"
	Timestamp  = "TIMESTAMP"
	Timestampz = "TIMESTAMPZ"

	// 字节类型
	Binary     = "BINARY"
	Varbinary  = "VARBINARY"
	Tinyblob   = "TINYBLOB"
	Blob       = "BLOB"
	Mediumblob = "MEDIUMBLOB"
	Longblob   = "LONGBLOB"
	Bytea      = "BYTEA"

	// 其他类型
	Set       = "SET"
	Enum      = "ENUM"
	Json      = "JSON"
	Bool      = "BOOL"
	Serial    = "SERIAL"
	Bigserial = "BIGSERIAL"
)

Variables

var MysqlMap = map[string]string{
	Bit:       _MysqlBit,
	Tinyint:   _MysqlTinyint,
	Smallint:  _MysqlSmallint,
	Mediumint: _MysqlMediumint,
	Int:       _MysqlInt,
	Integer:   _MysqlInteger,
	Bigint:    _MysqlBigint,
	Real:      _MysqlReal,
	Float:     _MysqlFloat,
	Double:    _MysqlDouble,
	Decimal:   _MysqlDecimal,
	Numeric:   _MysqlNumeric,

	Char:       _MysqlChar,
	Varchar:    _MysqlVarchar,
	Tinytext:   _MysqlTinytext,
	Text:       _MysqlText,
	Mediumtext: _MysqlMediumtext,
	Longtext:   _MysqlLongtext,

	Date:       _MysqlDate,
	Datetime:   _MysqlDatetime,
	Time:       _MysqlTime,
	Timestamp:  _MysqlTimestamp,
	Timestampz: _MysqlText,

	Binary:     _MysqlBinary,
	Varbinary:  _MysqlVarbinary,
	Tinyblob:   _MysqlTinyblob,
	Blob:       _MysqlBlob,
	Mediumblob: _MysqlMediumblob,
	Longblob:   _MysqlLongblob,
	Bytea:      _MysqlBlob,

	Set:       _MysqlSet,
	Enum:      _MysqlEnum,
	Json:      _MysqlJson,
	Bool:      _MysqlBool,
	Serial:    _MysqlInt,
	Bigserial: _MysqlBigint,
}