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

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


Ïà¹ØÎĵµ£º

MySQLÊý¾Ýµ¼Èëµ¼³öcsvÎļþÃüÁî

MySqlÊý¾Ý¿âµ¼³öcsvÎļþÃüÁ
mysql> select first_name,last_name,email from account into outfile 'e:\\output1.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';
csvÎļþЧ¹û£º



sunny
Grigoryan
lovechoosesun@gmail.com
Jon
Siegal
sun@riliantech.net
Joe
S ......

MySQLÊý¾ÝÀàÐÍ

ÊýÖµÀàÐÍ
¡¡¡¡MySQL
µÄÊýÖµÊý¾ÝÀàÐÍ¿ÉÒÔ´óÖ»®·ÖΪÁ½¸öÀà±ð£¬Ò»¸öÊÇÕûÊý£¬ÁíÒ»¸öÊǸ¡µãÊý»òСÊý¡£Ðí¶à²»Í¬µÄ×ÓÀàÐͶÔÕâЩÀà±ðÖеÄÿһ¸ö¶¼ÊÇ¿ÉÓõģ¬Ã¿¸ö×ÓÀàÐÍÖ§³Ö²»Í¬´óСµÄÊý¾Ý£¬²¢ÇÒ
MySQL ÔÊÐíÎÒÃÇÖ¸¶¨ÊýÖµ×Ö¶ÎÖеÄÖµÊÇ·ñÓÐÕý¸ºÖ®·Ö»òÕßÓÃÁãÌî²¹¡£
¡¡¡¡±íÁгöÁ˸÷ÖÖÊýÖµÀàÐÍÒÔ¼°ËüÃǵÄÔÊÐí·¶Î§ºÍÕ¼ÓõÄÄÚ´æ¿Õ¼ä¡£ ......

mysql Íü¼ÇROOTÃÜÂëµÄ¼òµ¥½â¾ö·½°¸

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:Á¬½ÓÊ±Ìø¹ýÊ ......

PHP PDO »ù´¡

 PHP PDO »ù´¡
http://blog.csdn.net/nailwl/archive/2009/10/27/4733655.aspx
PDOÊÇÒ»¸ö“Êý¾Ý¿â·ÃÎʳéÏó²ã”£¬×÷ÓÃÊÇͳһ¸÷ÖÖÊý¾Ý¿âµÄ·ÃÎʽӿڣ¬ÓëmysqlºÍmysqliµÄº¯Êý¿âÏà±È£¬PDOÈÿçÊý¾Ý¿âµÄʹÓøü¾ßÓÐÇ׺ÍÁ¦£»ÓëADODBºÍMDB2Ïà±È£¬PDO¸ü¸ßЧ¡£Ä¿Ç°¶øÑÔ£¬ÊµÏÖ“Êý¾Ý¿â³éÏó²ã”ÈÎÖØ¶øµÀÔ¶£¬Ê¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ