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

mysql ÃüÁîʹÓÃ

mysql ÃüÁîѧϰ£º
1. mysql -uroot  ;
2.mysql -h ip -ubusiusr -pbusiusr newdrmdb;
3.show databases ;                 //ÏÔʾËùÓеÄÊý¾Ý¿â ;
4.show tables ;                       //ÏÔʾËùÓеıí ;
5.set names gbk ;                   //ÉèÖÃ×Ö·û¼¯ ;
6.desc tmonthfees201004 ;    //ÏÔʾ±í½á¹¹ ;
7.alter table tcontents change cVersion cVersion varchar(128) null ;   //ÐÞ¸Ämysql±íÖÐ×ֶεÄÊôÐÔ ;
8. show index from tcontents from newdrmdb;
    show index from newdrmdb.tcontents ;
    show keys from tcontents ;                         
    show indexes from tcontents ;                     //²é¿´±íµÄË÷Òý ;


Ïà¹ØÎĵµ£º

±¸·ÝMySQLÐèÒªÖªµÀµÄÊ®¼þÊÂ

ÄãʹÓùý±ðÈ˵ı¸·Ý·½°¸À´±¸·ÝÄãµÄMySQLÊý¾ÝÂð?ÄãÓÐ¶à¹ØÐÄÄãµÄÊý¾Ý?Äã¸ÒÈ·¶¨ÄãÏÖÔÚÕýÔÚÔËÐеĽű¾¾ÍÊǿɿ¿µÄ£¬¿É»Ö¸´µÄ±¸·Ý£¬¶øÇÒÔÚÔËÐйý³ÌÖв»»áÓ°ÏìÄãµÄ¹Ø¼ü×÷ÒµÂð?ÔڻشðÕâ¸öÎÊÌâ֮ǰ£¬ÏȻشðÏÂÃæÊ®¸öÎÊÌâ°É£º
¡¡¡¡1. ±¸·ÝÒªÇóÍ£Ö¹Êý¾Ý¿âÂð?Èç¹û²»ÐèÒª£¬ÄÇô±¸·ÝµÄʱºò»áÓ°Ïìʲô?¿éÉ豸?I/O¸ºÔØ?»º³å?»òÕßÊÇÆäËû?
¡¡ ......

OracleºÍMySQL¡¢PostgreSQLÌØÐÔ¶Ô±È

¡¡Ëæ×ÅÏÖ´úÊý¾Ý¿â¿ÉÓÃÌØÕ÷¼¯µÄѸËÙÔö¼Ó£¬ºÜÄÑÇø·ÖÊëºÃÊ뻵¡£ÀýÈçOracleÀï¾ÍÓÐÐí¶àÄã¿ÉÄÜ´ÓÀ´¶¼²»ÐèÒªµÄ¸ß¼¶Êý¾Ý²Ö¿âÌØÕ÷¡£´ËÍâÒ²¿ÉÄÜÓÐһЩÆäËü²»¿É»òȱµÄÌØÕ÷±ÈÈçACIDÊÂÎñÌØÐÔ¡£ÎÒÃÇÀ´¿´Ò»¿´Ö÷ÒªµÄÒ»Ð©ÌØÕ÷£¬±ÈÈç´æ´¢¹ý³Ì£¬ÊÓͼ£¬¿ìÕÕ£¬±íÊý¾ÝÀàÐͺÍÊÂÎñµÈµÈ¡£Í¬Ê±ÎÒÃÇ·ÖÎöÒ»ÏÂPostgresql£¬MySQLºÍOracleÕ⼸¸öÊý¾Ý¿â£¬È»º ......

mysql ×Ó²éѯɾ³ý¼Ç¼

    mysql ¿ÉÒÔͨ¹ý×Ó²éѯµÃµ½ÒªÉ¾³ýµÄ¼Ç¼Ìõ¼þ£¬È»ºóͨ¹ý×Ó²éѯµÃ½á¹ûÆ¥ÅäҪɾ³ýµÄ¼Ç¼¡£µ«ÊÇ mysql ²»ÄÜÖ±½Óɾ³ý×Ó²éѯ±íÖеÄÊý¾Ý£¬±ØÐëͨ¹ýÒ»¸öÁÙʱ±íÀ´½â¾ö¡£ÀýÈ磺
    delete from t_transaction where exists
    (select d.* from t_ti_category a,t_category b,t_ ......

Mysql ¹Ø¼ü×Ö ±£Áô×Ö

Mysql ¹Ø¼ü×Ö-±£Áô×Ö
ÔÚpowerdesignerÉè¼ÆµÄʱºòÓÃÁ˹ؼü×Ö£¬Éú³É³ö´í£¬ºÜ囧¡£¡£¡£
 
 
 
 
 
ADD
ALL
ALTER
ANALYZE
AND
AS
ASC
ASENSITIVE
BEFORE
BETWEEN
BIGINT
BINARY
BLOB
BOTH
BY
CALL
CASCADE
CASE
CHANGE
CHAR
CHARACTER
CHECK
COLLATE
COLUMN
CON ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ