MySQL ´¥·¢Æ÷ ´æ´¢¹ý³Ì Ò»µãСÓÃ
ͬÊÂÀëÖ°£¬ÓÖÒ»¸öÒ»¸öÀÃ̯×ÓÒªÊÕʰ¡£ÕâÀïÐÞÐÞ£¬ÄÇÀï²¹²¹¶¼Ã»Óо«Á¦À´Ð´µã¶«Î÷¡£
Ã÷Ìì»Ø¼Ò£¬ÉÏÎçÕûÀíºÃÎĵµ¡£ÏÂÎç¾ö¶¨³éµãʱ¼ä£¬°Ñ×î½üµÄ¶«Î÷¾¡Á¿ÀíÒ»Àí¡£ºÜ¶àÁé¸Ð¶¼ÒѾÒÅÍü¡£ÎÒÃÇ×ÜÔÚ²»¶ÏÃæ¶Ô£¬ËùÒÔÎÒÃDz»¶ÏÒÅÍü¡£¡¾syslog¡¢mysqlÓÅ»¯¡¢´¥·¢Æ÷¡¢´æ´¢¹ý³Ì¡¢Îļþ¶Áд……¡¿·è¿ñµÄGoogle×ÅÕâЩ¹Ø¼ü´Ê£¬ÒÔÇóÔÚ¶ÔÏîÄ¿ÕûÌå¸Ä¶¯×îС¡¢Ó°Ïì×îСÇé¿öÏÂÍê³ÉÕâЩ¹¤×÷¡£
¹ý³ÌºÜÍ´¿à£¬½ñÌìÕâÆªËãÊÇÍ´¶¨Ë¼Í´°É£¡
ÔÚ¼¼Êõ¿ÉÐеÄÇé¿öÏ£¬ÓÅÑŵÄÉè¼ÆÓÀÔ¶ºÜÖØÒª£¬·ñÔò¾Í²»¶ÏÍ´¿à°É¡££¨Ë¼¿¼£¬³ÉÊìµÄ˼¿¼Ò»¶¨ÔÚÐж¯Ö®Ç°£©
ÑÔ¹éÕý´«£º´¥·¢Æ÷¡¢´æ´¢¹ý³Ì¿ÉÒÔÀí½âһЩԤÏȱàдºÃµÄº¯Êý£¬´æ´¢ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ¡£´¥·¢Æ÷¹ØÁªµ½¾ßÌå±í£¬¶ÔÒ»ÕÅÊý¾Ý±í½øÐвåÈë¡¢¸üС¢É¾³ýÕâÈýÀà²Ù×÷ǰ¡¢²Ù×÷ºó¶¼¿ÉÒÔ×öһЩÊÂÇ飬±ÈÈ磺ɾ³ýijÕűíÒ»Ìõ¼Ç¼ºó£¬¿ÉÒÔͬʱɾ³ýÒ»ÕÅÏà¹Ø±íÖеĶÔÓ¦¼Ç¼¡£¶øÕâЩ¹¤×÷¶¼»áÓÉÊý¾Ý¿â×Ô¶¯Íê³É¡£
Ò»¸öÀý×Ó£º
DELIMITER ;;
TRIGGER `targetTest` AFTER INSERT ON `tbl_1` FOR EACH ROW BEGIN
if not exists (select id from tbl_2 where name=NEW.name) then
INSERT INTO tbl_2 (`name`,`record`) VALUES (NEW.name,'1');
else
UPDATE tbl_2 SET record=record+1 WHERE name=NEW.name;
end if;
END */;;
DELIMITER ;
˵Ã÷£ºÉÏÃæÀý×ÓʵÏÖ¹¦ÄÜ£¬Ïò±ítbl_1ÖвåÈëÒ»ÌõÊý¾ÝÖ®ºó£¬ÅжÏtbl_2ÖÐÓÐûÓд˼Ǽ£¬Èç¹ûûÓвåÈëÒ»ÌõеļǼµ½tbl_2£¬Èç¹ûÓжÔÓ¦nameÔò¸üÐÂÒ»ÏÂtbl_2µÄrecord×ֶΡ££¨´¥·¢Æ÷Óï·¨½âÊÍ¿ÉÒÔGoogleÆäËû×ÊÁÏ£©
´æ´¢¹ý³Ì£¬Ò»¶Î±àдºÃµÄSQLÓï¾ä¿ÉÒÔ·â×°³Éº¯Êý£¬Ö±½Óµ÷Óãº
Ò»¸öÀý×Ó£º
DELIMITER $$
CREATE DEFINER=`xxx`@`localhost` PROCEDURE `pro_test`(e_table varchar(1000),e_filename varchar(1000),e_condition varchar(1000))
begin
SET @sql = CONCAT('select * into outfile "',e_filename, '" from ',e_table);
IF e_condition IS NOT NULL AND e_condition <> '' THEN
SET @sql = CONCAT(@sql,' where ',e_condition);
END IF;
PREPARE record from @sql;
EXECUTE record;
DEALLOCATE PR
Ïà¹ØÎĵµ£º
×¼±¸£ºÏÂÔØMysql5.1<mysql-essential-5.1.41-win32.msi>
°²×°£ºstep by step
²âÊÔ£º1.MySQL²âÊÔ
µã¿ªMySQL Command Line Client, ÊäÈ밲װʱ½¨Á¢µÄÃÜÂë¡£
mysql>show databases;
mysql>use <<database name>>;
mysql>show tables;
mysql>select * from <<table name>>;
......
×÷ÕߣºÀÏÍõ Èý¹úÑÝÒ忪ƪһÓïµÀÆÆ£ººÏ¾Ã±Ø·Ö£¡MySQLµÄʹÓÃÒàÊÇÈç´Ë£¬Ãæ¶ÔÓ¦ÓÃÖÐÔ½À´Ô½ÅÓ´óµÄÊý¾ÝÁ¿£¬×îʱ÷ֵĽâ¾ö·½°¸ÊÇShard£¬²»¹ýËüµÄ¸´ÔÓÐÔ²¢²»ÊÇÿ¸ö³ÌÐòÔ±¶¼ÄܼÝÔ¦µÄ£¬Èç¹û°Ñ¼Ü¹¹µÄÑݱä±È×÷ÉúÃüµÄ½ø»¯£¬ÄÇôShard¿ÉÒÔ¿´×öÊDz¸È鶯ÎºÜ¶à¼Ü¹¹×îºóÖ®ËùÒÔʧ°Ü£¬¾ÍÊÇÒòΪËüÃDz½×ÓÂõµÃÌ«´ó£¬Ïë´ÓÔʼÉúÃüÖ±½Ó½ø»¯³É²¸Èé¶ ......
from_unixtime()ÊÇMySQLÀïµÄʱ¼äº¯Êý
dateΪÐèÒª´¦ÀíµÄ²ÎÊý(¸Ã²ÎÊýÊÇUnix ʱ¼ä´Á),¿ÉÒÔÊÇ×Ö¶ÎÃû,Ò²¿ÉÒÔÖ±½ÓÊÇUnix ʱ¼ä´Á×Ö·û´®
ºóÃæµÄ '%Y%m%d' Ö÷ÒªÊǽ«·µ»ØÖµ¸ñʽ»¯
ÀýÈç:
mysql>SELECT from_UNIXTIME( 1249488000, '%Y%m%d' )
->20071120
mysql>SELECT from_UNIXTIME( 1249488000, '%YÄê%mÔ ......
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
15.2.6.5. InnoDBºÍMySQL¸´ÖÆ
MySQL¸´ÖƾÍÏñ¶ÔMyISAM±íÒ»Ñù£¬Ò²¶ÔInnoDB±íÆð×÷Óá£ÒÔijÖÖ·½Ê½Ê¹Óø´ÖÆÒ²ÊÇ¿ÉÄܵģ¬ÔÚÕâÖÖ·½Ê½ÖдӷþÎñÆ÷ÉϱíµÄÀàÐͲ»Í¬ÓÚÖ÷·þÎñÆ÷ÉÏÔʼ±íµÄÀàÐÍ¡£ÀýÈ磬Äã¿ÉÒÔ¸´ÖÆÐ޸ĵ½Ö÷·þÎñÆ÷ÉÏÒ»¸öInnoDB±í£¬µ½´Ó·þÎñÆ÷ÉÏÒ»¸öMyISAM±íÀï¡£
ҪΪһ¸öÖ÷·þÎñÆ÷½¨Á¢Ò»¸öзþÎñÆ÷£¬Äã²»µÃ²»¸´ÖÆIn ......