¸ß·ÖÇóÒ»¸öMYSQL C API - VC/MFC / Êý¾Ý¿â
mysql¸ø³öÁËÐí¶àAPI ÇëÎÊÄĸö¿ÉÒÔ»ñÈ¡µ½·þÎñÆ÷µÄʱ¼ä
ÎÒÀûÓÃSELECT LEFT(now(),13)
ÃüÁîÒ²¿ÉÒÔÔÚMYSQLÖдòӡʱ¼ä£¬¿É¾ÍÊDz»ÖªµÀÈçºÎ½«Õâ¸öʱ¼ä·µ»Ø»ØÀ´
C/C++ code:
mysql_init(&conn);
//Á¬½Óµ½Ö¸¶¨µÄÊý¾Ý¿â
mysql_real_connect(&conn,IPAddress,Root,Pass,NULL,3306,NULL,0);
mysql_query(&conn,"SELECT LEFT(now(),13");
°´ËµÖ´ÐÐÍêÉÏÃæµÄÓï¾äÒÔºóʱ¼äÓ¦¸ÃÔÚconnµ±ÖÐ
¿É¼òµ¥µÄ·ÁËÒ»ÏÂMYSQL½á¹¹£¬µ±Öв¢Ã»Óб£´æÊ±¼äµÄ×ֶΡ£
Çë½Ì¸ßÊÖ
datetime¿Ï¶¨ÓУ¬ÄãÔÙÕÒÕÒ¿´¡£
ÕÒÁËÒ»´óȦ»¹ÊÇûÓÐ
http://code1.codepub.com/wuse22/2007/2/10/mysql51_CHM.rar
{{
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
ÇëÎÊVFPÖÐÈçºÎµ÷ÓÃC/C++º¯Êý£¿
ÄãÒªµ÷ÓÃʲô¹¦Äܵĺ¯Êý£¿Òª¿´¿´VFPÖÐÓÐûÓжÔÓ¦µÄº¯Êý£¬Èç¹ûÓоÍÊ¡×ÅÔÙµ÷ÓÃÁË¡£Èç¹ûûÓУ¬¿ÉÒÔ½«C/C++º¯Êýд¸öDLL»òFLL£¬È»ºóÔÚVFPµ÷Óü´¿É¡£
Ê®¶¹Èý ÀÏʦ£¬Ôõô²ÅÄÜÐÞ¸Ä×Ô¼ºµÄ ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......
[align=center][/align]CÓïÑÔÖÐÈçºÎÅжÏÒ»¸ödoubleÐ͵ÄÊý×飨Èçdouble S[20]£»£©ÊÇÒ»¸ö¿ÕÊý×飬¼´Êý×éÖÐûÓзÅÈκÎÖµ¡£
û°ì·¨¡£
"ÈκÎÖµ" µÄ¶¨Òå?
¾ÍÊÇÊý×éÊǿյģ¬Ã»ÓÐΪËü¸³Öµ
¿ÉÒÔ¿¼Â ......