Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÔÚ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µÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MYSQLÖиù¾Ý×Ö¶ÎÖµÅжϷµ»Ø²»Í¬µÄÖµ

ÔÚmysqlÖÐÓÐÒ»ÕÅ±í£¬ÓÐÈý¸ö×Ö¶Îtotal,max, min£¬¶¼ÊÇintÐ͵ÄÖµ£¬¿ÉÒÔдһ¸ösqlÓï¾äÍê³É¹¦ÄÜ£º
¸ù¾ÝÿÌõ¼Ç¼ÖУ¬Èç¹ûtotal>max,·µ»Ø2£¬Èç¹ûtotal <min·µ»Ø1£¬Èç¹û¶¼Ìõ¼þ¶¼²»·ûºÏ·µ»Ø0¡£¼±Ç󣡣¡£¡£¡
mysql? ......

WindowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼ ʧ°Ü

ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶

ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ

²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡± ......

ûÓпÉÒÔ²éÕÒmysql Êý¾Ý¿âÀïÃæÈ«ÓÐÄÚÈݵŤ¾ß

Èç¹ûÎÒÊäÈëÒ»¸ö¹Ø¼ü×Ö,Èç¹ûÓÐÒ»¸ö¹¤¾ß,¿ÉÒÔÔÚÖ¸¶¨Êýé§¿âÖвéѰËùÓÐ±í²¢ÁгöÕÒµ½µÄ½á¹û,


²»ÖªµÀÓÐûÓÐÕâÖÖÀàÐ͵ÄMYSQL Êý¾Ý¿â¹¤¾ß


Èç¹ûÎÒÏÂÔØÁËÒ»¸ö³ÌÐò,ËüµÄ½Å×¢FOOT ÊÇдÔÚÊý¾ÝÖеÄÈç¹ûÓÐÒ» ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ