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

Çë½ÌÒ»¸öÎÊÌâ¹þ£¬¹ØÓÚMYSQLдÈëµÄ¡­

ÎÊÌâÃèÊö£º
×öÁ˸öÍøÕ¾£¬·Åµ½±ðµÄ·þÎñÆ÷É϶¼¿ÉÒÔÕý³£¶ÁдmysqlÊý¾Ý¿â£¬µ«ÊǷŵ½Ñ§Ð£Ò»¸ö×Ô¼ºµÄ·þÎñÆ÷ÉÏÈ´Ö»ÄܶÁ²»ÄÜд¡£
ÎÒ°ÑÕâ¸öÍøÕ¾Óַŵ½¸Ã·þÎñÆ÷Ò»¸öÄܹ»Õý³£¶ÁдMysqlµÄÍøÕ¾ÏµÄÒ»¸öĿ¼£¬ÕÕÑùÖ»ÄܶÁ²»ÄÜд£¬¶øÇÒ²»±¨´í¡£ÓôÃÆ¡­¡­

µ½µ×Êǰ汾ÎÊÌ⻹ÊÇ×Ö·û¼¯ÎÊÌ⣿PHPºÍMysql¶¼ÊÇ5.0ÒÔÉÏ¡£Çë¸ßÊÖÖ¸µãÖ¸µã¿ÉÄÜÊÇɶÎÊÌ⣿·Ç³£¸Ðл¡£
ȨÏÞ£¿ipÏÞÖÆ£¿Óû§Ãû£¿


ȨÏÞʹÓõÄÊǺÍÎÒËù·ÅÄ¿Â¼ÍøÕ¾µÄȨÏÞ ¶¼ÊÇroot

Èç¹ûÊÇȨÏÞ²»¹»¾ÍÓÃgrant¸³È¨°É

»¹ÓоÍÊÇ£¬ÎÒÊÇÔÚ·þÎñÆ÷±¾»úµ÷ÊÔ

ÌùÕâ¸ö½á¹û¿´¿´ÏȰɣº

mysql> show grants for ÕʺŠ\G

ºÃ£¬ÊÔÊÔ¿´

Ê×ÏÈ¿¼ÂÇÒ»ÏÂÊDz»ÊÇȨÏÞµÄÎÊÌâ

mysql µÄȨÏÞÊǸù¾Ý username@hostname À´µÄ¡£

ÀûÓÃshow grants ¼ì²éһϵ±Ç°ÄãµÇ¼Óû§µÄȨÏÞ¡£

ÊDz»ÊÇ·þÎñÆ÷ÏÞÖÆÁË



1 ¿´mysqlµÄȨÏÞÉèÖÃ
2 ¿´Êý¾ÝÎļþµÄȨÏÞ£¬Èç¹ûÕâ¸öȨÏÞÖ»ÓжÁûдµÄ»°£¬Ò»Ñù²»ÐÐ(Ò»°ãÇé¿öϲ»Ì«¿ÉÄܳöÏÖ)¡£

ÎÊÌâ½â¾öÁË£¬ÊÇÒòΪ´úÂëдµÄËÉÉ¢µÄÔ­Òò ÔÚijЩ°æ±¾PHPÉÏÎÞ·¨Ö´ÐС£
insert into guestbook valuese
±ØÐëд³Éinsert into guestbook('','',¡­¡­)


Ïà¹ØÎÊ´ð£º

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

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

MYSQL Êý¾Ý½ØÈ¡

MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);

¶¥£¬Ñ§Ï°

SQL code: ......

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ