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

MySQL 3.23 ÖÐÎIJο¼ÊÖ²á

mysql_affected_rows() ·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£ 
mysql_close() ¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£ 
mysql_connect() Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£ 
mysql_change_user() ¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£ 
mysql_create_db() ´´½¨Ò»¸öÊý¾Ý¿â¡£¸Ãº¯Êý²»ÍƼö£»¶øÊ¹ÓÃSQLÃüÁîCREATE DATABASE¡£ 
mysql_data_seek() ÔÚÒ»¸ö²éѯ½á¹û¼¯ºÏÖÐËÑѰһÈÎÒâÐС£ 
mysql_debug() Óøø¶¨×Ö·û´®×öÒ»¸öDBUG_PUSH¡£ 
mysql_drop_db() ÅׯúÒ»¸öÊý¾Ý¿â¡£¸Ãº¯Êý²»ÍƼö£»¶øÊ¹ÓÃSQLÃüÁîDROP DATABASE¡£ 
mysql_dump_debug_info() È÷þÎñÆ÷½«µ÷ÊÔÐÅϢдÈëÈÕÖ¾Îļþ¡£ 
mysql_eof() È·¶¨ÊÇ·ñÒѾ­¶Áµ½Ò»¸ö½á¹û¼¯ºÏµÄ×îºóÒ»ÐС£Õ⹦Äܱ»·´¶Ô; mysql_errno()»òmysql_error()¿ÉÒÔÏà·´±»Ê¹Óᣠ
mysql_errno() ·µ»Ø×î½ü±»µ÷ÓõÄMySQLº¯ÊýµÄ³ö´í±àºÅ¡£ 
mysql_error() ·µ»Ø×î½ü±»µ÷ÓõÄMySQLº¯ÊýµÄ³ö´íÏûÏ¢¡£ 
mysql_escape_string() ÓÃÔÚSQLÓï¾äÖеÄ×Ö·û´®µÄתÒåÌØÊâ×Ö·û¡£ 
mysql_fetch_field() ·µ»ØÏÂÒ»¸ö±í×ֶεÄÀàÐÍ¡£ 
mysql_fetch_field_direct () ·µ»ØÒ»¸ö±í×ֶεÄÀàÐÍ£¬¸ø³öÒ»¸ö×ֶαàºÅ¡£ 
mysql_fetch_fields() ·µ»ØÒ»¸öËùÓÐ×ֶνṹµÄÊý×é¡£ 
mysql_fetch_lengths() ·µ»Øµ±Ç°ÐÐÖÐËùÓÐÁеij¤¶È¡£ 
mysql_fetch_row() ´Ó½á¹û¼¯ºÏÖÐÈ¡µÃÏÂÒ»ÐС£ 
mysql_field_seek() °ÑÁйâ±ê·ÅÔÚÒ»¸öÖ¸¶¨µÄÁÐÉÏ¡£ 
mysql_field_count() ·µ»Ø×î½ü²éѯµÄ½á¹ûÁеÄÊýÁ¿¡£ 
mysql_field_tell() ·µ»ØÓÃÓÚ×îºóÒ»¸ömysql_fetch_field()µÄ×ֶιâ±êµÄλÖᣠ
mysql_free_result() ÊÍ·ÅÒ»¸ö½á¹û¼¯ºÏʹÓõÄÄÚ´æ¡£ 
mysql_get_client_info() ·µ»Ø¿Í»§°æ±¾ÐÅÏ¢¡£ 
mysql_get_host_info() ·µ»ØÒ»¸öÃèÊöÁ¬½ÓµÄ×Ö·û´®¡£ 
mysql_get_proto_info() ·µ»ØÁ¬½ÓʹÓõÄЭÒé°æ±¾¡£ 
mysql_get_server_info() ·µ»Ø·þÎñÆ÷°æ±¾ºÅ¡£ 
mysql_info() ·µ»Ø¹ØÓÚ×î½üÖ´ÐеòéѯµÄÐÅÏ¢¡£ 
mysql_init() »ñµÃ»ò³õʼ»¯Ò»¸öMYSQL½á¹¹¡£ 
mysql_insert_id() ·µ»ØÓÐǰһ¸ö²éѯΪһ¸öAUTO_INCREMENTÁÐÉú³ÉµÄID¡£ 
mysql_kill() ɱËÀÒ»¸ö¸ø¶¨µÄÏ̡߳£ 
mysql_list_dbs() ·µ»ØÆ¥ÅäÒ»¸ö¼òµ¥µÄÕýÔò±í´ïʽµÄÊý¾Ý¿âÃû¡£ 
mysql_list_fields() ·µ»ØÆ¥ÅäÒ»¸ö¼òµ¥µÄÕýÔò±í´ïʽµ


Ïà¹ØÎĵµ£º

mysql¹ØÓÚÍøÉÏÁ÷תµÄ£¬Éú³É£³£¬£¶Ö®¼äµÄËæ»úÕûÊý

Èç¹ûÄãËÑË÷GOOGLE£¬Äã»áÕÒµ½ºÜ¶à¹ØÓÚmysqlµÄËæ»úÊý£¬ËûÃÇ»áÕâÑù˵
Éú³É£³£¬£¶Ö®¼äµÄËæ»úÕûÊý
FLOOR(3 + (RAND() * 6))
ÔÚ4ºóÃæÌí¼ÓÒ»¸ö3µ½6Ö®¼äµÄÕûÊý
CONCAT(343,FLOOR(3 + (RAND() * 6)))
ÔÚijһ×ֶκóÃæÌí¼Óһλ£³£¬£¶Ö®¼äµÄÕûÊý
UPDATE test SET xx= CONCAT(xx,FLOOR(3 +(RAND() * 6)));
µ«ÊÇÎÒ˽×Ô²âÊÔÁËһϣ¬ ......

windowsµÄ64λƽ̨railsÁ¬½ÓmysqlµÄ·½·¨


°²×°mysql
gem install mysql
ʹÓÃmysql£¬È磬rake db:migrate
»á±¨´í£º
E:\study\ruby\rails_space>rake db:migrate
(in E:/study/ruby/rails_space)
!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql.
rake aborted!
193: ......

MYSQL×Ô´ø¹¤¾ßQuery ProfilerʹÓÃ

Query ProfilerÊÇMYSQL×Ô´øµÄÒ»ÖÖqueryÕï¶Ï·ÖÎö¹¤¾ß£¬Í¨¹ýËü¿ÉÒÔ·ÖÎö³öÒ»ÌõSQLÓï¾äµÄÐÔÄÜÆ¿¾±ÔÚʲôµØ·½¡£Í¨³£ÎÒÃÇÊÇʹÓõÄexplain,ÒÔ¼°slow query log¶¼ÎÞ·¨×öµ½¾«È··ÖÎö£¬µ«ÊÇQuery ProfilerÈ´¿ÉÒÔ¶¨Î»³öÒ»ÌõSQLÓï¾äÖ´Ðеĸ÷ÖÖ×ÊÔ´ÏûºÄÇé¿ö£¬±ÈÈçCPU£¬IOµÈ£¬ÒÔ¼°¸ÃSQLÖ´ÐÐËùºÄ·ÑµÄʱ¼äµÈ¡£²»¹ý¸Ã¹¤¾ßÖ»ÓÐÔÚMYSQL 5.0.37ÒÔ ......

ÔÚUbuntuÖÐͨ¹ýÔ´Âë°²×°±àÒë°²×°Èí¼þ(MySQLƪ)

        ʹÓÃUbuntu
Server×÷Ϊ±¾µØ²âÊÔ»·¾³ÒѾ­ÓÐÒ»¶Îʱ¼äÁË£¬Ò»Ö±¶¼ÊÇʹÓÃapt-get·½Ê½À´°²×°¸÷ÖÖÓ¦ÓÃÈí¼þ£¬Í¨¹ýÔ´Âë±àÒë°²×°Ó¦ÓÃÈí¼þÊÇLinuxºÍUnix»·
¾³ÏÂ×î³£Óõķ½Ê½¡£Í¨¹ýÔ´Âë±àÒë°²×°µÄ×î´óºÃ´¦¾ÍÊÇÄãÖªµÀ×Ô¼º×öÁËʲô£¬ÕâÖÖ·½Ê½°²×°Èí¼þ×ÔÓÉÁé»î£¬Ò²ÊÊÓÃÓÚ¸÷ÖÖÆ½Ì¨¡¢Î¬»¤·½±ã£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ