GO vs MySQL类型对应关系
| golang | MySQL |
|---|---|
| int,int32 添加auto或名称为Id时 | integer AUTO_INCREMENT |
| int64 | bigint AUTO_INCREMENT |
| uint,uint32 | integer unsigned AUTO_INCREMENT |
| uint64 | bigint unsigned AUTO_INCREMENT |
| bool | bool |
| string size 255 | varchar(255) |
| string type(text) | longtext |
| time.Time type(data) | date |
| time.Time | datetime |
| byte | tinyint unsigned |
| rune | integer |
| int | integer |
| int8 | tinyint |
| int16 | smallint |
| int32 | integer |
| int64 | bigint |
| uint | integer unsigned |
| uint8 | tinyint unsigned |
| uint16 | smallint unsigned |
| uint32 | integer unsigned |
| uint64 | bigint unsigned |
| float32 | double precision |
| float64 | double precision |
| float64 digits,decimals | numeric(digits,decimals) |