Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Partition

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

MySQLµÄfrom_UNIXTIME()ºÍUNIX_TIMESTAMP()º¯ÊýµÄÇø±ð

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³£ÓÃÃüÁîÐдóÈ«

µÚÒ»ÕС¢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¸´ÖÆ


15.2.6.5. InnoDBºÍMySQL¸´ÖÆ
MySQL¸´ÖƾÍÏñ¶ÔMyISAM±íÒ»Ñù£¬Ò²¶ÔInnoDB±íÆð×÷Óá£ÒÔijÖÖ·½Ê½Ê¹Óø´ÖÆÒ²ÊÇ¿ÉÄܵģ¬ÔÚÕâÖÖ·½Ê½ÖдӷþÎñÆ÷ÉϱíµÄÀàÐͲ»Í¬ÓÚÖ÷·þÎñÆ÷ÉÏԭʼ±íµÄÀàÐÍ¡£ÀýÈ磬Äã¿ÉÒÔ¸´ÖÆÐ޸ĵ½Ö÷·þÎñÆ÷ÉÏÒ»¸öInnoDB±í£¬µ½´Ó·þÎñÆ÷ÉÏÒ»¸öMyISAM±íÀï¡£
ҪΪһ¸öÖ÷·þÎñÆ÷½¨Á¢Ò»¸öзþÎñÆ÷£¬Äã²»µÃ²»¸´ÖÆIn ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ