²éѯMysqlÊý¾Ý¿â - .NET¼¼Êõ / ASP.NET
ÎÒµÄÊý¾Ý¿âÖÐÓÐÒ»ÁеÄÖµÊÇ¡°²âÊÔÊÙÃü¡±£¬µ«ÊÇÔÚËü´æ´¢µÄ·½Ê½ºÃÏñÊǵ¥×Ö½Ú¸ñʽ...ÔÚÍâ±ßµÄ²éѯÓï¾äÊÇlike '%²âÊÔÊÙÃü%' Á½¸öû°ì·¨¶Ô±È£¬ÄÇλ´óϺ¸ø³ö¸öת»»µÄ´úÂë...СµÜл¹ýÁË
µ¥×Ö½ÚÓÃlike ? ???
Ö±½ÓÓÃ=ºÅ²»ÐÐÂ𣿣¿£¿
²»ÊǵȺŲ»µÈºÅµÄÎÊÌâ....Êý¾Ý¿âÖÐÊÇÕâÖÖ×Ö·ûÊÙÃü²âÊÔ...sqlÓï¾äÊÇselect * from h where info like '%²âÊÔÊÙÃü%'......Õâ¸öºÃÏñ±ØÐëת»»Ò»¸ö£¬ÎÒ²»ÖªµÀÔõô»¥Ïàת»¯
1.°Ñmysql ÉèÖóÉutf-8
2.Á¬½Ó×Ö·û´®:connectionString="server=192.169.1.115;database=miapsoft;uid=root;pwd=123456;charset=utf8"
ÕâÀï±£Ö¤²»»áÓÐÈκÎÂÒÂëÎÊÌâ.~
ÌáÐÑ : Â¥Ö÷ÐèÒªÌá¸ß½áÌùÂÊ
¹Ø¼üÊǵ±Ê±²åÈëÊý¾ÝµÄʱºòûÓÐÉèÖ㬶øÇÒÏÖÔÚÓÖ²»Äܶ¯Êý¾Ý¿âÖеÄÊý¾Ý¿â¡£ËùÒÔÒª±È½Ï¿Ï¶¨Òª×ª»¯Ò»¸ö....
Ïà¹ØÎÊ´ð£º
±¾È˹¤×÷¾ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp.net
ÊìϤjavascript
ÊìϤCss
ÊìϤajax
ÊìϤsqlserver2005
ÓÐÒ»ÄêµÄÏîÄ¿¾Ñé
¾ßÌåÏîÄ¿ºÍÆäËûµÄ¾Í²»ÔÚÕâдÁË
ÓÐÒâÕßÁªÏµ£º
QQ:359233910
ÒýÓÃ
±¾È˹¤×÷¾ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøվͼƬ¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
/ ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......