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

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 for PHP

×¼±¸£ºÏÂÔØ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µÄ×¢ÉäµãµÃµ½¸ü¶àmysqlµÄÐÅÏ¢

µ±×¢Éämysql¿âµÄÊäÈëµãµÄʱºò,ÎÒÃÇ¿ÉÒÔͨ¹ýversion()/user()/database()/password()µÈÄÚÖú¯ÊýÀ´µÃµ½mysqlµÄÏà¹ØÐÅÏ¢,ÆäʵÎÒÃÇÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓÃmysqlÄÚÖõıäÁ¿À´µÃµ½¸ü¶àµÄmysqlÐÅÏ¢
ÆäÖÐversion()¿ÉÒÔд³É@@versionÀ´°Ñversionµ±×ö±äÁ¿À´¶ÁÈ¡,ÕâÑùÒ»Ñù¿ÉÒԵõ½,ÆäËûµÄÄÚÖÃÊDz»¿ÉÒÔд³É±äÁ¿µÄÐÎʽ.
´ó¼Ò¶¼Ó¦¸ÃÓùýÀû ......

MySQL Partition

×÷ÕߣºÀÏÍõ Èý¹úÑÝÒ忪ƪһÓïµÀÆÆ£ººÏ¾Ã±Ø·Ö£¡MySQLµÄʹÓÃÒàÊÇÈç´Ë£¬Ãæ¶ÔÓ¦ÓÃÖÐÔ½À´Ô½ÅÓ´óµÄÊý¾ÝÁ¿£¬×îʱ÷ֵĽâ¾ö·½°¸ÊÇShard£¬²»¹ýËüµÄ¸´ÔÓÐÔ²¢²»ÊÇÿ¸ö³ÌÐòÔ±¶¼ÄܼÝÔ¦µÄ£¬Èç¹û°Ñ¼Ü¹¹µÄÑݱä±È×÷ÉúÃüµÄ½ø»¯£¬ÄÇôShard¿ÉÒÔ¿´×öÊDz¸È鶯ÎºÜ¶à¼Ü¹¹×îºóÖ®ËùÒÔʧ°Ü£¬¾ÍÊÇÒòΪËüÃDz½×ÓÂõµÃÌ«´ó£¬Ïë´ÓԭʼÉúÃüÖ±½Ó½ø»¯³É²¸Èé¶ ......

23±¾mysqlµç×ÓÊé


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 7 ϰ²×°apache php ºÍmysqlµÄһЩÎÊÌâ¡£

ÔÚwindowsϰ²×°ampÍøÉϵĽéÉܺܶàÁË¡£
ÎÒÕâÀïֻ˵Щ¹Ø¼üµÄ²¿·Ö£¬Ò»·½Ãæ×÷Ϊ±Ê¼Ç£¬ÁíÒ»·½ÃæºÍ´ó¼Ò¹²Ïí¡£
1.°²×°apache
   a.ÕâÀïҪעÒ⣬ÔÚ¸Õ¿ªÊ¼ÌîдÖ÷»úÓòÃûʱ£¬Èç¹ûÄãûÓÐÓòÃû£¬¾ÍÔÚ±¾µØ°²×°£¬ÄǾÍÌîд±¾»úipÐÐÁË¡££¨ÎÒ¾õµÃÌîд127.0.0.1¸üºÃ£¬¾ßÌåÎÒûÊÔ¹ý£©
   b.apache µÄĬÈ϶˿ÚÊÇ80£¬ÎÒµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ