Çë½ÌÒ»¸öÎÊÌâ¹þ£¬¹ØÓÚ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-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);
¶¥£¬Ñ§Ï°
SQL code: ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
select * from table where '123456789' like '%'+×ֶαí+'%'
Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......