windows2003 ·þÎñÆ÷°²×°mysql,ÔÚ°²×°µÄ¹ý³ÌÖУ¬Ñ¡Ôñcustom°²×°£¬È»ºóÑ¡Ôñ·¾¶£¬Ï¸öÒ³ÃæÖ±½Ó¾Í½øÈëÁËFinishÒ³Ãæ£¬µã»÷Finishºó£¬¾ÍÖ±½Ó¹Ø±ÕÁË¡£
È»ºóÔÙ²éÕÒËùÑ¡ÔñµÄ·¾¶£¬·¢ÏÖ²¢Ã»Óа²×°¡£²»ÖªµÀ¸÷λÓöµ½¹ýÕâÖÖÎÊÌâû£¿
ÄãµÄmysqlÊÇʲô°æ±¾£¿
Ò»°ãÀ´Ëµ£¬Ñ¡Ôñ·¾¶ºó£¬ ÏÂÒ»¸öÒ³Ãæ¾ÍÊÇ"install"ÁË£ ......
[b]ÏÈ˵ÉùÎÒÊÇÐÂÊÖ£¬ ÎÒµÄmysqlÊý¾Ý¿âÒѾÁ¬ÉÏÁËvs £¬ µ«ºóÐøÎÒÒªÓÃc++ÓïÑÔÖ±½Ó²Ù×÷Êý¾Ý¿â£¬ »òÄܲ»Äܵ÷ÓÃmysqlµÄÓï¾äÀ´¶ÔÆä²Ù×÷£¬ ¸÷λ´óÏÀ°ï°ï棬¿ÉÒԵϰÌṩµã´úÂëÀý×Ӳο¼Ò»Ï£¬ÏÈлл¸÷λÁË¡£
Ò»°ã½¨ÒéÓÃMySQLµÄC API½øÐпª·¢
¹Ù·½µÄ£ºhttp://dev.mysql.com/downloads/connector/
C++ Óм¸ÖÖÁ¬ ......
ÎÒÏÖÔÚʹÓÃmysqldump,¿ÉÒÔ±¸·ÝÊý¾Ý¿âÖеıíºÍÊý¾Ý¡£
µ¼Èëµ½ÆäËü»úÆ÷ÉϵÄÊý¾Ý¿âÖÐÒªÔÙ½¨Á¢Óû§ºÍÊý¾Ý¿â¡£
ÎÒÔõÑùʵÏÖµ¼³ö±íºÍÊý¾Ý¿âµÄͬʱ£¬°Ñ¹ØÁ¬µÄÊý¾Ý¿âÃû£¬ÓÐȨ·ÃÎʵÄÓû§¶¼È«²¿µ¼³öÄØ¡£ÕâÑùÔÚµ¼ÈëµÄʱºî£¬²»Ðè¶îÍâÔÙÊÖ¹¤È¥´´½¨¿âºÍÓû§¡£Ð»Ð»£¡
Óû§µÄ·ÃÎÊȨÏ޼ǼÔÚmysql¿âÀïÃæµÄÒ ......
select sum(seconds) as c1, userid as c2, DATE_FORMAT(begintime,'%Y-%m-%d') as c3
from ActionRecord
where begintime >= '2009-09-01'
and endtime <= '2009-09-27'
and userid='admin'
and actiontype='LOGIN'&nbs ......
ÊDz»ÊÇÕâÑùµÄÓï¾ä delete from a where count(phoneNo)>1;
ÄãµÄÒâ˼ÊÇɾ³ýÓÐÖØ¸´ºÅÂëµÄËùÓмÇÂ¼ÄØ£¿»¹ÊǹýÂËÖØ¸´µÄ¼Ç¼ֻʣÆäÖÐÒ»Ìõ¼Ç¼£¿
¾ÍÊÇɾ³ýÖØ¸´ºÅÂë ֻʣÏÂÒ»Ìõ²»Öظ´¼Ç¼µÄ
¼ÙÈçÄãµÄ±íÓÐIDΨһֵÁеϰ£¬Ôò£º
SQL code:
select * from tb_name a where not exists (select 1 from tb_name b wh ......
³õ²½Ïë·¨£ºÓÃmysql±íµÄ²åÈë´¥·¢Æ÷ÖУ¬°ÑÕâÌõÊý¾Ýͬʱ²åÈëµ½ sql serverµÄÊý¾Ý±íÖУ¬ÊÇ·ñ¿ÉÐУ¿
Çó½â¾ö°ì·¨£¬Ð»Ð»~
¿ÉÐУ¬µ«²»ºÃ²Ù×÷
¿ÉÒÔ°¡£¬³ÌÐòÀïÃæÄãÁ½¸öÁ¬½Ó£¬Ò»¸ömssql¡£Ò»¸ömysql
Õâ¸öÎªÊ²Ã´ÄØ
¿ÉÒÔ£¬³ÌÐòµ±È»¿ÉÒÔ×öÁË£¡
ÒýÓÃ
¿ÉÒÔ£¬³ÌÐòµ±È»¿ÉÒÔ×öÁË£¡
ÎÒÊDz»Ïë¸Ä³ÌÐò£¬ÔÚmy sqlÖ ......