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

mysql ´´½¨º¯ÊýµÄ1418´íÎó½â¾ö·½°¸

 Error Code : 1418
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
(0 ms taken)
·ÖÎö£º
¸ù¾ÝϵͳÌáʾ£¬µ¼Ö¸ôíÎóµÄÔ­Òò¿ÉÄÜÊÇÒ»¸ö°²È«ÉèÖ÷½ÃæµÄÅäÖ㬲éÊÖ²álog_bin_trust_function_creators²ÎÊýȱʡ0£¬ÊDz»ÔÊÐífunctionµÄͬ²½µÄ£¬Ò»°ãÎÒÃÇÔÚÅäÖÃrepliactionµÄʱºò£¬¶¼Íü¼Ç¹Ø×¢Õâ¸ö²ÎÊý£¬ÕâÑùÔÚmaster¸üÐÂfuntionºó£¬slave¾Í»á±¨¸æ´íÎó£¬È»ºóslave stoped¡£
´¦Àí¹ý³Ì£º
µÇ½mysqlÊý¾Ý¿â
> set global log_bin_trust_function_creators £½ 1;
> start slave;
¸ú×ÙmysqlµÄÆô¶¯ÈÕÖ¾£¬slaveÕý³£ÔËÐУ¬ÎÊÌâ½â¾ö¡£


Ïà¹ØÎĵµ£º

OracleµÄNVL()º¯ÊýºÍMySQLÖеÄIfNull()º¯Êý

MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ  ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......

MySQL Master Slave Replication

MySQL±¾ÉíûÓÐÌṩreplication failoverµÄ½â¾ö·½°¸(¼ûHow can I use replication to provide redundancy or high availability?)
ÈçºÎʹReplication·½°¸¾ßÓÐHA£¿
´ð°¸ÊÇMMM(MySQL Master-Master Replication Manager)
MMM¶ÔMySQL Master-Slave Replication¾ø¶ÔÊÇÒ»¸öºÜÓÐÒæµÄ²¹³ä!
ÒýÑÔ
Master-SlaveµÄÊý¾Ý¿â»ú¹¹ ......

RedhatÏ Apache, php, mysqlµÄĬÈϰ²×°Â·¾¶

apache:
Èç¹û²ÉÓÃRPM°ü°²×°£¬°²×°Â·¾¶Ó¦ÔÚ /etc/httpdĿ¼ÏÂ
apacheÅäÖÃÎļþ:/etc/httpd/conf/httpd.conf
ApacheÄ£¿é·¾¶£º/usr/sbin/apachectl
webĿ¼:/var/www/html
Èç¹û²ÉÓÃÔ´´úÂë°²×°£¬Ò»°ãĬÈϰ²×°ÔÚ/usr/local/apache2Ŀ¼ÏÂ
php:
Èç¹û²ÉÓÃRPM°ü°²×°£¬°²×°Â·¾¶Ó¦ÔÚ /etc/Ŀ¼ÏÂ
phpµÄÅäÖÃÎļþ:/etc/php.ini ......

½â¾öÖÐÎÄ´æÈëMySql³öÏÖÂÒÂëÎÊÌâ

½â¾ö°ì·¨£ºÔÚÁ¬½Ó×Ö·û´®ÖÐ˵Ã÷Á¬½Ó×Ö·ûµÄÊôÐÔ£¬È磺
    <add name="server_mysql" connectionString="server=127.0.0.1;user id=root; password=123; database=baiduemail; pooling=false;charset=gbk"/>
»òÕßÊÇ;charset=gb2312
ÁíÍâ×¢Ò⣺ÔÚ´´½¨mysqlÊý¾Ý¿âµÄ±íµÄʱºòÑ¡Ôñ±àÂ뼯gbk ......

mysql С¼¼ÇÉ£¬×Ö·û¼¯£¬»·¾³±äÁ¿

Ò»¡¢MySql£¬ÓÃcmdÃüÁîÌáʾÐÐÁ¬½ÓÊý¾Ý¿â£¬·¢ÏÖ²éѯÊý¾Ý¿âÖеÄÖÐÎijöÏÖÂÒÂ룬¶øÊý¾Ý¿âÀïÃæ´æµÄÊÇutf8£¬¶¼ÊÇÕýÈ·µÄ
ÓÚÊÇÉÏÍøËÑË÷һϣ¬
ÕÒµ½Ïà¹ØÉèÖ÷½·¨ÈçÏ¡£
1¡¢MySQLÊÇÓÐһЩ»·¾³±äÁ¿¿ÉÒÔÉèÖã¬
¿ÉÊäÈ룺show variables;¿É²é¿´µ±Ç°µÄ»·¾³±äÁ¿ÉèÖã»
2¡¢ÕâЩ±äÁ¿µ±ÖÐÓÐÒ»²¿·ÖÓë×Ö·ûÏà¹ØµÄÉèÖã¬
¿ÉÊäÈ룺show variabl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ