¸ß·ÖÇóÒ»¸ö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
{{
Ïà¹ØÎÊ´ð£º
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
´ó¼ÒºÃ£º
ÎÒÏëʵÏÖ¼ì²âµ½²åÈëSD¿¨ºó×Ô¶¯½«SD¿¨¸ñʽ»¯µÄ¹¦ÄÜ£¬²»ÖªC/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý£¿
ÁíÍ⣬ÎÒ²»ÏëʹÓÃSHFormatDrive£¬ÒòΪÕâ¸öº¯Êý»áµ¯³öÊÇ·ñÒª¸ñʽ»¯µÄÌáʾ¿ò£¬ÎÒÐèÒªµÄÊÇϵͳ×Ô¶¯¸ñʽ»¯£¬¶ø²Ù×÷Õß² ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb
貼³öSQL ......
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 ......