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

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 »ñÈ¡Ò³ÃæÄÚÈÝ - PHP / »ù´¡±à³Ì

Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

ÕÒ¹¤×÷ºÍ¶Ô¸ÕѧPHPµÄÅóÓѵÄÖÒ¸æ - PHP / ¿ªÔ´×ÊÔ´

ĿǰÔÚÎ人ÕÒ¹¤×÷  
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

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)ÖеÄÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ