MySQL°²×°ÎÊÌ⣡
³õ´Î°²×°µÄʱºòûÎÊÌ⣬µ«ÊÇÒ»²»Ð¡ÐÄÖØ×°ÏµÍ³ÁË£¬Ôٴΰ²×°MySQLµÄʱºò£¬µ½start serviceµÄʱºò¾Í²»ÐÐÁË£¬°²×°²»³É¹¦£¡
ÎҰѰ²×°ÎļþʲôµÄ¶¼É¾ÍêÁË£¬×¢²á±íÀïµÄҲɾÁË£¬µ«ÊÇ»¹ÊÇ×°²»³É¹¦£¡µ½ÏÖÔÚ»¹Ã»ÕÒµ½½â¾öµÄ·½·¨£¬Çë½Ì£¡
Ìáʾʲô´íÎó£¿
Â¥Ö÷£¬Çë°Ñ°²×°²»ÉϵĴíÎóÌáʾ
Ìù³öÀ´£¬·ñÔòÎÒÃÇÎÞ·¨°ïÖúÄã¡£
¿´²»µ½ÄãµÄͼ£¬CSDNÖÐÌùͼ²¢²»·½±ã£¡
×î¼òµ¥µÄ·½·¨£¬Ö±½ÓÏÂÔØ ZIP °æ£¬½âѹһϾÍÄÜÓÃÁË¡£
ÄãµÄ»ú×ÓÉϿ϶¨»¹ÓÐmysqlµÄһЩÎļþ£¬ÎÒ»¹Óöµ½ÀàËÆµÄÇé¿ö£¬ÒÔǰÓÃʱÊÇÕý³£µÄÂð£¿
ÒÔºó˵Ã÷°×Ò»µãÊÇʲôϵͳ£¿¶øÇÒÄãÊÇÓÃʲô°²×°µÄ¡£ÏµÍ³²»Ò»Ñù£¬°²×°·½·¨Ò²¾Í²»Ò»Ñù¡£Ð¶ÔØ·½·¨Ò²¾Í²»Ò»Ñù¡£×îºÃÌù³öʲô´íÎó¡£
Êý¾ÝÎļþɾ³ýÁËû?Ò»°ãÔÚC:\Documents and Settings\All Users\Application Data·¾¶Ï¡£
²é¿´Êý¾ÝÎļþλÖãºshow variables like 'datadir';
Äã°Ñmysql·þÎñÍ£ÁË£¬È»ºóÔÙÊÔÊÔ¡£
´ËÎÊÌâÎÒÒ²Óöµ½£¬ºóÀ´½â¾öÁË¡£
×öÒ»ÏÂÈý¼þÊÂÇ飺
1.Í£Ö¹MYSQl ·þÎñ
2.»¹ÒªÇå³ý×¢²á±íMYSQL
3.Çå³ýMYSQL°²×°ÈÕÖ¾£¬
ÕâÑùÔÙÊÔÊÔ¿´¡£
ÒÔÉϲ½ÖèÓÈÆäÊǵÚÈý²½ÖÁ¹ØÖØÒª¡£
½øÀ´¿´¿´¡£
ÎÒͬÒâ9Â¥µÄ·½·¨£¡£¡£¡¶¥£¡£¡£¡£¡
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......