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

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";


Ïà¹ØÎĵµ£º

ÎåÖÖÌá¸ß SQL ÐÔÄܵķ½·¨

±¾ÎĽÚÑ¡×ÔMSDNµÄÎÄÕ¡¶ÎåÖÖÌá¸ß SQL ÐÔÄܵķ½·¨¡·£¬Ìá³öÈçºÎÌá¸ß»ùÓÚSQL ServerÓ¦ÓóÌÐòµÄÔËÐÐЧÂÊ£¬·Ç³£ÖµµÃÍÆ¼ö¡£¶ÔһЩTrafficºÜ¸ßµÄÓ¦ÓÃϵͳ¶øÑÔ£¬ÈçºÎÌá¸ßºÍ¸Ä½øSQLÖ¸ÁÊǷdz£ÖØÒªµÄ£¬Ò²ÊÇÒ»¸öºÜºÃµÄÍ»ÆÆµã¡£
*ÎÄÕÂÖ÷Òª°üÀ¨ÈçÏÂһЩÄÚÈÝ£¨Èç¸ÐÐËȤ£¬ÇëÖ±½Ó·ÃÎÊÏÂÃæµÄURLÔĶÁÍêÕûµÄÖÐÓ¢ÎÄÎĵµ£©£º
1, ´Ó INSE ......

MySQLÐÔÄÜÓÅ»¯

1. ¼ò½é

ÔÚWebÓ¦ÓóÌÐòÌåϵ¼Ü¹¹ÖУ¬Êý¾Ý³Ö¾Ã²ã£¨Í¨³£ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â£©ÊǹؼüµÄºËÐIJ¿·Ö£¬Ëü¶ÔϵͳµÄÐÔÄÜÓзdz£ÖØÒªµÄÓ°Ïì¡£MySQLÊÇĿǰʹÓÃ×î¶àµÄ¿ªÔ´Êý¾Ý¿â£¬µ«ÊÇMySQLÊý¾Ý¿âµÄĬÈÏÉèÖÃÐÔÄܷdz£µÄ²î£¬½ö½öÊÇÒ»¸öÍæ¾ßÊý¾Ý¿â¡£Òò´ËÔÚ²úÆ·ÖÐʹÓÃMySQLÊý¾Ý¿â±ØÐë½øÐбØÒªµÄÓÅ»¯¡£
ÓÅ»¯ÊÇÒ»¸ö¸´ÔÓµÄÈÎÎñ£¬±¾ÎÄÃèÊöMySQLÏ ......

Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ


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 ......

MySQL³£¼û×Ö·û´®º¯Êýѧϰ

1.reverse(str)º¯Êý: ·µ»Øµßµ¹×Ö·û˳ÐòµÄ×Ö·û´®str, ¸Ãº¯Êý¶Ô¶à×Ö½Ú¿É¿¿µÄ.
mysql> select * from user;
+----+------------------+
| id | name             |
+----+------------------+
|  1 | test      &nbs ......

ͨ¹ý·ÖÎöSQLÓï¾äµÄÖ´Ðмƻ®ÓÅ»¯SQL

ǰÑÔ
      ±¾ÎĵµÖ÷Òª½éÉÜÓëSQLµ÷ÕûÓйصÄÄÚÈÝ£¬ÄÚÈÝÉæ¼°¶à¸ö·½Ã棺SQLÓï¾äÖ´ÐеĹý³Ì¡¢ORACLEÓÅ»¯Æ÷£¬±íÖ®¼äµÄ¹ØÁª£¬ÈçºÎµÃµ½SQLÖ´Ðмƻ®£¬ÈçºÎ·Ö ÎöÖ´Ðмƻ®µÈÄÚÈÝ£¬´Ó¶øÓÉdzµ½ÉîµÄ·½Ê½Á˽âSQLÓÅ»¯µÄ¹ý³Ì£¬Ê¹´ó¼ÒÖð²½²½ÈëSQLµ÷ÕûÖ®ÃÅ£¬È»ºóÄ㽫·¢ÏÖ……¡£
   &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ