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

php¸üÐÂÒ»×Ö¶Îij×Ö·û

±ÈÈ磺±í1×Ö¶Îtop °üÀ¨Êý¾Ý¡°a,b,c,d¡± ÎÒÒª¸üÐÂtop×Ö¶ÎÊý¾ÝΪ¡°a,c,d¡± Ò²¾ÍÊÇÈ¥µô¡°,b¡± µ«ÊÇ¡°,b¡±µÄλÖò»È·¶¨Ò²¿ÉÄÜÊÇ¡°a,c,d,b¡±
û¿´¶®ÄãµÄÎÊÌ⣬ÊǸüÐÂÊý¾Ý¿âÖеÄ×ֶΣ¿

Èç¹ûÄÇÑùÓ¦¸ÃÊÇSQLµÄÎÊÌâÁË

SQL code:

update tablename set top=replace(top,',b','');



ÒýÓÃ
SQL codeupdate tablenamesettop=replace(top,',b','');

ÕâÑùÖ»ÄÜÌæ»»¡®,b¡¯
ÒòΪ¡®,b¡¯µÄλÖÃÊDz»Ò»¶¨µÄ£¬ÓпÉÄÜ»áÊÇ¡®b¡¯£¬Ò²¾ÍÊÇ˵ÓпÉÄÜ¡®b¡¯ÅÅÔÚÇ°Ãæ»òºóÃæ

ÒýÓÃ
ÒýÓà 2 Â¥ zhoupuyue µÄ»Ø¸´:
SQL codeupdate tablenamesettop=replace(top,',b','');

ÕâÑùÖ»ÄÜÌæ»»¡®,b¡¯
ÒòΪ¡®,b¡¯µÄλÖÃÊDz»Ò»¶¨µÄ£¬ÓпÉÄÜ»áÊÇ¡®b¡¯£¬Ò²¾ÍÊÇ˵ÓпÉÄÜ¡®b¡¯ÅÅÔÚÇ°Ãæ»òºóÃæ

Õâ¾ÍÖ»ÄÜÓóÌÐòÍâÃæÊµÏÖÁË£¬±ÈÈçÓÃÕýÔò±í´ïʽ°ÑËüÌæ»»µô

Ö±½Ó°ÑÕûÁÐÌæ»»ÁËÄØ£¿

ÒýÓÃ
ÒýÓà 3 Â¥ chenxuezhi1986 µÄ»Ø¸´:
ÒýÓà 2 Â¥ zhoupuyue µÄ»Ø¸´:
SQL codeupdate tablenamesettop=replace(top,',b','');

ÕâÑùÖ»ÄÜÌæ»»¡®,b¡¯
ÒòΪ¡®,b¡¯µÄλÖÃÊDz»Ò»¶¨µÄ£¬ÓпÉÄÜ»áÊÇ¡®b¡¯£¬Ò²¾ÍÊÇ˵ÓпÉÄÜ¡®b¡¯ÅÅÔÚÇ°Ãæ»òºóÃæ

Õâ¾ÍÖ»ÄÜÓóÌÐòÍâÃæÊµÏÖÁË£¬±ÈÈçÓÃÕýÔò±í´ïʽ°ÑËüÌæ»»µô


¶Ô£¡ÎÒ¾ÍÊÇÒ»¸öºÃµÄʵÁУ¡

SQL codeupdate t


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

phpʱ¼äÕýÔòÎÊÌâ - PHP / »ù´¡±à³Ì

PHP code:

$date = '2009-12-25';
$ptn = '/([\d]{4})[- \/](0?[\d]|1[0-2])[-\/ ](0?[\d]|[1-2][\d]|3[0-1])/';
if (preg_match($ptn,$date,$out))
{
print_r($out);exit();
}
½á¹ûΪ:
PHP code:
......

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

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

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

¿ÉÒÔÓÃÈ ......

ÉϺ£ÕÐÉè¼ÆÊ¦¡¢PHP³ÌÐòÔ±

ÕÐÆ¸Ö°Î»£ºÉè¼ÆÈËÔ±
ѧ Àú£º²»ÏÞ
Ö÷Òª¹¤×÷£ºÍøÒ³Éè¼Æ£¬Æ½ÃæÉè¼ÆµÈÉè¼ÆÀ๤×÷¡£
×îµÍÒªÇó£ºÖÁÉÙÓо«Í¨Ò»ÃÅÊìÁ·µÄÉè¼Æ¹¤¾ß£¬È磺PS¡¢AI¡¢FWµÈ¡£
н Ë®£ºÃæÒ飬ÊÔ¹¤×÷ÄÜÁ¦¶ø¶¨¡£
ÓÅÏÈ¿¼ÂÇÌõ¼þ£º
1. ´´Òâ˼Π......

PHPÉÏ´«Í¼Æ¬Îļþ´óСµÄ200KÏÞÖÆ¡£ - PHP / »ù´¡±à³Ì

ÒѾ­ÐÞ¸ÄÁË
£¨1£©PHP.iniÖеÄpost_max_size ºÍupload_max_filesize£¬²¢ÇÒ±£Ö¤ÁËǰÕß´óÓÚºóÕß
£¨2£©Windows\System32\inetsvr\MetaBase.xmlÖеÄAspMaxRequestEntityAllowed
ÐÞ¸ÄÍê±Ïºó£¬ÖØÐÂÆô¶¯ÁËIIS·þÎñ£¬²¢ÇÒ¼Æ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ