Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

C#ÔõôÁ¬½ÓMySql£¿

C#ÔõôÁ¬½ÓMySql£¿
sqlÓï¾ä·ÅÄÄ?
½á¹û¼¯ÔõôÓã¿
Çó½â´ð
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
    &nb ......

mysqlÆô¶¯ºó¼ÓÔØÊ±¼äÌ«³¤...

´ÓÆô¶¯µ½ÄÜÕý³£ÔËÐÐ,´ó¸ÅÒª15µ½20·ÖÖÓ×óÓÒ

ÏÖÏóÊÇ,Æô¶¯ÒÔºómysql½ø³ÌÔÚÈÎÎñ¹ÜÀíÆ÷ÀïÒѾ­¿ÉÒÔ¿´µ½ÁË,µ«ÊÇnetstat -anoûÓп´µ½Óнø³ÌÔÚ¼àÌý3306¶Ë¿Ú,ÉÏÃæÊý¾Ý¿â¶¼²»ÄÜ·ÃÎÊ
Ö±µ½15-20·ÖÖÓºó,ÄÜ¿´µ½mysqlÔÚ¼à ......

½ô¼±ÇóÖú£ºmysql´´½¨Ë÷Òý³öÎÊÌâÁË

´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º

create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;

±£´æÎªindex.s ......

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