´ÓOracle¡¢SQLServerÖÐÈ¡µÃ×¢ÊÍ
¸ù¾Ý±í½á¹¹Éú³ÉJavaÎļþµÄ¹¤¾ß£¬ÔÚÈ¡µÃ±íµÄ×Ö¶ÎʱÈçºÎÈ¡µÃ±íµÄ¸÷ÖÖÐÅÏ¢ºÍ×¢ÊÍ£¬¾¶à·½ËÑÑ°ÕÒµ½ÈçÏÂ×ÊÁϱ¸Ó㺠oracle£º
user_tab_comments;±í×¢ÊÍ
user_col_comments;±í×Ö¶Î×¢ÊÍ
ÒÔÉÏÁ½¸öÖ»ÄÜ»ñÈ¡×Ô¼ºÓû§µÄ±íµÄ×¢ÊÍÐÅÏ¢£¬Èç¹ûÒª·ÃÎÊ×Ô¼ºÄܹ»·ÃÎʵÄÆäËûÓû§µÄ±í£¬ÔòÐèҪʹÓãº
all_tab_comments;±í×¢ÊÍ
all_col_comments;±í×Ö¶Î×¢ÊÍ
µ±È»£¬Èç¹ûÓÐDBAȨÏÞ£¬Ôò¿ÉÒÔʹÓÃ
dba_tab_comments;±í×¢ÊÍ
dba_col_comments;±í×Ö¶Î×¢ÊÍ
dba*ºÍall*×îºÃÖ¸¶¨ownerÌõ¼þ¡£user*ûÓиÃ×Ö¶Î
user_tab_comments;±í×¢ÊÍ
user_col_comments;±í×Ö¶Î×¢ÊÍ
ÒÔÉÏÁ½¸öÖ»ÄÜ»ñÈ¡×Ô¼ºÓû§µÄ±íµÄ×¢ÊÍÐÅÏ¢£¬Èç¹ûÒª·ÃÎÊ×Ô¼ºÄܹ»·ÃÎʵÄÆäËûÓû§µÄ±í£¬ÔòÐèҪʹÓãº
all_tab_comments;±í×¢ÊÍ
all_col_comments;±í×Ö¶Î×¢ÊÍ
µ±È»£¬Èç¹ûÓÐDBAȨÏÞ£¬Ôò¿ÉÒÔʹÓÃ
dba_tab_comments;±í×¢ÊÍ
dba_col_comments;±í×Ö¶Î×¢ÊÍ
dba*ºÍall*×îºÃÖ¸¶¨ownerÌõ¼þ¡£user*ûÓиÃ×Ö¶Î
MSSQL£º
<PRE class=csharp name="code">select b.[value]
from syscolumns a left join sysproperties b on a.id=b.id
and a.colid=b.smallid inner join sysobjects c on a.id=c.id
and a.[name]='ÁÐÃû' and c.[name]='
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
´´½¨ÐµÄÓû§Ê±£¬ÒªÖ¸¶¨default tablespace£¬·ñÔòËü»á°Ñsystem±í¿Õ¼äµ±³É×Ô¼ºµÄȱʡ±í¿Õ¼ä¡£ÕâÑù×öÊDz»ÌᳫµÄ¡£¹À¼ÆÔÀ´´´½¨Ä³¸öÓû§µÄʱºòûÓÐÖ¸¶¨È±Ê¡±í¿Õ¼ä£¬¶øÏÖÔÚËüʹÓÃϵͳ±í¿Õ¼äµÄȨÏÞ±»DBA¸øÊÕ»ØÁË¡£
ÏÈÓõļòµ¥µÄ°ì·¨ÊÔÊÔ£¬Ò»°ãȱʡµÄORACLE°²× ......
Oracle SQLÓëANSI SQLÇø±ð
ÏàÐÅ´ó¼Ò¶¼Ê¹ÓùýSQL SERVER¡£½ñÌì¸ø´ó¼Ò¼òµ¥½éÉÜÒ»ÏÂOracle SQLÓëANSI SQLÇø±ð¡£Æäʵ£¬SQL SERVERÓëÓëANSI SQLÒ²ÓÐÇø±ð¡£
1¡¢Ê×ÏÈ´ó¼ÒÒªÃ÷°×ʲôÊÇANSI
ANSI£ºÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨American National Standards Institute£©¡£µ±Ê±£¬ÃÀ¹úµÄÐí¶àÆóÒµºÍרҵ¼¼ÊõÍÅÌ壬ÒÑ¿ªÊ¼Á˱ê×¼»¯¹¤×÷£¬µ«Òò±Ë ......
mysql ´ó¶ÔÏó´æÈ¡:
ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
mediumblodÊÇ24´Î·½,
Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL varName=value.
linux°æ± ......