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" <[EMAIL PROTECTED]> To: "????" <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> 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 > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >