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

mysqlÔõôʵÏÖÄ£ºý²éѯº¬%µÄÊý¾Ý

µÃÓÃlike 
ÊÇmysql
SELECT * from TB WHERE COL LIKE '%AFDA%'

ÒýÓÃ
µÃÓÃlike 
ÊÇmysql

mysql?
SQL code:
²»¶®£¬°ï¶¥£¬Ñ§Ï°£¬²ä·Ö.


ÕûÀíһϠ¥Ö÷µÄÒâ˼¡£

ÊÇÓà mysql  ʵÏÖ ²éѯ  Êý¾ÝÖк¬ÓÐ % µÄÊý¾Ý£¡

ÒýÓÃ
ÕûÀíһϠ¥Ö÷µÄÒâ˼¡£

ÊÇÓà mysql  ʵÏÖ ²éѯ  Êý¾ÝÖк¬ÓÐ % µÄÊý¾Ý£¡


ÊÇÓà mysql ÖеÄlikeÓï¾ä ʵÏÖ ²éѯ  Êý¾ÝÖк¬ÓÐ % µÄÊý¾Ý£¡

SQL code:
select * from student where sname like '%[%]%'


msserverÖÐÓÃ like '%[%]%'
ÔÚmysql²»ÐУ¬»áµÄ¸æËß°³ лл£¡

ÒýÓÃ
SQL codeselect*from studentwhere snamelike'%[%]%'

sorry..
°ï¶¥

ÒýÓÃ
msserverÖÐÓÃ like '%[%]%'
ÔÚmysql²»ÐУ¬»áµÄ¸æËß°³ лл£¡


SQL code:
SELECT * from TB '%''%''%'


ÖªµÀÁË ÊÇ like '%\%%'

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

ÐèÒªÊÓÆµ½Ì³ÌµÄÐÂÊÖ½ø php + mysql + apache ÅäÖÃ

Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´


......

MYSQL character_set_server Ôõô¸Ä

ÎÒ¿ª·¢ASP.netʱ 
²åÈëÍâÎÄÂÒÂë 
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8 
character_set_connection utf8 
character_set_database utf8 
ch ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

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