Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â¸´ÖÆMaster Master Slave¼Ü¹¹

ÎÒÃÇÓÃMaster-Slaves¼Ü¹¹½â¾öÁ˶ÁѹÁ¦±È½Ï´óµÄÓ¦Ó㬶øÎÒÃÇÓÃMaster-Master¼Ü¹¹½â¾öÁ˵¥µã·þÎñÎÊÌ⣬ÌṩÁËϵͳµÄ¿ÉÓÃÐÔ¡£µ«ÊÇÓÐʱÎÒÃÇÃæÁÙ¾Þ´óµÄ¶ÁÊý¾ÝѹÁ¦£¬ÌرðÊÇwebϵͳ£¬ÓÖÐèÒª½â¾öµ¥µã·þÎñµÄÎÊÌ⣬ΪӦÓÃÌṩ×ã¹»¸ßµÄ¿ÉÓÃÐÔ¡£ÕâʱÎÒÃǾÍÐèÒª½«ÕâÁ½Öּܹ¹½áºÏÆðÀ´¡£Õâ¾ÍÊÇMaster-Master-Slaves¼Ü¹¹¡£½á¹¹Í¼ÈçÏÂ
Maste ......

oracleÏòmysqlÒÆÖ²

ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËÆµÄ¶«Î÷À´×ö,ÈçÏ£º  
  create   table   myseq   ( &nb ......

mysql ³£Óú¯Êý

Ò»¡¢³£ÓÃ×Ö·û´®º¯Êý
1.CONCAT(str1,str2,...)
mysql> ? concat;
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL        ......

mysqlÖÐGROUP BY½áºÏGROUP_CONCATµÄʹÓà [ת]

http://javeye.javaeye.com/blog/558093
ÎÒÃÇÖªµÀ£¬group by¿ÉÒÔ½«sql²éѯ½á¹û°´ÕÕgroup byºóÃæÁнøÐзÖÀàÏÔʾ¡£±ÈÈ磺
Sql´úÂë
select
 columnA,columnB 
from
 
table
 
group
 
by
 columnA,columnB  
select columnA,columnB from table group by columnA,colum ......

¡¾×ª¡¿mysqlÏÂÈçºÎÖ´ÐÐsql½Å±¾

Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆÎªmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ