¸ß·ÖÇóÒ»¸ö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¿Ï¶¨ÓУ¬ÄãÔÙÕÒÕÒ¿´¡£ÒýÓà datetime¿Ï¶¨ÓУ¬ÄãÔÙÕÒÕÒ¿´¡£ ÕÒÁËÒ»´óȦ»¹ÊÇûÓÐ http://code1.codepub.com/wuse22/2007/2/10/mysql51_CHM.rar {{
Ïà¹ØÎÊ´ð£º
ÓÐÒ»10*10¾ØÕ󣬳ýÈ¥µÚÒ»¸öµã£¨0£¬0£©ºÍ×îºóÒ»µã£¨9£¬9£©£¬»¹Óа˸öµãΪ1£¬ÆäËû¶¼Îª0£¬ÒªÇóÓöþάÊý×é±íʾ¡£°Ë¸öµãÊÇËæ»úÉú³ÉµÄ£¬±àдÏà¹Ø³ÌÐò±íʾ¾ØÕóËùÓпÉÄÜÇé¿ö¡£ ÕæÐÄÇó½Ì¸÷λ¸ßÊÖ£¬°¥£¡±¾ÈËÌ«²ËÁË£¡ºÇºÇ£¡
......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎͼ¿É¡£ ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù. °¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿ ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......
String sqlCount="select count(*) from usertable where username='"+ userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡ Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÓÃlistviewÏÔʾ³ö´ÓÊý¾Ý¿âÖвéѯ³öµÄ¼Ç¼£¬ÏëÔÚ×îºó¼Ç¼ºóÃæÌí¼ÓÒ»ÌõºÏ¼ÆÐУ¬ÈçºÎʵÏÖ£¡Ð»Ð»´ó¼Ò£¡ °ó¶¨Êý¾ÝÄãÓ¦¸ÃûÎÊÌâ°É£¬°ó¶¨ÍêÒÔºóÓÃÒ»¸öÑ»·°ÑÄãҪͳ¼ÆÊý¾ÝµÄÁÐÖеÄÊý¾Ý×ܺÍÓÃÒ»¸ö±äÁ¿½ÓÊÜ£¬È»ºóÔÚÑ»·ÍâÃæne ......
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 ......