PHP·ÃÎÊMySQLÊý¾Ý¿â
PHPÊÖ²áÉÏÌṩÁËÒÔÏÂһЩÖ÷ÒªµÄmysqlÊý¾Ý¿âµÄÖ§³Öº¯Êý£º
mysql_affected_rows -- È¡µÃǰһ´Î MySQL ²Ù×÷ËùÓ°ÏìµÄ¼Ç¼ÐÐÊý
mysql_change_user -- ¸Ä±ä»î¶¯Á¬½ÓÖеǼµÄÓû§
mysql_client_encoding -- ·µ»Ø×Ö·û¼¯µÄÃû³Æ
mysql_close -- ¹Ø±Õ MySQL Á¬½Ó
mysql_connect -- ´ò¿ªÒ»¸öµ½ MySQL ·þÎñÆ÷µÄÁ¬½Ó
mysql_create_db -- н¨Ò»¸ö MySQL Êý¾Ý¿â
mysql_data_seek -- ÒÆ¶¯ÄÚ²¿½á¹ûµÄÖ¸Õë
mysql_db_name -- È¡µÃ½á¹ûÊý¾Ý
mysql_db_query -- ·¢ËÍÒ»Ìõ MySQL ²éѯ
mysql_drop_db -- ¶ªÆú£¨É¾³ý£©Ò»¸ö MySQL Êý¾Ý¿â
mysql_errno -- ·µ»ØÉÏÒ»¸ö MySQL ²Ù×÷ÖеĴíÎóÐÅÏ¢µÄÊý×Ö±àÂë
mysql_error -- ·µ»ØÉÏÒ»¸ö MySQL ²Ù×÷²úÉúµÄÎı¾´íÎóÐÅÏ¢
mysql_escape_string -- תÒåÒ»¸ö×Ö·û´®ÓÃÓÚ mysql_query
mysql_fetch_array -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊ¹ØÁªÊý×飬»òÊý×ÖÊý×飬»ò¶þÕß¼æÓÐ
mysql_fetch_assoc -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊ¹ØÁªÊý×é
mysql_fetch_field -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÁÐÐÅÏ¢²¢×÷Ϊ¶ÔÏó·µ»Ø
mysql_fetch_lengths -- È¡µÃ½á¹û¼¯ÖÐÿ¸öÊä³öµÄ³¤¶È
mysql_fetch_object -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊ¶ÔÏó
mysql_fetch_row -- ´Ó½á¹û¼¯ÖÐÈ¡µÃÒ»ÐÐ×÷Ϊö¾ÙÊý×é
mysql_field_flags -- ´Ó½á¹ûÖÐÈ¡µÃºÍÖ¸¶¨×ֶιØÁªµÄ±êÖ¾
mysql_field_len -- ·µ»ØÖ¸¶¨×ֶεij¤¶È
mysql_field_name -- È¡µÃ½á¹ûÖÐÖ¸¶¨×ֶεÄ×Ö¶ÎÃû
mysql_field_seek -- ½«½á¹û¼¯ÖеÄÖ¸ÕëÉè¶¨ÎªÖÆ¶¨µÄ×Ö¶ÎÆ«ÒÆÁ¿
mysql_field_table -- È¡µÃÖ¸¶¨×Ö¶ÎËùÔڵıíÃû
mysql_field_type -- È¡µÃ½á¹û¼¯ÖÐÖ¸¶¨×ֶεÄÀàÐÍ
mysql_free_result -- ÊͷŽá¹ûÄÚ´æ
mysql_get_client_info -- È¡µÃ MySQL ¿Í»§¶ËÐÅÏ¢
mysql_get_host_info -- È¡µÃ MySQL Ö÷»úÐÅÏ¢
mysql_get_proto_info -- È¡µÃ MySQL ÐÒéÐÅÏ¢
mysql_get_server_info -- È¡µÃ MySQL ·þÎñÆ÷ÐÅÏ¢
mysql_info -- È¡µÃ×î½üÒ»Ìõ²éѯµÄÐÅÏ¢
mysql_insert_id -- È¡µÃÉÏÒ»²½ INSERT ²Ù×÷²úÉúµÄ ID
mysql_list_dbs -- Áгö MySQL ·þÎñÆ÷ÖÐËùÓеÄÊý¾Ý¿â
mysql_list_fields -- Áгö MySQL ½á¹ûÖеÄ×Ö¶Î
mysql_list_processes -- Áгö MySQL ½ø³Ì
mysql_list_tables -- Áгö MySQL Êý¾Ý¿âÖеıí
mysql_num_fields -- È¡µÃ½á¹û¼¯ÖÐ×ֶεÄÊýÄ¿
mysql_num_rows -- È¡µÃ½á¹û¼¯ÖÐÐеÄÊýÄ¿
mysql_pconnec
Ïà¹ØÎĵµ£º
1.Í£µômysqld
service mysqld stop
2.ÖØÆômysqld£¬Ö¸¶¨²ÎÊý
service mysqld start --skip-networking --skip-grant-tables
»òÕß
/opt/mysql/bin/mysqld_safe --skip-networking --skip-grant-tables &
/opt/mysql/ÊÇÎÒµÄMYSQL°²×°Â·¾¶
skip-grant-tables:Á¬½ÓÊ±Ìø¹ýÊ ......
1.MySQL¼ò½é
MySQLÊÇÒ»¸ö¹ã·ºÊ¹ÓõĽṹ»¯²éѯÓïÑÔ£¨SQL£©Êý¾Ý¿â·þÎñÆ÷¡£ºÍÆäËûSQL·þÎñÆ÷Ò»Ñù£¬MySQLÌṩÁË·ÃÎʺ͹ÜÀíSQLÊý¾Ý¿âµÄ·½·¨£¬µ«ÊÇ£¬MySQLͬʱҲÌṩÁË´´½¨Êý¾Ý¿â½á¹¹ÒÔ¼°ÔÚÕâЩ½á¹¹ÖÐÌí¼Ó¡¢Ð޸ĺÍɾ³ýÕâЩ½á¹¹µÄ¹¤¾ß¡£
MySQLÊý¾Ý¿âÏà¹ØµÄÈí¼þ°üÖ÷ÒªÓÐÒÔϼ¸ÖÖ£º
......
Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆÎªmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......
function handleEach(&$array,$functionName)
{
foreach($array as $k=>$v)
{
if(is_array($v))
{
handleEach(&$array[$k],$functionName);
}
else
$array[$k] = $functionName($v);
return $array[$k];
}
} ......