Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySQL·þÎñÎÊÌâ,Çó¸ßÊÖÖ¸½Ì..

ÎÒµÄϵͳÊÇwindows XPµÄ,ÉÏ´ÎÓõçÄÔʱ¿ÉÒÔÔËÐÐmysql,µ«¹Ø»úºó,¸ô¶Ïʱ¼äÔÙ¿ª»ú,mysql¾Í²»ÄÜÕý³£ÔËÐÐÁË......¿ª»úºó,Mysql·þÎñÊÇ¿ªÆôµÄ,½ø³ÌÀïÃæµÄmysqld.exeµÄCPUÕ¼ÓÃÂÊΪ00,ÄÚ´æÊ¹ÓÃΪ72k(ºÍÎÒÉÏ´ÎÕý³£Ê¹ÓÃmysqlʱµÄ ......

oracle ¶ÔÓ¦µÄMySQLÓï¾ä

orcle Óï¾ä create table book1(name, price) as select book_name, price form book;
¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô

create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......

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ºÅ