PBÈçºÎÒþ²Øµ¥»úMYSQLÆô¶¯ºóÄǸöcmd´°¿Ú£¿
ÎÒÓÃMYSQLµ¥»ú°æ£¬Ð´Á˸öBAT´ò¿ªÒ»¸öCMD´°¿Ú È»ºóÆô¶¯ mysqld --console ÕâÑùÆô¶¯µÄ»° ´ò¿ªµÄÕâ¸öCMD´°¿ÚÄܲ»ÄÜÏë°ì·¨Òþ²Øµô »òÕß°ÑËû×îС»¯µ½ÈÎÎñÀ¸È¥¡£¡£¡£
ÐÖµÜÃǸø¸öÏë·¨£¿
×ö³É·þÎñ£¡
(*^__^*) ÎûÎû¡¡ ÓÐÏà¹ØµÄÌû×Óô Õ¦×ö³É·þÎñ°¡£¿
¶¥~~~~~~~~~~~~~~~~~
д¸ö³ÌÐòÔËÐÐÖ¸Á¿ÉÒÔʵÏÖÒþ²Ø¡£
ÇëÎÊ c:\mysql1\bin\mysqld --console ºÍ c:\mysql1\bin\mysqld ÓÐÊ²Ã´Çø±ðÄØ
ÎÒBATÀï ÓõÄÊÇÇ°ÃæÕâ¾ä ¿ÉÒÔÕý³£Æô¶¯ MYSQL ºóÃæÕâ¾ä¾Í²»ÐÐ Õâ¸öconsole±ØÐë´ø×Å£¿
c:\mysql1\bin\mysqld ΪʲôÕâÑùÆð²»À´¿âѽ¡£¡£¡£¡£¡£¡£¡£
×¢²á³Éϵͳ·þÎñ ÊÔÑé³É¹¦ÁË µ«ÊÇÒªÏÈ removeһϠ·ÀÖ¹¿Í»§»úÆ÷ÉÏÒѾÓÐmysql·þÎñÁË ÎÒ¾õµÃÕâÑùÒþ²ØµÄÎÊÌâºÜÉî°¡£¡£¡
cmd³ÌÐò¿ÉÒÔ×ö·þÎñ£¬ÎÒд¹ýÒ»¸öjavaµÄ£¬ÔÀ´ÓõÄcmd£¬ºóÀ´Ò²×ö³É·þÎñÁË
ÎÒ֮ǰÊÇÏÈ net stop mysql È»ºóÆô¶¯×Ô¼ºµÄ¿â Í˳öʱ net start ÔÙ°ÑÔÀ´µÄϵͳ·þÎñÆô¶¯ÆðÀ´ £¬µ«ÊÇÓиöÎÊÌâ¾ÍÊÇ Ö»ÄÜÓÃc:\mysql1\bin\mysqld --console À´Æô¶¯£¬Õâ¸öconsole²ÎÊý²»¼Ó ¾ÍÆô¶¯²»ÁË£¬´ø×Åconsole°É£¬ÄǸöCMD´°¿Ú¾Í¿¨ÄÇÁË ²»ÄÜ¹Ø ºÜ·³ÈË£¬ Ϊʲô²»´øÕâ¸ö²ÎÊýÆð²»À´ÄØ £¿Õâ¸öÊÇÔõô»ØÊÂ
Èç¹û°Ñ×Ô¼ºµÄMYSQLÒ²×ö³É·þÎñ ¿ÉÒÔÈÆ¹ý»úÆ÷ÉÏÒÑÓеÄMYSQL·þÎñ ½¨Á¢ÊôÓÚ×Ô¼ºµÄÒ»¸ö·þÎñô¡£¡£±ÈÈç net start mysql_1 ÕâÑù¿ÉÐÐô£¿
End_rbody_60094265//-->
¸Ã»Ø¸´ÓÚ2009-09-27 08:25:15±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
jjoulejcc
(񎙡)
µÈ¡¡¼¶£º
#11Â¥ µÃ·
Ïà¹ØÎÊ´ð£º
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
¡¡´úÂ룿
ÒýÓÃ
mysql insertÓï¾äÖÐÓÐ?£¬ÌáʾÖÂÃü´íÎ󣿣¿£¿£¿£¿£¿£¿
½¨ÒéÌùÍêÕûinsert´úÂë¼°´íÎó´úÂ룬ÒÔ±ã·ÖÎö
ÇëÂ¥Ö÷ÌùÍêÕûµÄsql´ú ......