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

̸¹ØÓÚmysqlÖÐÎÄÄ£ºý²éÕÒÎÊÌâ


Ðí¶àÅóÓÑÔÚʹÓÃmysql½øÐÐÖÐÎÄÄ£ºý²éÕÒʱ(Èçselect * from mytable where mysqlname like "%ÖÐÎÄ%"),¾ÍÏóÎÒÏÖÔÚÒ»Ñù£¬ÕÒµ½²»Ó¦ÕÒµ½µÄÐÐ!
ÓÐһЩÅóÓÑÌá³öÁ˽â¾ö°ì·¨£¬´óÖÂÓÐÁ½ÖÖ£º
ÆäÒ»£¬¼Ó×Ö¶ÎÊôÐÔbinary(),
Æä¶þ,¸Ämy.cfgÆô¶¯²ÎÊýΪdefault-character-set =gbk(»ògb2312).
ÎÒ´ÓÎÊÌâµÄ¸ù±¾Ô­Òò·ÖÎö£¬
ÆäÒ»£¬×Öĸ´óС²»Çø·ÖÎÊÌâ(ͨ¹ý·½·¨Ò»¿ÉÒÔ½â¾ö)
Æä¶þ£¬ÕâÊÇ´ó¶àÊýÈËûÓÐÏëµ½µÄ£¬ÎÒÒÔǰҲûÓÐÏëµ½£¬
Àý£º
ºº×Ö“²»”µÄµÚ1¡¢2×Ö½ÚasciiÖµ·Ö±ðΪ£º178Óë187
ºº×Ö“°²”µÄµÚ1¡¢2×Ö½ÚasciiÖµ·Ö±ðΪ£º176Óë178
ºº×Ö“»¨”µÄµÚ1¡¢2×Ö½ÚasciiÖµ·Ö±ðΪ£º187Óë168
´ÏÃ÷µÄÈËÒѾ­¿´³öÀ´ÁË£ºÔÚ×Ö·û´®“°²»¨”ÖÐÄ£ºý²éÕÒ×Ö·û“²»”×Öʱ£¬mysqlϵͳҲ»áÈÏΪÁ½ÕßÇøÅä!
ÎÒµÄmysql-4.0.12ûÓнâ¾öÉÏÊöÎÊÌâ¡£²»¹ýÎÒ²ÉÓÃÒ»¸ö½Ï±¿µÄ°ì·¨½â¾öÁË!
Õë¶ÔÒÔÉÏÎÊÌ⣬¸÷λ¸ßÊÖÓкνâ¾ö°ì·¨!!!Ò»ÆðÀ´ËµÒ»Ëµ!
(Ìá³ö°ì·¨Õ߿ɵÃ100·Ö)
---------------------------------------------------------------
1: my.ini ÎļþÖмÓÈë default-character-set =gb2312
2: ×ֶβ»Òª¼Ó Binary ÊôÐÔ
3: Ö´ÐÐ select * from mytable where mysqlname like "%²»%"
---------------------------------------------------------------
ÐèҪ˵Ã÷µÄÊÇ
1:
2:
ÊÇ×îÖØÒªµÄ,
Èç¹ûÊDzéѯºº×Ö,
select * from mytable where mysqlname like "%²»%"
Èç¹ûÊÇ´óС×ÖÇø·Ö²éѯӢÎÄ×Ö·û,
select * from mytable where mysqlname like Binary("%A%")
Èç¹ûÉÏÊöÌõ¼þ¾ùÒª
select * from mytable where mysqlname like "%²»%" AND mysqlname like Binary("%A%")
²»¹ýÏñÕâÀàÇé¿ö,
ÒѲ»ÔÙ½¨ÒéʹÓà LIKE '%a%' ÐÎʽÁË
½¨ÒéʹÓà ȫÎÄË÷Òý Óë ÕýÔò±í´ïʽ À´Æ¥Åä×Ö´®


Ïà¹ØÎĵµ£º

ÅäÖÃMySQLÊý¾Ý¿âË«»úÈȱ¸·Ý£¨×ª£©

      1¡¢mysql Êý¾Ý¿âûÓÐÔöÁ¿±¸·ÝµÄ»úÖÆ£¬µ±Êý¾ÝÁ¿Ì«´óµÄʱºò±¸·ÝÊÇÒ»¸öºÜ´óµÄÎÊÌâ¡£»¹ºÃ mysql Êý¾Ý¿âÌṩÁËÒ»ÖÖÖ÷´Ó±¸·ÝµÄ»úÖÆ£¬Æäʵ¾ÍÊǰÑÖ÷Êý¾Ý¿âµÄËùÓеÄÊý¾Ýͬʱдµ½±¸·ÝÊý¾Ý¿âÖС£ÊµÏÖ mysql Êý¾Ý¿âµÄÈȱ¸·Ý¡£
¡¡¡¡2¡¢ÒªÏëʵÏÖË«»úµÄÈȱ¸Ê×ÏÈÒªÁ˽âÖ÷´ÓÊý¾Ý¿â·þÎñÆ÷µÄ°æ±¾µÄÐèÇó¡£ÒªÊµÏ ......

mysql ²ÎÊý(2)

lect ASIN('foo');
¡¡¡¡-> 0.000000
ATAN(N)
¡¡·µ»ØNµÄ·´ÕýÇÐÖµ
mysql> select ATAN(2);
¡¡¡¡-> 1.107149
mysql> select ATAN(-2);
¡¡¡¡-> -1.107149
ATAN2(X,Y)
¡¡·µ»Ø2¸ö±äÁ¿XºÍYµÄ·´ÕýÇÐ(ÀàËÆY/XµÄ·´ÕýÇÐ,·ûºÅ¾ö¶¨ÏóÏÞ)
mysql> select ATAN(-2,2);
¡¡¡¡-> -0.785398
mysql> ......

LAMP(Linux+Apache+MySQL+PHP)·þÎñÆ÷µÄÐÔÄÜÓÅ»¯

ĿǰLAMP (Linux + Apache + MySQL + PHP) ½ü¼¸ÄêÀ´·¢Õ¹Ñ¸ËÙ£¬ÒѾ­³ÉΪWeb ·þÎñÆ÷µÄÊÂʵ±ê×¼¡£LAMP 
Õâ¸ö´ÊµÄÓÉÀ´×îÔçʼÓڵ¹úÔÓÖ¾“c't Magazine”£¬Michael KunzeÔÚ1990Äê×îÏȰÑÕâЩÏîÄ¿×éºÏÔÚÒ»Æð´´ÔìÁËLAMPµÄËõд×Ö¡£ÕâЩ×é¼þËäÈ»²¢²»ÊÇ¿ª¿ªÊ¼¾ÍÉè¼ÆÎªÒ»ÆðʹÓõ쬵«ÊÇ£¬ÕâЩ¿ªÔ´Èí¼þ¶¼¿ÉÒԺܷ½±ã µÄË ......

mysql µ¼³öÊý¾Ý¿â

     ½øÈëcmd
     ===================
     1.µ¼³öÊý¾Ý¿â£¨sql½Å±¾£©
     mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u root -p db_name > test_db.sql
¡¡¡¡2.mysqlµ¼³öÊý¾Ý¿âÒ ......

MySql ÅжϺº×Ö¡¢ÈÕÆÚ¡¢Êý×ֵĺ¯Êý

¼¸¸öƽ³£ÓõÄmysqlº¯Êý
/*****************************************************
1.ÅжÏ×Ö·û´®ÊÇ·ñΪºº×Ö ·µ»ØÖµ£º1-ºº×Ö 0-·Çºº×Ö
*****************************************************/
DROP FUNCTION IF EXISTS fc_is_hanzi;
CREATE FUNCTION  fc_is_hanzi(
p_str VARCHAR(1024)
)
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ