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

¹Ì¶¨³¤¶È(char)Óë¿É±ä³¤¶È(varchar)×Ö·ûÊý¾ÝÀàÐÍ
char[(n)]
³¤¶ÈΪn¸ö×ֽڵĹ̶¨³¤¶ÈÇÒ·ÇUnicodeµÄ×Ö·ûÊý¾Ý¡£n±ØÐëÊÇÒ»¸ö½éÓÚ1ºÍ8,000Ö®¼äµÄÊýÖµ¡£´æ´¢´óСΪn¸ö×Ö½Ú¡£charÔÚSQL-92ÖеÄͬÒå´ÊΪcharacter¡£
varchar[(n)]
³¤¶ÈΪn¸ö×ֽڵĿɱ䳤¶ÈÇÒ·ÇUnicodeµÄ×Ö·ûÊý¾Ý¡£n±ØÐëÊÇÒ»¸ö½éÓÚ1ºÍ8,000Ö®¼äµÄÊýÖµ¡£´æ´¢´óСΪ ......

SQL ÈçºÎɾ³ýÊý¾Ý±íÖÐÖØ¸´µÄÊý¾Ý£¿

¡¾ÒýÓãºÃÍáï¼¼ÊõÎÄÕÂÕªÒª
¡¿
¾­²âÊÔ£¬·½·¨¶þ¿É³É¹¦É¾³ýÊý¾Ý£¬·½·¨Ò»¡¢Èý ɾ³ýÊý¾Ýʧ°Ü¡£Çë·¹ýµÄÅóÓÑ£¬Ö¸µãÃÔ½ò¡£¡£¡£
ÎÊÌ⣺һ¸ö±íÓÐ×ÔÔöµÄID
ÁУ¬±íÖÐÓÐһЩ¼Ç¼ÄÚÈÝÖØ¸´£¬Ò²¾ÍÊÇ˵ÕâЩ¼Ç¼³ýÁËID
²»Í¬Ö®Í⣬ÆäËûµÄÐÅÏ¢¶¼Ïàͬ¡£ÐèÒª°ÑÖØ¸´µÄ¼Ç¼±£ÁôÒ»Ìõ£¬Ê£ÏµÄɾ³ý
 
·½·¨Ò»£º»¹ÊÇ2000
ÄêµÄʱºòһλOracl ......

MySQLµÄ×ÔÔö×Ö¶Î


1.¹Ø¼ü×Ö 
auto_increment
2.×ÔÔöÓ÷¨ 
Àý: 
CREATE TABLE animals ( id mediumint not null auto_increment, 
name char(30) not null, 
primary key (id));
3.¹ØÓÚ×ÔÔö
Q:Ôõô»ñµÃµ±Ç°µÄ×ÔÔöµÄ×î´óÖµ?
A:select @@identity
Q:Ôõô»ñµÃtableµÄµ±Ç°×ÔÔö×î´óÖµ? 
A:select max(i ......

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

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

LINUXÏÂmysql¿Í»§¶Ë²»ÄÜÊäÈëÖÐÎÄ

LINUXÏ mysql¿Í»§¶Ë²»ÄÜÊäÈëÖÐÎÄ
½ñÌìÓöµ½ÁËÕâ¸öÎÊÌ⣬ÔÚLINUXÏÂÊäÈëÖÐÎÄ£¬Ã»ÓÐÎÊÌ⣬µ«ÔÚMYSQL¿Í»§¶ËÉÏÎÞ·¨ÊäÈëÖÐÎÄ£¬ºÜÆæ¹Ö£¿
ÕÒÁ˺ܶà×ÊÁÏÖÕÓÚ½â¾öÁËÕâ¸öÎÊÌ⣬ÆäʵÕâ¸öºÍ×Ö·û¼¯Î޹ء£Í¨³£³öÏÖÔÚ×Ô¼º±àÒëµÄmysql°æ±¾ÉÏ£¬Èç¹ûÊÇREDHATµÄ»°£¬ÇëʹÓÃϵͳ×Ô´øMYSQL¿Í»§¶Ë¡£ÏµÍ³Ä¬ÈÏrpm°²×°µÄmysqlÔòûÓÐÕâ¸öÎÊÌâ³öÏÖ¡£
Á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ