È¡mysql±íºÍ×Ö¶Î×¢ÊÍ
È¡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 ±í×¢ÊÍ from INFORMATION_SCHEMA.TABLES Where table_schema = 'testhuicard' ##Êý¾Ý¿âÃû
AND table_name LIKE 'companies'##±íÃû
²Î¿¼http://dev.mysql.com/doc/refman/5.1/zh/information-schema.html.
mysqlÊֲ᣺23.1. INFORMATION_SCHEMA±í
3¡¢È¡µÃijÊý¾Ý¿âÏÂËùÓбíµÄ×¢ÊÍ
$tt = mysql_query("show table status;");
$table_info£½array();
while($re = mysql_fetch_array($tt,MYSQL_ASSOC)){
//$re["Comment"],Õâ¸ö¾ÍÊDZíµÄ×¢ÊÍ
$table_info[] = $re;
}
Ïà¹ØÎĵµ£º
Æô¶¯£ºnet start mySql;
¡¡¡¡½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
¡¡¡¡ÁгöÊý¾Ý¿â£ºshow databases;
¡¡¡¡Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
¡¡¡¡Áгö±í¸ñ£ºshow tables£»
¡¡¡¡ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
¡¡¡¡½¨Á¢Êý¾Ý¿â£ºsource fileName.txt;
¡¡¡¡Æ¥Åä× ......
MySQL×Ö·û´®ÁÐÀàÐÍÇø·Ö
1.
Ê×ÏÈCHAR, VARCHAR, TEXTºÍBINARY, VARBINARY, BLOBµÄÇø±ð£º
CHAR, VARCHAR, TEXT³ÆÎª·Ç¶þ½øÖÆ×Ö·û´®£»
BINARY, VARBINARY, BLOB³ÆÎª¶þ½øÖÆ×Ö·û´®£»
¶þ½øÖÆ×Ö·û´®ºÍ·Ç¶þ½øÖÆ×Ö·û´®µÄÇø±ðÊÇ£º
¶þ½øÖÆ×Ö·û´®°üº¬µÄÊÇ×Ö½Ú×Ö·û´®£¬·Ç¶þ½øÖÆ×Ö·û´®°üº¬µÄÊÇ×Ö·û×Ö·û´®£»
ºóÕß¿ÉÒÔ¶¨Òå×Ö·û¼ ......
Weblogic 9.1µÄdomainÅäÖÃmysqlÁ¬½Ó³Ø
¡¡¡¡±¾ÎĽéÉÜÔÚweblogic 9.1ϵÄdomainÅäÖÃmysqlÁ¬½Ó³Ø²½Ö裺
¡¡¡¡1.ÔÚweblogicĿ¼ÏµÄserverlibÏÂÌí¼ÓmysqlÇý¶¯
¡¡¡¡mysql-connector-java-3.1.11-bin.jar
¡¡¡¡2.ÔÚweblogicĿ¼ÏµÄcommoninÏÂÕÒµ½commEnv.cmd´ò¿ª
¡¡¡¡ÕÒµ½set weblogic_classpath= ºó±ß¼ÓÉÏmysqlÇý¶¯ ......
±¾ÎÄ×ªÔØ×Ô£ºhttp://hi.baidu.com/xiaoxiaolq/blog/item/7984dcbf15dd030018d81f27.html
MyISAMºÍInnoDBÊÇÔÚʹÓÃMySQL×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDBÀàÐ͸ü¿ì£¬µ«ÊDz»Ìá¹©Ê ......
GRANT ALL PRIVILEGES
1¡£ ¸Ä±í·¨¡£¿ÉÄÜÊÇÄãµÄÕʺŲ»ÔÊÐí´ÓÔ¶³ÌµÇ½£¬Ö»ÄÜÔÚlocalhost¡£Õâ¸öʱºòÖ»ÒªÔÚlocalhostµÄÄÇ̨µçÄÔ£¬µÇÈëmysqlºó£¬¸ü¸Ä "mysql" Êý¾Ý¿âÀïµÄ "user" ±íÀïµÄ "host" Ï´Ó"localhost"¸Ä³Æ"%"
Sql´úÂë ¸´ÖÆ´úÂë
1. mysql -u root -pvmwaremysql>use mysql;
  ......