Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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)));
µ«ÊÇÎÒ˽×Ô²âÊÔÁËһϣ¬ ......

pythonÄ£¿éÖ®MySQLdb: ÓÃpythonÁ¬½ÓmysqlÊý¾Ý¿â

mysqlÊÇÒ»¸öÓÅÐãµÄ¿ªÔ´Êý¾Ý¿â£¬ËüÏÖÔÚµÄÓ¦Ó÷dz£µÄ¹ã·º£¬Òò´ËºÜÓбØÒª¼òµ¥µÄ½éÉÜÒ»ÏÂÓÃpython²Ù×÷mysqlÊý¾Ý¿âµÄ·½·¨¡£python²Ù×÷Êý¾Ý¿âÐèÒª°²×°Ò»¸öµÚÈý·½µÄÄ£¿é£¬ÔÚhttp://mysql-python.sourceforge.net/
ÓÐÏÂÔØºÍÎĵµ¡£
    ÓÉÓÚpythonµÄÊý¾Ý¿âÄ£¿éÓÐרÃŵÄÊý¾Ý¿âÄ£¿éµÄ¹æ·¶£¬ËùÒÔ£¬Æäʵ²»¹ÜʹÓÃÄÄÖÖÊý¾ ......

MySQLѧϰ(3) ÊÓͼ£¬Óα꣬Óï¾ä¿é¶ù

1.MySQL´´½¨ÊÓͼµÄ¼òµ¥Óï¾äΪ£ºCREATE VIEW view_name  AS SELECT * from TABLE_NAME;
²»ÄܶԴ¥·¢Æ÷´´½¨ÊÓͼ(VIEW)¡£µ«ÊÇÔÚ5.1.4ÖÐÊÇÕâÑùÃèÊöµÄ£¬A view can be created from many kinds of SELECT statements. It can refer to base tables or other views. It can use joins, UNION, and subqueries¡£´óÖÂÒâ˼ÊÇÊÓÍ ......

MySQL´æ´¢¹ý³Ìѧϰ


http://www.mysql.cn/
ÊÂÎñ£¬²ÎÊý£¬Ç¶Ì×µ÷Óã¬Óα꣬ѭ»·, ´¥·¢Æ÷£¬ÊÓͼ£¬Ô¼Êø, Ë÷Òý£¬¡£¡£¡£
1. ´´½¨ÊµÀýÊý¾Ý¿â
   create database db5;
   use db5;
2.´´½¨Ò»¸ö¼òµ¥µÄ¹¤×÷±í,²¢²åÈëÊý¾Ý
   create table t(s1 int);
   insert into t values(5);
3.´´½¨³ÌÐòʵÀý crea ......

¾ßÓиºÔؾùºâ¹¦ÄÜMySQL·þÎñÆ÷¼¯Èº²¿ÊðʵÏÖ

À´×Ô£ºhttp://it.china-b.com/zx/linuxsjk/20090525/24129_1.html
ÕªÒª£ºMySQLÊÇÒ»¸ö¸ßËÙ¶È¡¢¸ßÐÔÄÜ¡¢¶àÏ̵߳ĹØÏµÐÍÊý¾Ý¿â
ÖÎÀíϵͳ£¬ÊÊÓÃÆ½Ì¨¶à£¬¿ÉÀ©Õ¹ÐÔÇ¿¡£ÔÚʵ¼ÊÉú²ú»·¾³ÖУ¬²¿ÊðºÍʵÏÖ¾ßÓÐÒ»¶¨¸ºÔؾùºâ¹¦ÄܵÄMySQL·þÎñÆ÷¼¯Èº£¬¶ÔÓÚÌá¸ßÓû§Êý¾Ý¿â
Ó¦ÓÃϵͳµÄÐÔÄÜ¡¢ËٶȺÍÎȶ¨ÐÔ¾ßÓÐÃ÷ÏÔµÄ×÷Óᣱ¾ÎļòÒª½éÉÜÁËÔÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ