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¿âµÄÊäÈëµãµÄʱºò,ÎÒÃÇ¿ÉÒÔͨ¹ýversion()/user()/database()/password()µÈÄÚÖú¯ÊýÀ´µÃµ½mysqlµÄÏà¹ØÐÅÏ¢,ÆäʵÎÒÃÇÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓÃmysqlÄÚÖõıäÁ¿À´µÃµ½¸ü¶àµÄmysqlÐÅÏ¢
ÆäÖÐversion()¿ÉÒÔд³É@@versionÀ´°Ñversionµ±×ö±äÁ¿À´¶ÁÈ¡,ÕâÑùÒ»Ñù¿ÉÒԵõ½,ÆäËûµÄÄÚÖÃÊDz»¿ÉÒÔд³É±äÁ¿µÄÐÎʽ.
´ó¼Ò¶¼Ó¦¸ÃÓùýÀû ......
×÷ÕߣºÀÏÍõ Èý¹úÑÝÒ忪ƪһÓïµÀÆÆ£ººÏ¾Ã±Ø·Ö£¡MySQLµÄʹÓÃÒàÊÇÈç´Ë£¬Ãæ¶ÔÓ¦ÓÃÖÐÔ½À´Ô½ÅÓ´óµÄÊý¾ÝÁ¿£¬×îʱ÷ֵĽâ¾ö·½°¸ÊÇShard£¬²»¹ýËüµÄ¸´ÔÓÐÔ²¢²»ÊÇÿ¸ö³ÌÐòÔ±¶¼ÄܼÝÔ¦µÄ£¬Èç¹û°Ñ¼Ü¹¹µÄÑݱä±È×÷ÉúÃüµÄ½ø»¯£¬ÄÇôShard¿ÉÒÔ¿´×öÊDz¸È鶯ÎºÜ¶à¼Ü¹¹×îºóÖ®ËùÒÔʧ°Ü£¬¾ÍÊÇÒòΪËüÃDz½×ÓÂõµÃÌ«´ó£¬Ïë´ÓÔʼÉúÃüÖ±½Ó½ø»¯³É²¸Èé¶ ......
mastering Phpmyadmin
Beginning Php And Mysql³ÌÐòÉè¼Æ
Beginning PHP and MySQL from Novice to Professional 3rd Edition
Head First PHP MySQL
MySQLÈëÞµä
MySQL Stored Procedure Pr ......
ÔÚwindowsϰ²×°ampÍøÉϵĽéÉܺܶàÁË¡£
ÎÒÕâÀïֻ˵Щ¹Ø¼üµÄ²¿·Ö£¬Ò»·½Ãæ×÷Ϊ±Ê¼Ç£¬ÁíÒ»·½ÃæºÍ´ó¼Ò¹²Ïí¡£
1.°²×°apache
a.ÕâÀïҪעÒ⣬ÔÚ¸Õ¿ªÊ¼ÌîдÖ÷»úÓòÃûʱ£¬Èç¹ûÄãûÓÐÓòÃû£¬¾ÍÔÚ±¾µØ°²×°£¬ÄǾÍÌîд±¾»úipÐÐÁË¡££¨ÎÒ¾õµÃÌîд127.0.0.1¸üºÃ£¬¾ßÌåÎÒûÊÔ¹ý£©
b.apache µÄĬÈ϶˿ÚÊÇ80£¬ÎÒµÄ ......