Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÔÚwindows µÄmysql°ÑÊý¾Ý¿â·Åµ½dÅÌ

windows ϰ²×°Ò»¸ömysql £¬×°ÔÚcÅÌ
ÏÖÔÚcÅ̿ռä»ù±¾¿ìûÓÐÁË £¨ºÜ¶àÈí¼þĬÈÏÊÇ×°ÔÚcÅÌ£©

ÏëÖªµÀÈçºÎÔÚwindows µÄmysql
ϰÑÊý¾Ý¿â·Åµ½dÅÌ  £¨linux»áµÄ £¬²»ÖªµÀwinodwsÈçºÎ×÷£©
Ö±½Ó¸´ÖƹýÈ¥¡£È»ºó¸ÄÒ»ÏÂÄãµÄ my.ini ÎļþÖеÄÏà¹ØÂ·¾¶£¬±ÈÈçdatadir, basedir µÈ£¬ÄãÔÚÎļþÖÐËÑË÷һϠC:  £¬Ïà¹ØµÄ»»µô¡£

È»ºóµ½×¢²á±íÖÐÈ¥ÐÞ¸ÄһϠmysql µÄ·þÎñÏîÖÐµÄ Ö´ÐÐÎļþ·¾¶¡£ µ±È»Èç¹ûÄãÊÇÖ±½ÓÊÖ¹¤Æô¶¯µÄÕâ¸öÔò²»ÐèÒª¡£

linux»áµÄ»° window¸üûÎÊÌâÁË

ͬÑùÖ¸¶¨Â·¾¶ºÍĿ¼¾Í¿ÉÒÔÁË

Ò»¶¨ÒªÕÒµ½datadir Ëü´æ´¢Êý¾Ý¿âÊý¾Ý

°ÑÊý¾Ý¿â·Åµ½dÅÌ 
ÐÞ¸Ämy.ini  ºÍ ×¢²á±í

ÖØÆôÊý¾Ý¿â
½á¹û·¢ÏÖ Òì³£ÖÕÖ¹£¿£¿£¿£¿

ERROR   woo3(HY000)
can 't   to   mysql   server   on 'loclahost '     (10061)

¿ØÖÆÃæ°å  Æô¶¯ mysql·¢ÏÖ
ÔÚ±¾µØ¼ÆËã»úÎÞ·¨Æô¶¯ mysql·þÎñ
´íÎó 1067  ½ø³ÌÒâÍâÖÕÖ¹

Í£Ö¹·þÎñ£¬°ÑÊý¾ÝÎļþ¿½±´¹ýÈ¥ºó£¬È»ºóÐÞ¸Ämy.iniÕâÑùÅäÖÃÎļþϵÄdatadir¡£
ÐèÌØ±ð×¢ÒâµÄ£¬Èç¹ûÄãÁ¬my.iniÔÚÄÚµÄÕû¸öĿ¼¶¼¿½±´¹ýÈ¥Á˵ϰ£¬ÒòΪmy.iniÅäÖÃÎļþµÄ·¾¶¸ü¸ÄÁË£¬ËùÒÔ£¬µÃ°Ñmysql·þÎñÀïÃæµÄ--defaults-file¸ü¸ÄÁ˲ÅÄÜÕý³£Æô¶¯·þÎñ¡£

ÒýÓÃ
¿ØÖÆÃæ°å  Æô¶¯ mysql·¢ÏÖ
ÔÚ±¾µØ¼ÆËã»úÎÞ·¨Æô¶¯ mysql·þÎñ
´íÎó 1067  ½ø³ÌÒâÍâÖÕÖ¹


Õâ¸ö¹À¼Æ¿ÉÄÜÊÇÄãµÄmy.iniÀïÃæµÄdatadirÖ®ÀàµÄ²ÎÊýûÐ޸Ķԣ»Ò²ÓпÉÄÜÄãÁ¬my.iniÅäÖÃÎļþÒ²Ò»ÆðÇ¨ÒÆÁË£¬¶ømysqlµÄ·þÎñÖ


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

°²×°mysql£¬Çë°ï棡

±¾ÈËÐÂÊÖ ÏÂÔØÁ˸ömysql ÇëÎÊÈçºÎ°²×°
mysql-5.1.32-linux-i686-glibc23.tar.gz
ÄãÊÇʲôϵͳ£¿

redhatµÄ»°¾ÍÈ¥ÏÂrpm£¬Ö±½Órpm -i xxxx.rpm¾ÍOKÁË


²»¹ý±¾ÈË»¹ÊÇÍÆ¼öʹÓð²×°µÄ°æ±¾

ÒýÓÃ
ÎÒ¿´Á ......

url´æÈëmysqlÊý¾Ý¿âǰµÄʱºòÒª½øÐÐʲô´¦Àí£¿

SQL code:
UPDATE `footballmatch`.`promote` SET `pr_ballhype` = http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8 WHERE `promote`.`fm_post_id` =369


ÒÔÉ ......

mysqlÖÐÎÄÂÒÂë

ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬
mysql×Ö·û¼¯ÉèÖÃÈçÏ£º
    -> ;
+--------------------------+----------------------------------- ......

mysql ²éѯÓï¾ä

select id,dtime,zt,optype( Èç¹ûoptype=0½«±¾ÌõÊý¾Ý²åÈëµ½table1±íÖУ¬Èç¹ûoptype=1ÒÔdtimeºÍztΪÌõ¼þÖ´ÐÐÒ»Ìõ²éѯÓï¾ä ) from table
ʵÏÖÕâ¸öÒªÇóµÄÓï·¨Ôõôд
Ò»ÌõSQLÓï¾ä¹À¼Æ¸ã²»¶¨¡£µÈ¥Ϻ÷½·¨£¡

Èç¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ