Mysql ÊÂÎñ´¦Àí
¡¡¡¡ÊÂÎñÊÇDBMSµÃÖ´Ðе¥Î»¡£ËüÓÉÓÐÏÞµÃÊý¾Ý¿â²Ù×÷ÐòÁÐ×é³ÉµÃ¡£µ«²»ÊÇÈÎÒâµÃÊý¾Ý¿â²Ù×÷ÐòÁж¼ÄܳÉΪÊÂÎñ¡£Ò»°ãÀ´Ëµ£¬ÊÂÎñÊDZØÐëÂú×ã4¸öÌõ¼þ£º£¨ACID£©
¡¡¡¡Ô×ÓÐÔ£¨Autmic£©£ºÊÂÎñÔÚÖ´ÐÐÐÔ£¬Òª×öµ½“Ҫô²»×ö£¬ÒªÃ´È«×ö£¡”£¬¾ÍÊÇ˵²»ÔÊÐíÊÂÎñ²¿·ÖµÃÖ´ÐС£¼´Ê¹ÒòΪ¹ÊÕ϶øʹÊÂÎñ²»ÄÜÍê³É£¬ÔÚrollbackʱҲҪÏû³ý¶ÔÊý¾Ý¿âµÃÓ°Ï죡
¡¡¡¡Ò»ÖÂÐÔ£¨Consistency£©£ºÊÂÎñµÃ²Ù×÷Ó¦¸ÃʹʹÊý¾Ý¿â´ÓÒ»¸öÒ»ÖÂ״̬ת±äµ¹ÁíÒ»¸öÒ»ÖµÃ״̬£¡¾ÍÄÃÍøÉϹºÎïÀ´Ëµ°É£¬ÄãÖ»Óм´ÈÃÉÌÆ·³ö¿â£¬ÓÖÈÃÉÌÆ·½øÈë¹Ë¿ÍµÃ¹ºÎïÀº²ÅÄܹ¹³ÉÊÂÎñ£¡
¡¡¡¡¸ôÀëÐÔ£¨Isolation£©£ºÈç¹û¶à¸öÊÂÎñ²¢·¢Ö´ÐУ¬Ó¦Ïó¸÷¸öÊÂÎñ¶ÀÁ¢Ö´ÐÐÒ»Ñù£¡
¡¡¡¡³Ö¾ÃÐÔ£¨Durability£©£ºÒ»¸ö³É¹¦Ö´ÐеÃÊÂÎñ¶ÔÊý¾Ý¿âµÃ×÷ÓÃÊdz־õ㬼´Ê¹Êý¾Ý¿âÓ¦¹ÊÕϳö´í£¬Ò²Ó¦¸ÃÄܹ»»Ö¸´£¡
¡¡¡¡
MYSQLµÄÊÂÎñ´¦ÀíÖ÷ÒªÓÐÁ½ÖÖ·½·¨¡£
1¡¢ÓÃbegin,rollback,commitÀ´ÊµÏÖ£¨ÕâÖÖ·½Ê½ÊÇ×î³£Óõģ©
begin ¿ªÊ¼Ò»¸öÊÂÎñ£¨Ò»°ã¶¼ÓÃSTART TRANSACTION¸ü¼ÓÃ÷ÁË£©
rollback ÊÂÎñ»Ø¹ö
commit ÊÂÎñÈ·ÈÏ
2¡¢Ö±½ÓÓÃsetÀ´¸Ä±ämysqlµÄ×Ô¶¯Ìύģʽ
MYSQLĬÈÏÊÇ×Ô¶¯Ìá½»µÄ£¬Ò²¾ÍÊÇÄãÌá½»Ò»¸öQUERY£¬Ëü¾ÍÖ±½ÓÖ´ÐУ¡ÎÒÃÇ¿ÉÒÔͨ¹ý
set autocommit=0 ½ûÖ¹×Ô¶¯Ìá½»
set autocommit=1 ¿ªÆô×Ô¶¯Ìá½»
À´ÊµÏÖÊÂÎñµÄ´¦Àí¡£µ«×¢Òâµ±ÄãÓà set autocommit=0 µÄʱºò£¬ÄãÒÔºóËùÓеÄSQL¶¼½«×öΪÊÂÎñ´¦Àí£¬Ö±µ½ÄãÓÃcommitÈ·ÈÏ»òrollback½áÊø£¬×¢Òâµ±Äã½áÊøÕâ¸öÊÂÎñµÄͬʱҲ¿ªÆôÁ˸öеÄÊÂÎñ£¡°´µÚÒ»ÖÖ·½·¨Ö»½«µ±Ç°µÄ×÷Ϊһ¸öÊÂÎñ£¡¸öÈËÍƼöʹÓõÚÒ»ÖÖ·½·¨£¡
¡¡¡¡MYSQLÖÐÖ»ÓÐINNODBºÍBDBÀàÐ͵ÄÊý¾Ý±í²ÅÄÜÖ§³ÖÊÂÎñ´¦Àí£¡ÆäËûµÄÀàÐÍÊDz»Ö§³ÖµÄ£¡£¨Çмǣ¡£©£¨
InnoDB±»ÓÃÀ´ÔÚÖÚ¶àÐèÒª¸ßÐÔÄܵĴóÐÍÊý¾Ý¿âÕ¾µãÉϲúÉú¡£ÖøÃûµÄInternetÐÂÎÅÕ¾µãSlashdot.orgÔËÐÐÔÚInnoDBÉÏ¡£Mytrix, Inc.ÔÚInnoDBÉÏ´æ´¢³¬¹ý1TBµÄÊý¾Ý£¬»¹ÓÐһЩÆäËüÕ¾µãÔÚInnoDBÉÏ´¦Àíƽ¾ùÿÃë800´Î²åÈë/¸üеĸººÉ¡£ InnoDBÊÇΪ´¦Àí¾Þ´óÊý¾ÝÁ¿Ê±µÄ×î´óÐÔÄÜÉè¼Æ¡£ËüµÄCPUЧÂÊ¿ÉÄÜÊÇÈκÎÆäËü»ùÓÚ´ÅÅ̵ĹØϵÊý¾Ý¿âÒýÇæËù²»ÄÜÆ¥µÐµÄ¡£ £©
ÒÔÏ´
Ïà¹ØÎĵµ£º
MYSQLÃüÁî´óÈ«
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§ÃûÇ°¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëÇ°±ØÐëûÓпոñ£¬·ñÔòÈÃÄãÖØÐÂÊäÈëÃÜÂë. Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû ......
update article set body = (REPLACE(body, '</div>', ' ')) where typeid=21
ÓÃupdateºÍreplaceÔÚmysqlÖÐÌ滻ijһ¸ö×ֶεIJ¿·ÖÄÚÈÝ
update users_settings set `ConfigValue` = replace(configvalue,' fromstr' 'tostr') where `ConfigName`='accesslist'
¶ÔÓÚÕë¶Ô×Ö·û´®Î»ÖõIJÙ×÷£¬µÚÒ»¸öλÖñ»±ê¼Ç ......
MySQL£ºÈÕÆÚº¯Êý¡¢Ê±¼äº¯Êý×ܽᣨMySQL 5.X£©
²Î¿¼³¤ÎÄ£º
Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2008-08-08 22:20:46 |
+---------------------+
³ýÁË now() º¯ÊýÄÜ»ñµÃµ±Ç°µ ......
ÌâÄ¿£º¸ø¶¨Ò»¸ö·Ö¸î·û£¬ÔõÑùµÃµ½¸ø¶¨×Ö·û´®×îºóÒ»¸ö·Ö¸î·ûºóµÄ×Ö·û´®¡£ È磺‘fsb-ibees-zxj-fsbk’ ÔõÑùµÃµ½fsbk, ÒªÇó£ºjavaʵÏÖ£¬sqlʵÏÖ£¿sql¿ÉÒÔÊÇoracle£¬mysqlµÈʵÏÖ¡£
1.OracleʵÏÖ
SET SERVEROUTPUT ON;
DECLARE
str VARCHAR2(266):='123-890-ibees-zxj';--±»½âÎöµÄ×Ö·û´®
splitStr VARCH ......
Î塢ʼþµ÷¶ÈÆ÷²âÊÔ
5.1¡¢²âÊÔÄ¿µÄ
5.1.1 ÅäÖ÷½·¨
5.1.2 ÊÇ·ñÕý³£¹¤×÷
5.1.3 ÈÕ³£µÄά»¤
5.2¡¢Ê¼þµ÷¶ÈÆ÷½éÉÜ
×ÔMySQL5.1.6Æð£¬Ôö¼ÓÁËÒ»¸ö·Ç³£ÓÐÌØÉ«µÄ¹¦ÄÜ
–ʼþµ÷¶ÈÆ÷(Event Scheduler)£¬¿ÉÒÔÓÃ×ö¶¨Ê±Ö´ÐÐijЩÌض¨ÈÎÎñ£¨ÀýÈ磺ɾ³ý
¼Ç¼¡¢¶ÔÊý¾Ý
½øÐлã×ܵȵȣ©£¬À´È¡´ ......