Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

ASP +Mysql proc

ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ­»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇûÓдíµÄ¡£
³ö´íºóÎÒÔÚÊý¾Ý¿âÀï¿´insertÁ˶àÉÙÊý¾Ý£¬´ó¶àÊýÔÚ:75-93Ìõ×óÓÒ.
ÇëÎÊÕâÊÇΪʲô£¿ 
& ......

°ïæ¿´¿´MySQLÓйصÄÅú´¦ÀíÎļþµÄÓï·¨

echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£

echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
Çл»µ½´ËĿ¼
mysqld.exe --defaults-file=..\my.ini --console
Æô¶¯ mysql·þÎñ½ø³Ì
......

mysql grant ÃüÁîÎÞЧ£¬ÒÑ flush privileges

Ò»¿ªÊ¼½¨Á˸öÊý¾Ý¿â ftp,ÀïÃæÓÐÕűí user,

root ÊÚȨ Óû§ vhost ¿ÉÒÔ²éѯÕâÕűí.

SQL code:

GRANT select ON ftp.user TO 'vhost'@'localhost' identified by PASSWORD('xx');

Ë¢ÐÂÊÚȨ

SQL code:
flush privileges;


²âÊÔok.

È»ºó ÎÒÔÚphpmyadmin ÀïÃæÉ¾µôÁËÕâ¸öÊý¾Ý¿â. ......

¼±£¡mysqlÊý¾Ý¿âÁ¬½ÓÎÊÌ⣡

ÓÖÊÇÊý¾Ý¿âÎÊÌ⣬±¯°§---Ë­ÍÆ¼öµãÊý¾Ý¿â×ÊÁÏ£¿
mysql¸ÄµôÃÜÂëºóÖØÆômysql·ÃÎÊÍøÕ¾Ã»ÎÊÌâÁË---²»¹ý½ñÌìÈ´·¢ÏÖÍøÕ¾ÂÛ̳¿ÉÒԵǽ£¬µ«ÊÇÌá½»×¢²áÐÅÏ¢µÄ»°[img=C:\Documents   and   Settings\Administrator\×ÀÃæ\ÔÓͼ\δÃüÃû.jpg][/img].¶øÇҵǽºó·¢²¼µÄÐÅÏ¢Ó¦¸ÃÒ²ÊÇû´æµ½Êý¾Ý¿â---ÒòΪËüËäÈ»ÌáʾÐÅÏ¢·¢²¼³É¹¦£¬ ......

Õâ¸öMySqlÓï¾ä¸ÃÔõôÓÅ»¯£¿

±íµÄ½á¹¹ÊÇ

ÈÕÆÚ              ºÅÂë          ½ð¶î          ״̬
2009-11-23        9874          1000            0

ÐèÒª´Ó± ......

MySQlÔõô֪µÀÊý¾Ý¿â·þÎñÆ÷µÄÇé¿öÐÅÏ¢?

MySQlÔõô֪µÀÊý¾Ý¿â·þÎñÆ÷µÄÇé¿öÐÅÏ¢?

·þÎñÆ÷cpu  Õ¼ÓÐÂÊ
·þÎñÆ÷ÄÚ´æ Õ¼ÓÐÂÊ

SQL code:

SHOW PROCESSLIST;

ÒýÓ÷þÎñÆ÷cpu  Õ¼ÓÐÂÊ
·þÎñÆ÷ÄÚ´æ Õ¼ÓÐÂÊ

ÕâÁ½¸ö¶¼ÊDzÙ×÷ϵͳµÄ£¬²»ÊÇMYSQLµÄ¡£ÎÞ·¨Ö±½ÓÔÚMYSQLÖеõ½¡£
......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [167] [168] [169] [170] 171 [172] [173] [174] [175] [176]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ