ÅжÏMySQLÁ¬½ÓÊÇ·ñÓÐЧ
²Î¼û¹Ù·½²Î¿¼£¬µÚ25Õ£ºAPIºÍ¿â
25.2.3.49. mysql_ping()
int
mysql_ping(MYSQL *mysql)
ÃèÊö
¼ì²éÓë·þÎñÆ÷µÄÁ¬½ÓÊÇ·ñ¹¤×÷¡£Èç¹ûÁ¬½Ó¶ªÊ§£¬½«×Ô¶¯³¢ÊÔÔÙÁ¬½Ó¡£
¸Ãº¯Êý¿É±»ÏÐÖÃÁ˽ϳ¤Ê±¼äµÄ¿Í»§¶ËʹÓã¬ÓÃÒÔ¼ì²é·þÎñÆ÷ÊÇ·ñÒѹرÕÁËÁ¬½Ó£¬²¢ÔÚ±ØҪʱÔÙ´ÎÁ¬½Ó¡£
·µ»ØÖµ
Èç¹ûÓë·þÎñÆ÷µÄÁ¬½ÓÓÐЧ·µ»Ø0
¡£Èç¹û³öÏÖ´íÎ󣬷µ»Ø·Ç0
Öµ¡£·µ»ØµÄ·Ç0
Öµ²»±íʾMySQL
·þÎñÆ÷±¾ÉíÊÇ·ñÒѹرգ¬Á¬½Ó¿ÉÄÜÒòÆäËûÔÒòÖնˣ¬ÈçÍøÂçÎÊÌâµÈ¡£
´íÎó
·
CR_COMMANDS_OUT_OF_SYNC
ÒÔ²»Ç¡µ±µÄ˳ÐòÖ´ÐÐÁËÃüÁî¡£
·
CR_SERVER_GONE_ERROR
MySQL
·þÎñÆ÷²»¿ÉÓá£
·
CR_UNKNOWN_ERROR
³öÏÖδ֪´íÎó¡£
MySQL-pythonÖÐÓë¸ÃAPI¶ÔÓ¦µÄÊÇconn.ping()
Ïà¹ØÎĵµ£º
LAMPÕâ¸ö´ÊµÄÓÉÀ´×îÔçʼÓڵ¹úÔÓÖ¾“c't Magazine”£¬Michael KunzeÔÚ1990Äê×îÏÈ°ÑÕâЩÏîÄ¿×éºÏÔÚÒ»Æð´´ÔìÁËLAMPµÄËõд×Ö¡£ÕâЩ×é¼þËäÈ»²¢²»ÊÇ¿ª¿ªÊ¼¾ÍÉè¼ÆΪһÆðʹÓõģ¬µ«ÊÇ£¬ÕâЩ¿ªÔ´Èí¼þ¶¼¿ÉÒԺܷ½±ãµÄËæʱ»ñµÃ²¢Ãâ·Ñ»ñµÃ¡£Õâ¾Íµ¼ÖÂÁËÕâЩ×é¼þ¾³£ÔÚÒ»ÆðʹÓá£ÔÚ¹ýÈ¥µÄ¼¸ÄêÀÕâЩ×é¼þµÄ¼æÈÝÐÔ²»¶ÏÍêÉÆ£¬Ô ......
½¨Á¢Ìõ¼þÊ×ÏÈÒ»¶¨ÒªÈ·¶¨×Ô¼ºµÄmysql£¬tomcat,eclipseÁ¬½ÓÊÇÕýÈ·µÄ¡£
index.jspºÜ¼òµ¥£¬¾ÍÒ»¸öÌøת¡£
<%
response.sendRedirect("lg.jsp");
%>
lg.jsp ʵÏֵǼ¿ò¼Ü
<%@ page contentType="text/html; charset=utf-8" %>
<html>
<head>
<title>
login
</title>
</hea ......
ËäȻ˵°²×°·½±ãжÔØ·½±ã¡£¡£
µ«ÊÇжÔغó°²×°»òÕßÉý¼¶ºó»áÌáʾ·þÎñÆô¶¯²»ÁË£¬½â¾ö·½·¨ÈçÏÂ
жÔØËü
cmdÏ£¬sc deleteÃüÁî ÓÃÀ´É¾³ý·þÎñµÄ
×¢²á±í²éÕÒmysql ×¢Òâ²»Òª°Ñϵͳ¼üɾ³ýÁË
ɾ³ýÊý¾ÝÎļþ¼Ð£¬°üÀ¨Êý¾Ý¿âµÄºÍ»º´æµÄ
ÕâÑù¶¼²»ÐеĻ°£¬Äã¾Í¸ÄÒ»¸ö·þÎñÃû°É¡£¡£¡£¡£
ÄïµÄ¡£¡£
MySQLµÄ³õ¼¶Ê¹ÓÃ
ln -s /usr/local/mys ......
MySQLÖи÷ÖÖ×ֶεÄÈ¡Öµ·¶Î§
ʱ¼ä:2005-09-29 20:59:14 À´Ô´:techtarget.com.cn ×÷Õß:techtarget.com.cn
¡¡¡¡TINYINT
¡¡¡¡-128 - 127
¡¡¡¡TINYINT UNSIGNED
¡¡¡¡0 - 255
¡¡¡¡SMALLINT
¡¡¡¡-32768 - 32767
¡¡¡¡SMALLINT UNSIGNED
¡¡¡¡0 - 65535
¡¡¡¡MEDIUMINT
¡¡¡¡-8388608 - 83886 ......
1.ʲôÊÇUDF? UDF(user-defined function)ÊÇmysqlΪÓû§ÌṩµÄ×Ô¶¨Ò庯ÊýµÄÀ©Õ¹½Ó¿Ú¡£Ëü±¾ÖÊÉϺÍmysqlÌṩµÄmax¡¢minºÍcountµÈº¯ÊýÀàËÆ¡£ 2.UDF¿ÉÒÔ×öʲô? UDFÊÇ×Ô¶¨Ò庯Êý£¬ËùÒÔËüÄÜ×öʲôÍêÈ«È¡¾öÓÚÄãµÄʵÏÖ¡£UDF¿ÉÒÔÔÚÆÕͨµÄsql¡¢triggerÒÔ¼°store procedure±»µ÷ÓᣠÈç¹û×Ô¶¨ÒåÒ»¸ötcp_send(ip,port,msg)µ ......