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

mysql5µÄ×Ö·û¼¯ºÍsql modeÎÊÌâ

http://hi.baidu.com/gushu/blog/item/3e821c174eabec064a90a7d4.html
mysql5Ìí¼ÓÁËһЩÐµĹ¦ÄܵĹæÔò£¬ÆäÖжԿªÔ´³ÌÐòÓ°Ïì±È½Ï´óµÄÓÐÁ½¸ö£¬Ò»¸öÊÇ4.0.12+¿ªÊ¼µÄ4²ã´Î×Ö·û¼¯£¬Ò»¸öÊÇ5.0.18¿ªÊ¼µÄĬÈÏstrict mode¡£
¶ÔÓÚÕâÁ½¸öÎÊÌ⣬ЧÂÊ×îºÃµÄ½â¾ö·½°¸£¬¾ÍÊÇÖ±½ÓÐÞ¸Ämy.ini
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=utf8
#ÕâÀï¸Ä³Éutf-8
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES£¬ NO_AUTO_CREATE_USER£¬ NO_ENGINE_SUBSTITUTION"
#ÕâÀï¸Ä³É=""
µ±ÄãûÓÐȨÏÞ½øÐÐÐÞ¸Äʱ£¬¾ÍÖ»ºÃÔÚ³ÌÐòÖÐÅжÏÁËmysql5 й¦ÄÜ£¬±ØÐëÔÚÿ´ÎÁ¬½ÓÉÏÊý¾Ý¿âʱ½øÐÐÉ趨¡£ÔÚʹÓÃÁËÊý¾Ý¿â³éÏó²ãµÄ³ÌÐòÖÐÐÞ¸ÄÆðÀ´Ò²ºÜ¼òµ¥£º
if(mysql_get_server_info( $connect ) > '4.0.1')
{
mysql_query( "set names 'utf8'" £¬ $connect );
}
if(mysql_get_server_info( $connect ) > '5.0.1')
{
mysql_query("SET sql_mode=''" £¬ $connect );
}


Ïà¹ØÎĵµ£º

SQL³£¼û²éѯÎÊÌâ(±à³Ì)


ÓÐЩ³£¼ûµÄÎÊÌâÔÚÂÛ̳Öв»¶Ï³öÏÖ£¬²»·ÁÕûÀíһϡ£
ÒÔÏÂÓï¾äÊÇÔÚSQLServer2005ÉÏʵÏֵģ¬Ò»Ð©Óï¾äÎÞ·¨ÔÚSS2000ÉÏÖ´ÐС£
ÓÐÓÃÖ¸ÊýÊÇÎÒ¸ù¾ÝÕâ¸öÎÊÌâµÄ³£¼û³Ì¶È´òµÄ·Ö£¬½ö¹©²Î¿¼¡£Êµ¼ÊÉÏ£¬µ±ÄãÓöµ½ÁËÕâ¸öÎÊÌ⣬Õâ¸öÎÊÌâÄÄÅÂÔÙÉÙ¼û£¬½â¾ö·½°¸Ò²ÊǷdz£ÓÐÓõġ£
1. Éú³ÉÈô¸ÉÐмǼ
ÓÐÓÃÖ¸Êý£º¡ï¡ï¡ï¡ï¡ï
³£¼ûµÄÎÊÌâÀàÐÍ£º¸ù ......

SQLÖÐisnullº¯ÊýµÄÓ÷¨

Óï·¨£º
   isnull(check_expression,replacement_expression)
²ÎÊýcheck_expressionÓëreplacement_expressionÀàÐÍÐèÏàͬ
·µ»ØÖµ£º
   Èôcheck_expressionΪnull£¬Ôò·µ»Øreplacement_expression
   Èôcheck_expression²»Îªnull£¬Ôò·µ»Øcheck_expression ......

mysql noinstall°æ°²×°

mysql noinstall°æ°²×°
1¡¢Èí¼þµÄÏÂÔØ
¡¡¡¡µ½mysqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØMySQLµÄ½âѹ°ü£¬Èçmysql-noinstall-5.0.51b-win32.zip
¡¡¡¡È»ºó½«Æä½âѹµ½ÄãÏ£ÍûÊý¾Ý¿âËùÔÚµÄij¸öλÖã¬ÈçC:\
¡¡¡¡ÕâÑùÔÚC:ÅÌÏÂÃæ¾ÍÓÐÁËC:\mysql-5.0.51b-win32ÕâÑùµÄÒ»¸öĿ¼£¬ÀïÃæ¾ÍÊÇMySQLÊý¾Ý¿âµÄÈ«²¿ÄÚÈÝ¡£
2¡¢ÅäÖÃ
¡¡¡¡Ê×ÏÈÎÒÃÇÀ´¿´MySQLµÄ¸ùĿ ......

MySQL³ÌÐòÆÊÎö£¨Profiling£©

ÎÒÃǽ«ÒªÏêϸµÄ½²µ½MySQLµÄÆÊÎö(Profiling),ÒòΪËüºÜÉÙÒÀÀµÓÚÄãµÄÓ¦Óá£Ó¦ÓúͷþÎñÆ÷¼¶±ðµÄÆÊÎöÓеÄʱºò¶¼ÊÇÓбØÒªµÄ¡£ËäȻӦÓü¶±ðµÄÆÊÎö¿ÉÒÔ¸øÄãÕû¸öÓ¦ÓÃÐÔÄܵÄ×ÜÀ¿¡££¬µ«ÊǶÔMySQLµÄÆÊÎöÌṩÁËÐÅÏ¢ÊÇ·þÎñÆ÷¼¶±ðËùÌṩ²»Á˵ġ£±ÈÈ磬¶ÔPHP´úÂë½øÐÐÆÊÎö²»»áÏÔʾMySQLÓжàÉÙÐÐÓï¾äÖ´ÐÐÁË¡£
 
ÓëÓ¦ÓÃÆÊÎöÒ»Ñù£¬Ä¿±êÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ