ÈçºÎɾ³ýMYSQLÖеĿÕ×Ö·û´®
ÎÒÓÃDELET from WHERE NAME IS NULL »ò=¡®¡¯ ¶¼²»Ðа¡
ÄDz»¿ÉÄܲ»Êǿգ¬ÊÇÆäËû×Ö·û Êǿհ¡£¬Ã»´í°¡¡£ SQL code: DELET from WHERE NAME IS NULL or LEN(NAME)=0 or UPPER(NAME)='NULL'ÒýÓà SQL codeDELETfromWHERE NAMEISNULLorLEN(NAME)=0orUPPER(NAME)='NULL' ¸ú×ÅÂ¥Ö÷Ò»Æðд´íÁËDELETE SQL code: DELETE from WHERE NAME IS NULL or LEN(NAME)=0 or UPPER(NAME)='NULL' SQL code: DELETE TB WHERE ISNULL(NAME,'')='' ¿´À´¿ÉÄÜÓÖÊÇÈ«½Ç¿Õ¸ñ,»òÊÇTAB MYSQl²»ÖªµÀ MSSQL±»ËûÃÇ˵¹âÁË ²»¶Ô°¡ »¹ÓÐÆäËû°ì·¨ÂðÒýÓà »¹ÓÐÆäËû°ì·¨Âð ÄãÖªµÀÄãµÄÄÇЩ¿ÕÊÇʲôÂð?ÖªµÀµÄ»°¾ÍºÃ°ì,NULL '' È«½Ç¿Õ¸ñ,TAB?? È«½Ç¿Õ¸ñ,TAB?? ¼ÙÈçÊÇÕâÁ½¸öµÄ»°£¬Ó¦¸ÃÔõô´¦ÀíÒýÓà ȫ½Ç¿Õ¸ñ,TAB?? ¼ÙÈçÊÇÕâÁ½¸öµÄ»°£¬Ó¦¸ÃÔõô´¦Àí ÄãÖ±½Ó´òѽ,»òREPLACEµô »¹ÊDz»Ã÷°×¡£ ÎÒÏÖÔÚÊÇÏëɾ³ýµôÕâЩ°¡ if (strlen($row['mpla']) <2) echo "¸ÃÊý¾ÝΪ¿Õ£¡";
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£ µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿ µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬ ×îºÃÓÐÔ´´úÂ룬лл Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º ½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ public static final DataBase.MAXSIZE=102 ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
ÇëÎÊÔÚmysqlµÄupdate triggerÖУ¬ÈçºÎ»ñÈ¡µ±Ç°Ö´ÐеÄsqlÓïÖеÄwhereÌõ¼þ£¬Ð»Ð» ÎÊÌâ±È½ÏÆæ¹Ö£¬ÎªÊ²Ã´ÒªÕâÑù£¿ ÔÚtriggerÖлñÈ¡µ½Óï¾äÒª×öÊ²Ã´ÄØ ÎÒµÄÕâ¸öupdate trigger¸üеÄÊÇmemcache£¬¶øÎÒ»¹Òª´Ómemcac ......