mysql¸´ÖƱí
ÎÒÃǾ³£»áÓöµ½ÐèÒª±í¸´ÖƵÄÇé¿ö£¬È罫һ¸ötable1µÄÊý¾ÝµÄ²¿·Ö×ֶθ´ÖƵ½table2ÖУ¬»òÕß½«Õû¸ötable1¸´ÖƵ½table2ÖУ¬ÕâʱºòÎÒÃǾÍҪʹÓÃSELECT INTO ºÍ INSERT INTO SELECT ±í¸´ÖÆÓï¾äÁË¡£
1.INSERT INTO SELECTÓï¾ä
Óï¾äÐÎʽΪ£ºInsert into Table2(field1,field2,...) select value1,value2,... from Table1
2.SELECT INTO fromÓï¾ä
Óï¾äÐÎʽΪ£ºSELECT vale1, value2 into Table2 from Table1
select * into target_table from source_table;
insert into target_table(column1,column2) select column1,5 from source_table;
ÒÔÉÏÁ½¾ä¶¼Êǽ«Ô´±ísource_tableµÄ¼Ç¼²åÈ뵽Ŀ±ê±ítarget_table£¬µ«Á½¾äÓÖÓÐÇø±ð¡£
µÚÒ»¾ä£¨select into from£©ÒªÇóÄ¿±ê±ítarget_table²»´æÔÚ£¬ÒòΪÔÚ²åÈëʱ»á×Ô¶¯´´½¨¡£
µÚ¶þ¾ä£¨insert into select from£©ÒªÇóÄ¿±ê±ítarget_table´æÔÚ£¬ÓÉÓÚÄ¿±ê±íÒѾ´æÔÚ£¬ËùÒÔÎÒÃdzýÁ˲åÈëÔ´±ísource_tableµÄ×Ö¶ÎÍ⣬»¹¿ÉÒÔ²åÈë³£Á¿£¬ÈçÀýÖеģº5¡£
Ïà¹ØÎĵµ£º
ÐèÇó1£ºÔÚÒ»¸öselect ²éѯ¼¯ÖÐÔٴβéѯ
SELECT * from (SELECT field from table) AS alias
ÐèҪעÒâºóÃæµÄalias£¬ÔÚmysqlÖУ¬ÕâÊDZØÐëµÄ
ÐèÇó2£ºÒ»¸ö²éѯ¼¯µÄ½á¹û²»ÔÚÁíÒ»¸ö²éѯ¼¯ÖÐ
SELECT feild1 from table1 WHERE feild1 NOT IN (SELECT field2 from table2)
ÐèҪעÒ⣬ӦÓÃIN/NOT IN×Ó¾äʱ£¬±ØÐëÖ¸¶¨²éѯ×Ö¶ÎÃû£ ......
ÉèÖÃMySQLÊý¾Ýͬ²½£¨µ¥Ïò&Ë«Ïò£©
ÓÉÓÚ¹«Ë¾µÄÒµÎñÐèÇó£¬ÐèÒªÍøͨºÍµçÐŵÄÊý¾Ýͬ²½£¬¾Í×öÁ˸öMySQLµÄË«Ïòͬ²½£¬¼ÇϹý³Ì£¬ÒÔºóÓõõ½ÔÙ·³öÀ´£¬Ò²Ìù³öÀ´¹©´ó¼Ò²Î¿¼¡£
Ò»¡¢×¼±¸·þÎñÆ÷
ÓÉÓÚMySQL²»Í¬°æ±¾Ö®¼äµÄ(¶þ½øÖÆÈÕÖ¾)binlog¸ñʽ¿ÉÄܻ᲻һÑù£¬Òò´Ë×îºÃµÄ´îÅä×éºÏÊÇMasterµÄMySQL°æ±¾ºÍSlaveµÄ°æ±¾Ïàͬ»òÕ߸üµÍ£¬Ma ......
Èç¹ûÄãÊǸöÈü³µÊÖ£¬²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇʲô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊÇ°´°´Å¥»»
ÒýÇ棻ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇ棬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£
MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ÒâµÄ ......
½ñÌ죬ÕÛÌÚÁËÒ»¸öÏÂÎ磬ÖÕÓÚ½â¾öÁËHibernate ´æ´¢Blob×Ö¶Îʱ£¬Êý¾ÝÁ¿·Ç³£´óʱ×ÜÊDZ¨ can not update jdbc batchµÄ´íÎóÁË£¬ÔÀ´ÊÇMySQLÖÐûÓÐÉ趨×î´óÔÊÐíÖµËùÖ£¬ÎÒ»¹ÒÔΪÊÇHibernate²Ù×÷²»·ûºÏ±ê×¼²ÅÕâÑù¡£¡£¡£ºÇºÇ£¬ÔÚMysql 5.1ÖеÄmy.iniÅäÖÃÎļþÖмÓÈëÈçÏÂÉèÖãº
[MYSQL]
max_allowed ......