| Mapping from types used in SQL queries | |||
|---|---|---|---|
MySQL type | Trinity type | Example code | Variable operators |
| bigint(20) | int64 | int64 val = fields[n].GetInt64(); | %I64d (Capital i) |
| bigint(20) unsigned | uint64 | uint64 val = fields[n].GetUInt64(); | %I64u (Capital i) |
| int(11) | int32 | int32 val = fields[n].GetInt32(); | %u |
| int(10) unsigned | uint32 | uint32 val = fields[n].GetUInt32(); | %u |
| mediumint(8) | int32 | int32 val = fields[n].GetInt32(); | %u |
| mediumint(8) unsigned | uint32 | uint32 val = fields[n].GetUInt32(); | %u |
| smallint(6) | int16 | int16 val = fields[n].GetInt16(); | |
| smallint(5) unsigned | uint16 | uint16 val = fields[n].GetUInt16(); | |
| tinyint(4) | int8 | int16 val = fields[n].GetInt16(); | |
| tinyint(3) unsigned | uint8 | uint8 val = fields[n].GetUInt8(); | |
| float | float | float val = fields[n].GetFloat(); | |
| float unsigned | |||
| double | double | double val = fields[n].GetDouble(); | |
| double unsigned | |||
| text | string (std::string) or cstring (char const*) |
| %s |
| longtext | %s | ||
| tinytext | %s | ||
| char(k) | %s | ||
| varchar(k) | %s | ||
| blob | %s | ||
| COUNT(x) | uint64 | uint64 count = fields[n].GetUInt64(); | %UI64FMT* |
| MAX(x) | uint32 or int32 |
| %u |
| MIN(x) | %u | ||
| SUM(x) | string (std::string) or cstring (char const*) |
| %s
%s |
| UNIX_TIMESTAMP(x) | uint64 | uint64 unix_time = fields[n].GetUInt64(); |
|
...