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";
Ïà¹ØÎĵµ£º
±¾ÎĽÚÑ¡×ÔMSDNµÄÎÄÕ¡¶ÎåÖÖÌá¸ß SQL ÐÔÄܵķ½·¨¡·£¬Ìá³öÈçºÎÌá¸ß»ùÓÚSQL ServerÓ¦ÓóÌÐòµÄÔËÐÐЧÂÊ£¬·Ç³£ÖµµÃÍÆ¼ö¡£¶ÔһЩTrafficºÜ¸ßµÄÓ¦ÓÃϵͳ¶øÑÔ£¬ÈçºÎÌá¸ßºÍ¸Ä½øSQLÖ¸ÁÊǷdz£ÖØÒªµÄ£¬Ò²ÊÇÒ»¸öºÜºÃµÄÍ»ÆÆµã¡£
*ÎÄÕÂÖ÷Òª°üÀ¨ÈçÏÂһЩÄÚÈÝ£¨Èç¸ÐÐËȤ£¬ÇëÖ±½Ó·ÃÎÊÏÂÃæµÄURLÔĶÁÍêÕûµÄÖÐÓ¢ÎÄÎĵµ£©£º
1, ´Ó INSE ......
1. ¼ò½é
ÔÚWebÓ¦ÓóÌÐòÌåϵ¼Ü¹¹ÖУ¬Êý¾Ý³Ö¾Ã²ã£¨Í¨³£ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â£©ÊǹؼüµÄºËÐIJ¿·Ö£¬Ëü¶ÔϵͳµÄÐÔÄÜÓзdz£ÖØÒªµÄÓ°Ïì¡£MySQLÊÇĿǰʹÓÃ×î¶àµÄ¿ªÔ´Êý¾Ý¿â£¬µ«ÊÇMySQLÊý¾Ý¿âµÄĬÈÏÉèÖÃÐÔÄܷdz£µÄ²î£¬½ö½öÊÇÒ»¸öÍæ¾ßÊý¾Ý¿â¡£Òò´ËÔÚ²úÆ·ÖÐʹÓÃMySQLÊý¾Ý¿â±ØÐë½øÐбØÒªµÄÓÅ»¯¡£
ÓÅ»¯ÊÇÒ»¸ö¸´ÔÓµÄÈÎÎñ£¬±¾ÎÄÃèÊöMySQLÏ ......
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 ......
1.reverse(str)º¯Êý: ·µ»Øµßµ¹×Ö·û˳ÐòµÄ×Ö·û´®str, ¸Ãº¯Êý¶Ô¶à×Ö½Ú¿É¿¿µÄ.
mysql> select * from user;
+----+------------------+
| id | name |
+----+------------------+
| 1 | test &nbs ......
ǰÑÔ
±¾ÎĵµÖ÷Òª½éÉÜÓëSQLµ÷ÕûÓйصÄÄÚÈÝ£¬ÄÚÈÝÉæ¼°¶à¸ö·½Ã棺SQLÓï¾äÖ´ÐеĹý³Ì¡¢ORACLEÓÅ»¯Æ÷£¬±íÖ®¼äµÄ¹ØÁª£¬ÈçºÎµÃµ½SQLÖ´Ðмƻ®£¬ÈçºÎ·Ö ÎöÖ´Ðмƻ®µÈÄÚÈÝ£¬´Ó¶øÓÉdzµ½ÉîµÄ·½Ê½Á˽âSQLÓÅ»¯µÄ¹ý³Ì£¬Ê¹´ó¼ÒÖð²½²½ÈëSQLµ÷ÕûÖ®ÃÅ£¬È»ºóÄ㽫·¢ÏÖ……¡£
&nb ......