SqlÔÚMysqlµÄÖ´ÐÐ
×òÌì½âÎöÁËdblp.xml£¬´æÈëÊý¾Ý¿â£¬Éú³ÉÁËÈô¸ÉÕÅÁÙʱ±í¡£½ñÌìÉÏÎ磬¶ÔÕâЩÁÙʱ±í½øÐд¦Àí£¬È»ºó´æÈëʵÑéÉè¼ÆµÄ±íÖС£Êý¾Ý¿âµÄÊý¾ÝÁ¿±È½Ï´ó£¬50¶àM£¬80¶àÍòÌõ¼Ç¼¡£Òò¶øÖ´ÐÐsqlʱ£¬¾ÍÓöµ½Á˺ܶàÎÊÌâ¡£
1¡¢È¥³ýÖØ¸´tuple
Ôʼdblp.xmlÖУ¬Í¬Ò»ÂÛÎĵĴæÔÚ¼¸¸öÍêÈ«ÏàͬµÄ<cite>£¬ËùÒÔÒª¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐд¦Àí¡£ÍøÉÏËѵ½Ò»¶Î´úÂ룺
1£© ²éѯijЩÊôÐÔÏàͬtupleµÄ·½·¨
select * from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
2£©É¾³ýijЩÊôÐÔÏàͬtupleµÄ·½·¨
delete from vitae a where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)
ÎÒÏÈÖ´ÐÐÁË1£¬ÊÇÔÚÒ»¸öÓÐ79£¬000Ìõ¼Ç¼µÄ±íÉÏÖ´Ðеġ£Êý·ÖÖÓºó£¨10·ÖÖÓÒÔÉÏ£©£¬½á¹û˳Àû³öÀ´¡£È»ºóÎÒÔڼǼÊýΪ212£¬273µÄ±íÉÏÖ´ÐÐ2£¬ºÜ¾ÃÖ®ºó»¹Ã»Óгö½á¹û¡£ÓÚÊÇÎÒÓÖÖ´ÐÐÁË1£©£¬·ÅÔÚ532£¬555Ìõ¼Ç¼µÄ±íÉÏ¡£ÕâÏÂÇé¿ö²»ÃµçÄÔÖ±½ÓËÀ»úÁË£¬cpu100%·è¿ñµØÔËת×Å¡£Õý³£¹Ø»ú¶¼²»ÐУ¬×îºóÖ»ºÃÇ¿Ðа´ÏÂÁ˹ػú¼ü¡£
ÖØÆôºó£¬ÎÒ²»ËÀÐÄ£¬ÔÚ532£¬555Ìõ¼Ç¼µÄ±íÖ´ÐÐ1¡£1.5Сʱ¹ýÈ¥ÁË£¬»¹Ã»Óнá¹û³öÏÖ¡£
¿´À´ÏÂÎçÒªºÃºÃÑо¿Ò»ÏÂsqlÔÚmysqlµÄÖ´ÐÐЧÂÊÁË¡£
2¡¢select into
MysqlÖв»Ö§³Öselect into tableµÄÓï·¨£¬µ«¿ÉÒÔÓÃÒÔÏÂ2¸öÓï¾äÌæ´ú¡£
1£©create table table_new (select * from table_old);
2£©insert into table_new(name,password...) select table_old.name, table_old.password from table_old where
table_old.name="ct";
Ïà¹ØÎĵµ£º
×ªÔØ×Ô£ºhttp://www.cnblogs.com/leonbao/archive/2008/03/07/1094821.html
¹ØÓÚSQL ServerÊý¾Ý¿âÉè¼ÆµÄ¸ÐÎò£¬ÇëÖ¸½Ì
ÓÐÎÊÌâµÄʱºò£¬ÎÒ¾³£»ØÀ´²©¿Í԰ѰÕҴ𰸣¬¾Ã¶ø¾ÃÖ®£¬×ܽáÁËһЩ¶«Î÷¡£
Íý×ԷƱ¡£¬Çë´ó¼Ò¶àÖ¸³ö´íÎ󣬲¢¸ø³öÒâ¼û
Êý¾Ý¿âÉè¼ÆÈý·¶Ê½»ù±¾ÔÔò
µÚÒ»·¶Ê½£ºÊý¾Ý¿â±íÖеÄ×ֶζ¼Êǵ¥Ò»ÊôÐԵ쬲»¿ÉÔÙ·Ö¡£Õâ ......
PERCONA PERFORMANCE CONFERENCE 2009ÉÏ£¬À´×ÔÑÅ»¢µÄ¼¸Î»¹¤³Ìʦ´øÀ´ÁËһƪ”Efficient Pagination Using MySQL“µÄ±¨¸æ£¬ÓкܶàÁÁµã£¬±¾ÎÄÊÇÔÚÔÎÄ»ù´¡ÉϵĽøÒ»²½ÑÓÉì¡£
Ê×ÏÈ¿´Ò»Ï·ÖÒ³µÄ»ù±¾ÔÀí£º
mysql> explain SELECT * from message ORDER BY id DESC LIMIT 10000, 20\G
***************** 1. row ** ......
Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ
1¡¢°ÑÖ÷¼ü¶¨ÒåΪ×Ô¶¯Ôö³¤±êʶ·ûÀàÐÍ
ÔÚmysqlÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪauto_incrementÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int auto_increment primary key not null, name varchar(15));
insert into customers(name) values("name1"),("nam ......
ʹÓÃSQL Serverµ¼Èë/µ¼³öExcel,°üº¬²¿·Ö´íÎóÐÅÏ¢´¦Àí·½·¨;
²Ù×÷ÊÖ¼Ç,Áô´Ë±¸²é
/*
µ¼Èë
*/
--´íÎóÐÅÏ¢ÈçÏÂʱ£º
--Msg 15281, Level 16, State 1, Line 2
--SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as ......
¡¾IT168 ¼¼Êõ·ÖÎö¡¿ÔÚÏò2009Äê¸æ±ðÖ®¼Ê£¬ÎÒÃÇÀ´»Ø¹ËһϹýÈ¥µÄÒ»ÄêÖÐ×îÊÜ»¶ÓµÄSQL Server¼¼ÇÉ£¬°üÀ¨ÁËOPENROWSET¡¢FILESTREAMµÈº¯ÊýµÄÓ÷¨¡¢ÃÜÂ빤¾ß½éÉÜÒÔ¼°DBAÈÕ³£¹¤×÷½¨ÒéµÈÄÚÈÝ¡£
¡¡¡¡Í¨¹ý¶ÔÕâЩ¾«»ªÎÄÕµÄÔٴλعˣ¬Ï£Íû¿ÉÒÔ°ïÖúÄúÊáÀíÒ»ÏÂÕâÒ»ÄêÒÔÀ´µÄ¹¤×÷ÒÔ¼°Ñ§Ï°Ðĵ㬶ÔδÀ´Ò»Äê¸ü½øÒ»²½´òϸü¼áʵµÄ»ù´¡¡£
¡¡¡ ......