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

ÅжÏ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()


Ïà¹ØÎĵµ£º

Linux+Apache+Mysql+PHPÓÅ»¯¼¼ÇÉ


LAMPÕâ¸ö´ÊµÄÓÉÀ´×îÔçʼÓڵ¹úÔÓÖ¾“c't Magazine”£¬Michael KunzeÔÚ1990Äê×îÏÈ°ÑÕâЩÏîÄ¿×éºÏÔÚÒ»Æð´´ÔìÁËLAMPµÄËõд×Ö¡£ÕâЩ×é¼þËäÈ»²¢²»ÊÇ¿ª¿ªÊ¼¾ÍÉè¼ÆΪһÆðʹÓõģ¬µ«ÊÇ£¬ÕâЩ¿ªÔ´Èí¼þ¶¼¿ÉÒԺܷ½±ãµÄËæʱ»ñµÃ²¢Ãâ·Ñ»ñµÃ¡£Õâ¾Íµ¼ÖÂÁËÕâЩ×é¼þ¾­³£ÔÚÒ»ÆðʹÓá£ÔÚ¹ýÈ¥µÄ¼¸ÄêÀÕâЩ×é¼þµÄ¼æÈÝÐÔ²»¶ÏÍêÉÆ£¬Ô ......

jsp—MySqlÖÆ×÷B/sµÇ½µÄºÃÀý×Ó Ñ§Ï°±Ê¼Ç

½¨Á¢Ìõ¼þÊ×ÏÈÒ»¶¨ÒªÈ·¶¨×Ô¼ºµÄmysql£¬tomcat,eclipseÁ¬½ÓÊÇÕýÈ·µÄ¡£
index.jspºÜ¼òµ¥£¬¾ÍÒ»¸öÌøת¡£
<%
response.sendRedirect("lg.jsp");
%>
lg.jsp ʵÏֵǼ¿ò¼Ü
<%@ page contentType="text/html; charset=utf-8" %>
<html>
<head>
<title>
login
</title>
</hea ......

MySQL °²×° (»ù±¾²Ù×÷)

ËäȻ˵°²×°·½±ãжÔØ·½±ã¡£¡£
µ«ÊÇжÔغó°²×°»òÕßÉý¼¶ºó»áÌáʾ·þÎñÆô¶¯²»ÁË£¬½â¾ö·½·¨ÈçÏÂ
жÔØËü
cmdÏ£¬sc deleteÃüÁî ÓÃÀ´É¾³ý·þÎñµÄ
×¢²á±í²éÕÒmysql ×¢Òâ²»Òª°Ñϵͳ¼üɾ³ýÁË
ɾ³ýÊý¾ÝÎļþ¼Ð£¬°üÀ¨Êý¾Ý¿âµÄºÍ»º´æµÄ
ÕâÑù¶¼²»ÐеĻ°£¬Äã¾Í¸ÄÒ»¸ö·þÎñÃû°É¡£¡£¡£¡£
ÄïµÄ¡£¡£
MySQLµÄ³õ¼¶Ê¹ÓÃ
ln -s /usr/local/mys ......

MySQL ×Ö¶ÎÀàÐÍ×ܽá

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 ......

mysql UDF+triggerµÄÉñÆæħÁ¦

  1.ʲôÊÇUDF? UDF(user-defined function)ÊÇmysqlΪÓû§ÌṩµÄ×Ô¶¨Ò庯ÊýµÄÀ©Õ¹½Ó¿Ú¡£Ëü±¾ÖÊÉϺÍmysqlÌṩµÄmax¡¢minºÍcountµÈº¯ÊýÀàËÆ¡£ 2.UDF¿ÉÒÔ×öʲô? UDFÊÇ×Ô¶¨Ò庯Êý£¬ËùÒÔËüÄÜ×öʲôÍêÈ«È¡¾öÓÚÄãµÄʵÏÖ¡£UDF¿ÉÒÔÔÚÆÕͨµÄsql¡¢triggerÒÔ¼°store procedure±»µ÷ÓᣠÈç¹û×Ô¶¨ÒåÒ»¸ötcp_send(ip,port,msg)µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ