Versiones comparadas

Versión anterior 8

changes.mady.by.user E.R.

Guardado el

comparado con

Nueva versión 9

changes.mady.by.user Flo

Guardado el

Clave

  • Se ha añadido esta línea.
  • Se ha eliminado esta línea.
  • El formato se ha cambiado.
Comentarios: Corrected MySQL types as they throw a syntax error && C++ operators adjusted
Mapping from types used in SQL queries

MySQL type

Trinity typeExample codeVariable operators
bigint(20)int64int64 val = fields[n].GetInt64(); %I64d       (Capital i)
unsigned bigint(20) unsigneduint64uint64 val = fields[n].GetUInt64(); %I64u       (Capital i)
int(11)int32int32 val = fields[n].GetInt32();%u
unsigned int(10) unsigneduint32uint32 val = fields[n].GetUInt32();%u
mediumint(8)int32int32 val = fields[n].GetInt32();%u
unsigned mediumint(8) unsigneduint32uint32 val = fields[n].GetUInt32();%u
smallint(6)int16int16 val = fields[n].GetInt16(); 
unsigned smallint(5) unsigneduint16uint16 val = fields[n].GetUInt16(); 
tinyint(4)int8int16 val = fields[n].GetInt16(); 
unsigned tinyint(3) unsigneduint8uint8 val = fields[n].GetUInt8(); 
floatfloatfloat val = fields[n].GetFloat(); 
float unsigned float 
doubledoubledouble val = fields[n].GetDouble(); 
double unsigned double 
text

string (std::string)

or

cstring (char const*)

std::string text = fields[n].GetString();

char const* text = fields[n].GetCString();

%s
longtext%s
tinytext%s
char(k)%s
varchar(k)%s
blob%s
COUNT(x)uint64uint64 count = fields[n].GetUInt64();%UI64FMT*
MAX(x)uint32 or int32

uint32 minmax = fields[n].GetUInt32();

int32 minmax = fields[n].GetInt32();

%u
MIN(x)%u
SUM(x)

string (std::string)

or

cstring (char const*)

int sum;

if (const char* ch = fields[n].GetCString())

sum = atoi(ch);

%s

 

%s

UNIX_TIMESTAMP(x)uint64uint64 unix_time = fields[n].GetUInt64();

 

...