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

mysqlµÄÅäÖÃÎļþmy.ini

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup option
# "--defaults-file".
#
# To run run the server from the command line, execute this in a
# command line shell, e.g.
# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# To install the server as a Windows service manually, execute this in a
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guildlines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the "--help" option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to speci


Ïà¹ØÎĵµ£º

mysqlÊý¾ÝË«Ïòͬ²½

2.»·¾³ËµÃ÷
2.1    Ó²¼þ»·¾³(Á½Ì¨»úÆ÷µÄÓ²¼þ»·¾³Ïàͬ)
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
Ó²ÅÌ´óС
8GB
ÆäËü˵Ã÷
±¾»úÆ÷ΪÐéÄâ»ú£¬ÆäÓÐÁ½¿éÍø¿¨£¬Ò»¶ÔÍø¿¨Ö±Á¬£¬Ò»¶Ô½ÓÈë½»»»»ú
 
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
......

mysqlÈ¡µÃÊý¾Ý¿âËùÓбíÃûºÍ×Ö¶Î×¢ÊÍ

1¡¢È¡×Ö¶Î×¢ÊÍ
Select COLUMN_NAME ÁÐÃû, DATA_TYPE ×Ö¶ÎÀàÐÍ, COLUMN_COMMENT ×Ö¶Î×¢ÊÍ
from INFORMATION_SCHEMA.COLUMNS
Where table_name = 'companies'##±íÃû
AND table_schema = 'testhuicard'##Êý¾Ý¿âÃû
AND column_name LIKE 'c_name'##×Ö¶ÎÃû
2¡¢È¡µÃ±í×¢ÊÍ
Select table_name ±íÃû,TABLE_COMMENT ±í×¢ÊÍ ......

mysql Ö´ÐжàÌõÓï¾ä

ÔÚ¿´ÏîÄ¿µÄÊÇ¿´µ½mysql°æ±¾µÄÏîÄ¿£¬·¢ÏÖÖ´ÐжàÌõsqlÓï¾äÊǶ¼ÊÇÏÈ·ÖÀëÒ»ÌõÌõµÄÊý¾Ý¿âÔÙÒ»ÌõÌõÖ´ÐУ¬ÎÒÏëÓ¦¸ÃÓа취һÌõÌõÖ´ÐеİÉ
ËùÒÔ½ñÌìÌØÒâµÄ²éÕÒÁËÒ»ÏÂ
ÔÚjdbcÏÂ˵¿ÉÒÔÉèÖÃÁ¬½Ó×Ö·û´®µÄʱºòÉèÖÃÒ»ÏÂ
ÉèÖóÉÈçÏ嵀 jdbc:mysql://192.168.3.180/sample?user=root&password=&allowMultiQueries=true
¾Í¿ÉÒÔÖ´Ð ......

ORACLE Óë mysql µÄÇø±ð

1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow
databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚ
ORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼­±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ²¿É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ