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() ·µ»ØÆ¥ÅäÒ»¸ö¼òµ¥µÄÕýÔò±í´ïʽµ
Ïà¹ØÎĵµ£º
Èç¹ûÄãËÑË÷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)));
µ«ÊÇÎÒ˽×Ô²âÊÔÁËһϣ¬ ......
°²×°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: ......
Query ProfilerÊÇMYSQL×Ô´øµÄÒ»ÖÖqueryÕï¶Ï·ÖÎö¹¤¾ß£¬Í¨¹ýËü¿ÉÒÔ·ÖÎö³öÒ»ÌõSQLÓï¾äµÄÐÔÄÜÆ¿¾±ÔÚʲôµØ·½¡£Í¨³£ÎÒÃÇÊÇʹÓõÄexplain,ÒÔ¼°slow query log¶¼ÎÞ·¨×öµ½¾«È··ÖÎö£¬µ«ÊÇQuery ProfilerÈ´¿ÉÒÔ¶¨Î»³öÒ»ÌõSQLÓï¾äÖ´Ðеĸ÷ÖÖ×ÊÔ´ÏûºÄÇé¿ö£¬±ÈÈçCPU£¬IOµÈ£¬ÒÔ¼°¸ÃSQLÖ´ÐÐËùºÄ·ÑµÄʱ¼äµÈ¡£²»¹ý¸Ã¹¤¾ßÖ»ÓÐÔÚMYSQL 5.0.37ÒÔ ......
ʹÓÃUbuntu
Server×÷Ϊ±¾µØ²âÊÔ»·¾³ÒѾÓÐÒ»¶Îʱ¼äÁË£¬Ò»Ö±¶¼ÊÇʹÓÃapt-get·½Ê½À´°²×°¸÷ÖÖÓ¦ÓÃÈí¼þ£¬Í¨¹ýÔ´Âë±àÒë°²×°Ó¦ÓÃÈí¼þÊÇLinuxºÍUnix»·
¾³ÏÂ×î³£Óõķ½Ê½¡£Í¨¹ýÔ´Âë±àÒë°²×°µÄ×î´óºÃ´¦¾ÍÊÇÄãÖªµÀ×Ô¼º×öÁËʲô£¬ÕâÖÖ·½Ê½°²×°Èí¼þ×ÔÓÉÁé»î£¬Ò²ÊÊÓÃÓÚ¸÷ÖÖÆ½Ì¨¡¢Î¬»¤·½±ã£ ......