mysqlµÄnullÎÊÌâ - PHP / »ù´¡±à³Ì
×Ö¶Î `customer_age` int(11) default NULL µ±Ò³Ãæ²»ÊäÈëÄêÁäʱ£¬$ageʵ¼ÊÊÇ¿Õ×Ö·û ¾ÍÊÇ$age==""; ´Ëʱ²åÈë Êý¾Ý¿â¸ÃÏîΪ0 ÔÚphpÀïÉè$age=NULL; ´Ëʱ²åÈë Êý¾Ý¿â¸ÃÏîΪ0 ÏëÖªµÀ£¬Èç¹û´Óphp²åÈëµÄ»°£¬ÔõôÑùÉèÖÃ$ageµÄÖµ´Ó¶øÊ¹Êý¾Ý¿â¸ÃÏîΪnull?²»ÖªµÀÕâÑù¿É²»¿ÉÄÜ µ±È»Ö±½Ó¸Äдsql¾äÊÇ¿ÉÒԵģ¬¿ÉÄÇÑùµÄ»°¾ÍÒªÅжÏ$ageÖ®ºóд2ÌõsqlÓï¾äµÄ·ÖÖ§ÁË¡£
¿ÉÄÇÑùµÄ»°¾ÍÒªÅжÏ$ageÖ®ºóд2ÌõsqlÓï¾äµÄ·ÖÖ§ÁË =========================================== ÄѵÀ²»ÄÜд³ÉÒ»ÌõÂð£¿ÒýÓà ¿ÉÄÇÑùµÄ»°¾ÍÒªÅжÏ$ageÖ®ºóд2ÌõsqlÓï¾äµÄ·ÖÖ§ÁË =========================================== ÄѵÀ²»ÄÜд³ÉÒ»ÌõÂ𣿠ÕâÕýÊÇÎÒµÄÒÉÎʰ¡ д³É1ÌõµÄ»°£¬ÔÚÊäÈëΪ¿Õʱ¾ÍÒª¶Ô$age¸³ÖµÒÔ´ïµ½²åÈënullµÄÄ¿µÄ°¡ µ± $age Ϊ¿Õʱ£¬²»¶Ô customer_age Ö´ÐвåÈ붯×÷ ¼´ customer_age ²»³öÏÖÔÚ²åÈëÁбíÖÐ Èç¹ûÄãÊǸù¾Ý±íµ¥¶¯Ì¬¹¹Ôì sql ´®£¬ÄÇô¾ÍºÜÈÝÒ××öµ½ÁË ÓбØÒª·ÇNULLô£¿Äã·Ç¿ÕÏÔʾµÄʱºò¿ÉÒÔ×ö¸öÅжϰ¡£¬±ÈÈçNULL||""¾ÍÊä³öʲô Ä¿µÄÊÇ¿ÉÒÔ´ïµ½µÄ£¬ Ö»ÊÇÏëÖªµÀÄܲ»ÄÜÖ±½Óͨ¹ý¶Ô$ageÉèÖµµÄ·½Ê½£¬sqlÓï¾ä¾ÍдһÌõ£¬À´²åÈënull¡£ ¿´À´ÊDz»¿ÉÄÜµÄ Ð»Ð»
Ïà¹ØÎÊ´ð£º
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡 ÊÖ²áºÜÖØÒªµÄàÞ£¡~ ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£ È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
ĿǰÔÚÎ人ÕÒ¹¤×÷ ·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü »¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³ Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
ÇëÎÊ Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£» ·þÎñÆ÷Ãû£º Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿ ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡ Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿ ÒýÓà ÇëÎÊ ......
mssql_select_db("f1",mssql_connect("localhost","sa","sa")); mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿ 2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......