Thanks a lot!
But my test is not successful. Please help me.
This is my test code:
#ifdef WIN32
#include <windows.h>
#endif
#include "mysql.h"
#include <stdio.h>
main()
{
union ull {
unsigned char a[8];
my_ulonglong id;
} ull;
for(int i=0;i<8;i++) ull.a[i]=(unsigned char)255;
char s[200];
sprintf(s,"%llu\n",ull.id);
printf("%s\n",s);
return 0;
}
On Windows its output is:
4294967295
It's still a 4bytes integer.
Regards,
Gu Lei
----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
To: "????" <leig@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, March 15, 2006 3:34 PM
Subject: Re: insert my_ulonglong data with C API
> In the last episode (Mar 15), ???? said:
>> Hello,everyone!
>>
>> My table has a bigint column which needs store 8bytes integer.
>>
>> I looked up in Mysql Menual. It seems that , if I use C API I can
>> only use preapared statement functions to insert bigint values.
>>
>> I can not use mysql_real_query or mysql_query to insert bigint values
>> because I do not know how to convert a my_ulonglong to a string or
>> character array.
>
> sprintf(buf, "insert into mytable values ( %llu )", myulonglongint);
>
> --
> Dan Nelson
> dnelson@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=leig@stripped
>
