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

mysql±¨´í

±¨´í£º
 /tmp/ccBBJEB8.o: In function `ping_sql':
pingsql.c:(.text+0x7c): undefined reference to `mysql_init'
pingsql.c:(.text+0xe1): undefined reference to `mysql_real_connect'
pingsql.c:(.text+0xff): undefined reference to `mysql_close'
pingsql.c:(.text+0x119): undefined reference to `mysql_connect'
pingsql.c:(.text+0x198): undefined reference to `mysql_real_escape_string'
collect2: ld ·µ»Ø 1
½â¾ö°ì·¨£º
#gcc -o pingsql pingsql.c -lmysqlclient -I/usr/local/mysql/include/mysql/ -L/usr/local/mysql/lib/mysql


Ïà¹ØÎĵµ£º

Êý¾Ý¿â»ù´¡£ºMySQL Ìí¼ÓÓû§µÄÁ½ÖÖ·½·¨

 
ÓÐ2¸ö²»Í¬µÄ·½·¨Ôö¼ÓÓû§£ºÍ¨¹ýʹÓÃGRANTÓï¾ä»òͨ¹ýÖ±½Ó²Ù×÷MySQLÊÚȨ±í¡£±È½ÏºÃµÄ·½·¨ÊÇʹÓÃGRANTÓï¾ä£¬ÒòΪËûÃÇÊǸü¼òÃ÷²¢ÇÒºÃÏñ´íÎóÉÙЩ¡£
 
ÏÂÃæµÄÀý×ÓÏÔʾ³öÈçºÎʹÓÃMySQL¿Í»§°²×°ÐÂÓû§¡£ÕâЩÀý×Ó¼Ù¶¨È¨ÏÞÒÑȱʡ±»°²×°¡£ÕâÒâζ
×ÅΪÁ˸ı䣬Äã±ØÐëÔÚMySQLÕýÔÚÔËÐÐͬһ̨»úÆ÷ÉÏ£¬Äã±ØÐë×÷ΪMySQL
ro ......

ͨ¹ýshow status À´ÓÅ»¯MySQLÊý¾Ý¿â

 
2009Äê10ÔÂ30ÈÕ ÐÇÆÚÎå 22:53
1, ²é¿´MySQL
·þÎñÆ÷ÅäÖÃÐÅÏ¢
mysql> show variables;
mysql> show variables;
2, ²é¿´MySQL·þÎñÆ÷ÔËÐеĸ÷ÖÖ״ֵ̬
mysql> show global status;
mysql> show global status;
3, Âý²éѯ
mysql> show variables like '%slow%';  
+--------------- ......

MySQLʹÓü¼ÇÉÐĵÃ

 
2009Äê10ÔÂ30ÈÕ ÐÇÆÚÎå 22:53
ÓÃmysql
ÄÚÖú¯Êýת»»ipµØÖ·ºÍÊý×Ö
ÀûÓÃÁ½¸öÄÚÖú¯Êý
inet_aton:½«ipµØÖ·×ª»»³ÉÊý×ÖÐÍ
inet_ntoa:½«Êý×ÖÐÍת»»³ÉipµØÖ·
³ä·ÖÀûÓÃmysqlÄÚÖõÄ
format
º¯Êý
ÓÈÆäÊÇÔÚ´¦Àí×Ö·û¸ñʽµÄʱºò,ÀýÈ罫12345ת»»³É12,345ÕâÑùµÄ,Ö»ÒªÓÃ:format(12345,0)¼´¿É,Èç¹ûÓÃformat(12345,2)ÔòÏÔÊ ......

MYSQL¸´ÖƵļ¸ÖÖģʽ

 MySQL 5.1 ÖУ¬ÔÚ¸´ÖÆ·½ÃæµÄ¸Ä½ø¾ÍÊÇÒý½øÁËеĸ´ÖƼ¼Êõ£º»ùÓÚÐеĸ´ÖÆ¡£
MYSQL¸´ÖƵļ¸ÖÖģʽ
MySQL 5.1 ÖУ¬ÔÚ¸´ÖÆ·½ÃæµÄ¸Ä½ø¾ÍÊÇÒý½øÁËеĸ´ÖƼ¼Êõ£º»ùÓÚÐеĸ´ÖÆ¡£
¼òÑÔÖ®£¬ÕâÖÖм¼Êõ¾ÍÊǹØ×¢±íÖз¢Éú±ä»¯µÄ¼Ç¼£¬¶ø·ÇÒÔǰµÄÕÕ³­ binlog ģʽ¡£
´Ó MySQL 5.1.12 ¿ªÊ¼£¬¿ÉÒÔÓÃÒÔÏÂÈýÖÖģʽÀ´ÊµÏÖ£º
-- »ùÓÚ ......

PHPÖÐmysql_fetch_array()ºÍmysql_fetch_row()µÄÇø±ð

 ×î½üÔÚ×öPHPÓëÊý¾Ý¿â½»»¥µÄproject£¬¼±ÓÚÇó³É£¬Ä£·ÂÁËÏÂÀý×ӾͿªÊ¼¶¯ÊÖ£¬½á¹ûÎó°Ñmysql_fetch_arrayд³ÉÁËmysql_fetch_row,囧ÊÂÀ´ÁË£¬·¢ÏÖ·µ»ØµÄÊý×é¾ÓÈ»ÊÇindex=>valueµÄÐÎʽ£¬¶øÃ÷Ã÷¼ÇµÃÊÇfield name=>valueµÄ¹þ£¬²éÊÖ²á²ÅÃ÷°×¡£
1. mysql_fetch_arrayµÄº¯ÊýÔ­ÐÍÊÇ
array mysql_fetch_array ( resour ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ