List:General Discussion« Previous MessageNext Message »
From:古雷 Date:March 15 2006 8:12am
Subject:Re: insert my_ulonglong data with C API
View as plain text  
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
>
Thread
insert my_ulonglong data with C API古雷15 Mar
  • Re: insert my_ulonglong data with C APIDan Nelson15 Mar
  • Re: insert my_ulonglong data with C API古雷15 Mar
    • Re: insert my_ulonglong data with C APIPooly15 Mar
    • Re: insert my_ulonglong data with C APIDan Nelson15 Mar
  • Re: insert my_ulonglong data with C API古雷16 Mar