ÈçºÎÔÚWindowsÉϰ²×°Á½¸öMysql·þÎñ
Çå²Î¿¼
×î½üÖ»ÊÇºÃÆæ£¬ÏëÖªµÀÔÚwinÏÂÄܲ»ÄÜͬʱÔËÐÐÁ½¸ömysql £¬ÎÒÖ»ÊǾõµÃÉèÖõÄʱºòmysqlµÄ·þÎñ¶Ë¿Ú²»ÄÜÒ»Ñù£¬ÉèÖò»Í¬µÄ¶Ë¿ÚºóÓ¦¸Ã¿ÉÒÔ£¬¿ÉÊǾßÌå·½·¨»¹ÊDz»ÖªµÀ£¬ºóÀ´¾¹ý²éѯ×ÊÁÏ×Ü
×î½üÖ»ÊÇºÃÆæ£¬ÏëÖªµÀÔÚwinÏÂÄܲ»ÄÜͬʱÔËÐÐÁ½¸ömysql £¬ÎÒÖ»ÊǾõµÃÉèÖõÄʱºòmysqlµÄ·þÎñ¶Ë¿Ú²»ÄÜÒ»Ñù£¬ÉèÖò»Í¬µÄ¶Ë¿ÚºóÓ¦¸Ã¿ÉÒÔ£¬¿ÉÊǾßÌå·½·¨»¹ÊDz»ÖªµÀ£¬ºóÀ´¾¹ý²éѯ×ÊÁÏ×ܽá¾ßÌå·½·¨ÈçÏ£º
Ò»¡¢ÏÈÕý³£°²×°Ò»¸öWindows°æµÄMysql£¬ÀýÈç°²×°ÔÚd:\mysqlÎļþ¼ÐÀ
¶þ¡¢°´ÕÕ³£¹æÅäÖúÃMysql£»
Èý¡¢¸´ÖƱ¸·Ý°²×°ºÃµÄÎļþ¼Ð£¬±ÈÈ籸·Ýµ½ÁíÍâÒ»¸öÎļþ¼Ð£¬»òÕßÃüÃûΪ¡°¸´¼þmysql";
ËÄ¡¢ÔËÐÐÐ¶ÔØ³ÌÐòɾ³ý°²×°µÄMYSQLºÍÎļþ¼Ð£»
Îå¡¢°Ñ±¸·ÝµÄmysqlÎļþ¼Ð£¬ÖØÐ»ָ´ÔÀ´µÄÃû×Ö£¬»ò»¹Ôµ½ÔÀ´µÄλÖÃÉÏ£»
Áù¡¢ÔÙ´ÎÔËÐа²×°³ÌÐò£¬°²×°ÔÚÁíÍâÒ»¸öĿ¼£¬ÀýÈ磺¡°d:\mysql2"¡£ÅäÖö˿ÚΪ3307; ÏÖÔÚ£¬ºóÃæ°²×°µÄµÚ¶þ¸öMysql——mysql2¿Ï¶¨ÊÇ¿ÉÒÔÕý³£ÔËÐеģ¬ÏÂÃæÈÃÆð³õ°²×°µÄµÚÒ»¸öMysql ·þÎñÕý³£ÔËÐУºÔÚcmdÃüÁîÐÐģʽÏ£¬½øÈëµÚÒ»¸öMysqlµÄ\binÎļþ¼Ð¡£ Ö´ÐÐmysql-nt install mysql2ÃüÁî¡£×÷ÓÃÊÇΪMysql°²×°Ò»¸ö·þÎñ£¬·þÎñÃûÊÇmysql2£¬ÄãÒ²¿ÉÒÔ×Ô¼º¸ÄÃû×Ö£¬±ÈÈçmysql5£¬ÄÇôÃüÁî¾ÍÊÇ£º
mysql-nt install mysql5
Æß¡¢ÔÚÔËÐÐÀïÔËÐÐREGEDIT£¬´ò¿ªWINDOWS×¢²á±í±à¼Æ÷£¬ÔÚHKEY_LOCAL_MACHINE\SYSTEM \CurrentControlSet\Services\ÏîÄ¿ÕÒµ½Äã¸Õ²ÅÊÖ¶¯°²×°µÄ·þÎñ£¬ÎÒÕâÀïÊÇmysql2¡£´ò¿ª£¬ÐÞ¸ÄÏÂÃæµÄImagePathÊýÖµ¡£ ÄãÒ»°ã½«»á¿´µ½"D:\mysql\bin\mysqld-nt" mysql2ÀàËÆµÄÊýÖµ¡£ ÔÚmysql-nt"ºÍmysql2Ö®¼ä¼ÓÈëmy.iniµÄ·¾¶ÐÅÏ¢£¬¸
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÔÚmysqlÖÐÓÐÒ»ÕÅ±í£¬ÓÐÈý¸ö×Ö¶Îtotal,max, min£¬¶¼ÊÇintÐ͵ÄÖµ£¬¿ÉÒÔдһ¸ösqlÓï¾äÍê³É¹¦ÄÜ£º
¸ù¾ÝÿÌõ¼Ç¼ÖУ¬Èç¹ûtotal>max,·µ»Ø2£¬Èç¹ûtotal <min·µ»Ø1£¬Èç¹û¶¼Ìõ¼þ¶¼²»·ûºÏ·µ»Ø0¡£¼±Ç󣡣¡£¡£¡
mysql? ......
ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶
ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ
²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡± ......
Èç¹ûÎÒÊäÈëÒ»¸ö¹Ø¼ü×Ö,Èç¹ûÓÐÒ»¸ö¹¤¾ß,¿ÉÒÔÔÚÖ¸¶¨Êýé§¿âÖвéѰËùÓÐ±í²¢ÁгöÕÒµ½µÄ½á¹û,
²»ÖªµÀÓÐûÓÐÕâÖÖÀàÐ͵ÄMYSQL Êý¾Ý¿â¹¤¾ß
Èç¹ûÎÒÏÂÔØÁËÒ»¸ö³ÌÐò,ËüµÄ½Å×¢FOOT ÊÇдÔÚÊý¾ÝÖеÄÈç¹ûÓÐÒ» ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......