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

MySQLÓëÊÂÎñ


MySQL5.X¶¼ÒѾ­·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵ쬯äʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾
Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃæ£¬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ
¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓë¼¼ÊõÎ޹أ¬ÏÂÃæÒÔInnoDB±íÀàÐÍΪÀý¼òµ¥ËµÒ»ÏÂMySQLÖеÄÊÂÎñ¡£
ÏÈÀ´Ã÷È·Ò»ÏÂÊÂÎñÉæ¼°µÄÏà¹ØÖªÊ¶£º
ÊÂÎñ¶¼Ó¦¸Ã¾ß±¸ACIDÌØÕ÷¡£ËùνACIDÊÇAtomic£¨Ô­×ÓÐÔ£©£¬Consistent£¨Ò»ÖÂÐÔ£©£¬Isolated£¨¸ôÀëÐÔ£©£¬Durable£¨³ÖÐøÐÔ£©Ëĸö´ÊµÄÊ××ÖĸËùд£¬ÏÂÃæÒÔ“ÒøÐÐתÕʔΪÀýÀ´·Ö±ð˵Ã÷Ò»ÏÂËüÃǵĺ¬Ò壺
Ô­×ÓÐÔ£º×é³ÉÊÂÎñ´¦ÀíµÄÓï¾äÐγÉÁËÒ»¸öÂß¼­µ¥Ôª£¬²»ÄÜÖ»Ö´ÐÐÆäÖеÄÒ»²¿·Ö¡£»»¾ä»°Ëµ£¬ÊÂÎñÊDz»¿É·Ö¸îµÄ×îСµ¥Ôª¡£±ÈÈç£ºÒøÐÐתÕʹý³ÌÖУ¬±ØÐëͬʱ´ÓÒ»¸öÕÊ»§¼õȥתÕʽð¶î£¬²¢¼Óµ½ÁíÒ»¸öÕÊ»§ÖУ¬Ö»¸Ä±äÒ»¸öÕÊ»§ÊDz»ºÏÀíµÄ¡£
Ò»ÖÂÐÔ£ºÔÚÊÂÎñ´¦ÀíÖ´ÐÐǰºó£¬Êý¾Ý¿âÊÇÒ»Öµġ£Ò²¾ÍÊÇ˵£¬ÊÂÎñÓ¦¸ÃÕýÈ·µÄת»»ÏµÍ³×´Ì¬¡£±ÈÈç£ºÒøÐÐתÕʹý³ÌÖУ¬ÒªÃ´×ªÕʽð¶î´ÓÒ»¸öÕÊ»§×ªÈëÁíÒ»¸öÕÊ»§£¬ÒªÃ´Á½¸öÕÊ»§¶¼²»±ä£¬Ã»ÓÐÆäËûµÄÇé¿ö¡£
¸ôÀëÐÔ£ºÒ»¸öÊÂÎñ´¦Àí¶ÔÁíÒ»¸öÊÂÎñ´¦ÀíûÓÐÓ°Ïì¡£¾ÍÊÇ˵ÈκÎÊÂÎñ¶¼²»¿ÉÄÜ¿´µ½Ò»¸ö´¦ÔÚ²»ÍêÕû״̬ϵÄÊÂÎñ¡£±ÈÈç˵£¬ÒøÐÐתÕʹý³ÌÖУ¬ÔÚתÕÊÊÂÎñûÓÐÌύ֮ǰ£¬ÁíÒ»¸öתÕÊÊÂÎñÖ»ÄÜ´¦Óڵȴý״̬¡£
³ÖÐøÐÔ£ºÊÂÎñ´¦ÀíµÄЧ¹ûÄܹ»±»ÓÀ¾Ã±£´æÏÂÀ´¡£·´¹ýÀ´Ëµ£¬ÊÂÎñÓ¦µ±Äܹ»³ÐÊÜËùÓеÄʧ°Ü£¬°üÀ¨·þÎñÆ÷¡¢½ø³Ì¡¢Í¨ÐÅÒÔ¼°Ã½Ìåʧ°ÜµÈµÈ¡£±ÈÈç£ºÒøÐÐתÕʹý³ÌÖУ¬×ªÕʺóÕÊ»§µÄ״̬ҪÄܱ»±£´æÏÂÀ´¡£
ÔÙÀ´¿´¿´ÄÄЩÎÊÌâ»áÓõ½ÊÂÎñ´¦Àí£º
ÕâÀﲻ˵“ÒøÐÐתÕÊ”µÄÀý×ÓÁË£¬ËµÒ»¸ö´ó¼Òʵ¼Ê¸üÈÝÒ×Óöµ½µÄ“ÍøÉϹºÊ锵ÄÀý×Ó¡£ÏȼÙÉèÒ»ÏÂÎÊÌâµÄ±³¾°£ºÍøÉϹºÊ飬ijÊ飨Êý¾Ý¿â±àºÅΪ123£©Ö»Ê£×îºóÒ»±¾£¬¶øÕâ¸öʱºò£¬Á½¸öÓû§¶ÔÕâ±¾Ê鼸ºõͬʱ·¢³öÁ˹ºÂòÇëÇó£¬ÈÃÎÒÃÇ¿´¿´Õû¸ö¹ý³Ì£º
ÔÚ¾ßÌå·ÖÎö֮ǰ£¬ÏÈÀ´¿´¿´Êý¾Ý±íµÄ¶¨Ò壺
-------------------------------------------------------------------------------
create table book
(
    book_id unsigned int(10) not null auto_increment,
    book_name varchar(100) not null,
    book_price float(5, 2) not null, #ÎÒ¼ÙÉèÿ±¾ÊéµÄ¼Û¸ñ²»»á³¬¹ý999.99Ôª
    book_number int(10) not n


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿âµÄ¡°Á¬½Ó³Ø¡±

תÌûÇë×¢Ã÷³ö´¦£¬²¢±£³ÖÎÄÕµÄÍêÕûÐÔ¡£
¶ÔMySQLÊý¾Ý¿âÀ´Ëµ£¬Í¬Ò»Ê±¿Ì£¬ÔÚͬһ¸öÁ¬½Ó£¨connection£©ÉÏ£¬Ö»ÔÊÐí½øÐÐÒ»¸ö²Ù×÷£¨query£¬etc.£©£¬Èç¹ûÄãµÄ³ÌÐòÊǶàÏ̵߳쬲¢ÇÒÄãÔÚ¶à¸öÏß³ÌÖж¼»áÀûÓÃͬһ¸öconnection¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÄÇô£¬¾ÍÓпÉÄÜ·¢ÉúÎÊÌâ¡£
ÀýÈ磬Äã¿ÉÄÜ»áÊÕµ½“Commands out of sync”µÄ´íÎó ......

C#Á¬½ÓmysqlÊý¾Ý¿â

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql ......

ÀûÓÃmysqlº¯Êý¸üÐÂmemcached

Memcached Functions for MYSQL¹Ù·½Ö÷Ò³£º
https://launchpad.net/memcached-udfs
Á½Æª»ù±¾ÎÄÕ£º
http://www.libing.name/2009/02/06/mysql-map-data-to-memcached.html
http://www.libing.name/2008/02/26/mysql-map-memcached.html
°²×°ºÍÑéÖ¤µÄSQLÓï¾ä£º
http://hg.tangent.org/memcached_functions_mysql/file/7 ......

mysql¶Ô×ÔÔöidÖØÐ´Ó1ÅÅÐòµÄÁ½ÖÖ·½·¨

ʹÓÃmysqlʱ£¬Í¨³£±íÖлáÓÐÒ»¸ö×ÔÔöµÄid×ֶΣ¬µ«µ±ÎÒÃÇÏ뽫±íÖеÄÊý¾ÝÇå¿ÕÖØÐÂÌí¼ÓÊý¾Ýʱ£¬Ï£ÍûidÖØÐ´Ó1¿ªÊ¼¼ÆÊý£¬ÓÃÒÔÏÂÁ½ÖÖ·½·¨¾ù¿É£º
·½·¨Ò»£º
alter table tablename drop column id;
alter table tablename add id mediumint(8) not null primary key auto_increment first;
·½·¨¶þ£º
alter table tab ......

mysqlÊý¾Ý¿â·¶Ê½Ïê½â

ÔÚÉè¼Æ¹ØÏµÊý¾Ý¿âʱÊÇÒª×ñÊØÒ»¶¨µÄ¹æÔòµÄ¡£ÓÈÆäÊÇÊý¾Ý¿âÉè¼Æ·¶Ê½ÏÖ¼òµ¥½éÉÜ1NF£¨µÚÒ»·¶Ê½£©£¬2NF£¨µÚ¶þ·¶Ê½£©£¬3NF£¨µÚÈý·¶Ê½£©ºÍBCNF£¬ÁíÓеÚËÄ·¶Ê½ºÍµÚÎ巶ʽÁôµ½ÒÔºóÔÙ½éÉÜ¡£ÔÚÄãÉè¼ÆÊý¾Ý¿â֮ʱ£¬ÈôÄÜ·ûºÏÕ⼸¸ö·¶Ê½£¬Äã¾ÍÊÇÊý¾Ý¿âÉè¼ÆµÄ¸ßÊÖ¡£
µÚÒ»·¶Ê½£¨1NF£©£ºÔÚ¹ØÏµÄ£Ê½RÖеÄÿһ¸ö¾ßÌå¹ØÏµrÖУ¬Èç¹ûÿ¸öÊôÐÔÖµ¶¼Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ