Ôõôд¸öbat Îļþ£¬Ö±½Ó½ødos£¬½ø³ÌÁ¬½Ómysql£¿£¿
ÿ´Î½øÈë¶¼Òª ÔÚ ÔËÐÐ ----¡·cmd ----¡·»Ø³µ£¬È»ºó½øÈëdos£» È»ºóÔÙд mysql -u root -p root »Ø³µ ½øÈ¥mysql£» ÏÖÔÚÏëÎÊÎÊ ËÄܸøÒÔ¸ö bat Îļþ£¬Õâ¸öÎļþ¾ÍÊǵã»÷¾ÍÈÃÄãдÃÜÂ롣Ȼºó½øÈëmysql µÄdos½çÃæ°¡£¿ »òÕßÖ±½Ó²»ÓÃдÃÜÂ룬֮¼Ê¾Í½øÈ롣ʡµÄÎÒÿ´Î¶¼Ð´ mysql -u -p µÄ£» ¹ÖÂé·³µÄ¡£ лл¡£
BAT: "C:\newmysql\bin\mysql" -u root -pÄãµÄÃÜÂë rootÒýÓà BAT: "C:\newmysql\bin\mysql" -u root -pÄãµÄÃÜÂë root ²»ÄÜÓð¡¡£ ÄãÄÜ·ñ˵Ã÷һϣ¬c:\newmysql Õâ¸öĿ¼ÊÇ˵Ã÷Ŀ¼°¡£¿Ð»Ð»¡£ÒýÓà ÒýÓà 1 Â¥ wwwwb µÄ»Ø¸´: BAT: "C:\newmysql\bin\mysql" -u root -pÄãµÄÃÜÂë root ²»ÄÜÓð¡¡£ ÄãÄÜ·ñ˵Ã÷һϣ¬c:\newmysql Õâ¸öĿ¼ÊÇ˵Ã÷Ŀ¼°¡£¿Ð»Ð»¡£ ÄãµÄmysqlµÄ°²×°Ä¿Â¼ Èç¹ûÄãÒѾ°Ñmysql°²×°Ä¿Â¼ÏµÄbinÒѾÌí¼Óµ½ÏµÍ³µÄ»·¾³±äÁ¿£¬ÔòÖ±½ÓÕâÑù¾Í¿ÉÒÔÁË£º SQL code: mysql -hlocalhost -uroot -ppasswordÒýÓà ÒýÓà 1 Â¥ wwwwb µÄ»Ø¸´: BAT: "C:\newmysql\bin\mysql" -u root -pÄãµÄÃÜÂë root ²»ÄÜÓð¡¡£ ÄãÄÜ·ñ˵Ã÷һϣ¬c:\newmysql Õâ¸öĿ¼ÊÇ˵Ã÷Ŀ¼°¡£¿Ð»Ð»¡£ Ö»ÊÇÒ»¸öʾÀý£¬ÐÞ¸ÄÎ
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ÉÊÇÎÒÕÒ ......
mysql>create book( ->id varchar(20) not null,g -> ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷ ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÈçÌ⣬MySQL²»»áÕâÑù°É Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖà ֧³Ö£¬¼ì² ......
ÎÒÓÐÁ½¸ö±í. a±íÖÐÓлý·Ö×Ö¶Î. b±íÒ²Óиö»ý·Ö×Ö¶Î. ÒòΪa±íºÍb±íÊôÓÚ²»Í¬Á½¸öƽ̨. Èç¹û×öµ½Í¬²½?¾ÍÊÇa±íÐ޸ĵÄʱºòͬʱÐÞ¸Äb±í.ͬʱb±íÐ޸ĵĻ°Ò²ÐÞ¸Äa±í. ±í 1 bbs_member ......