{"id":1299,"date":"2017-01-28T21:01:48","date_gmt":"2017-01-28T13:01:48","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=1299"},"modified":"2017-01-28T21:30:27","modified_gmt":"2017-01-28T13:30:27","slug":"mysql-ocp-07-%e8%8e%b7%e5%8f%96%e5%85%83%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=1299","title":{"rendered":"MySQL OCP-07-\u83b7\u53d6\u5143\u6570\u636e"},"content":{"rendered":"
—\u00a0\u5143\u6570\u636e\u8bbf\u95ee\u65b9\u6cd5;<\/div>\n
1.\u4ec0\u4e48\u662f\u5143\u6570\u636e:\u6570\u636e\u5e93\u662f\u6570\u636e\u7684\u7ed3\u6784\u5316\u96c6\u5408,\u5143\u6570\u636e\u662f\u201c\u6709\u5173\u6570\u636e\u7684\u6570\u636e\u201d;<\/div>\n
2.MySQL\u901a\u8fc7\u4ee5\u8bbf\u95ee\u5143\u6570\u636e\u7684\u65b9\u6cd5:<\/div>\n
\u00a0 \u00a0 1.INFORMATION_SCHEMA:MySQL\u670d\u52a1\u5668\u5305\u542b\u4e00\u4e2a\u88ab\u5b9e\u73b0\u4e3a\u540d\u4e3aINFORMATION_SCHEMA\u7684\u6570\u636e\u5e93(\u6a21\u5f0f)\u7684\u6570\u636e\u5b57\u5178,\u5176\u4e2d\u5305\u542b\u8bb8\u591a\u663e\u793a\u4e3a\u8868\u7684\u5bf9\u8c61;<\/div>\n
\u00a0 \u00a0 2.SHOW\u8bed\u53e5:\u7528\u4e8e\u83b7\u53d6\u670d\u52a1\u5668\u7edf\u8ba1\u4fe1\u606f,\u6a21\u5f0f\u548c\u6a21\u5f0f\u5bf9\u8c61\u7684\u76f8\u5173\u6570\u636e\u7684\u4e13\u7528\u8bed\u6cd5;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.SHOW\u00a0DATABASES\u548cSHOW\u00a0TABLES:\u8fd4\u56de\u5305\u542b\u6570\u636e\u5e93\u548c\u8868\u540d\u7684\u5217\u8868;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.SHOW\u00a0COLUMNS:\u751f\u6210\u8868\u4e2d\u5217\u7684\u5b9a\u4e49;SHOW\u00a0COLUMNS\u00a0FROM\u00a0table\u7b49\u4e8eDESC\u00a0table;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.\u9700\u8981\u6709SELECT\u7279\u6743\u624d\u80fd\u4f7f\u7528SHOW\u8bed\u53e5;<\/div>\n
\u00a0 \u00a0 3.DESCRIBE:\u53ef\u7528\u4e8e\u68c0\u67e5\u8868\u7ed3\u6784\u548c\u5217\u5c5e\u6027\u7684SQL\u8bed\u53e5\u5feb\u6377\u65b9\u5f0f;<\/div>\n
\u00a0 \u00a0 4.mysqlshow:\u7528\u4f5c\u6307\u5411\u4e00\u4e9bSHOW\u8bed\u53e5\u7684\u547d\u4ee4\u884c\u524d\u7aef\u7684\u5ba2\u6237\u673a\u7a0b\u5e8f;<\/div>\n
<\/div>\n
—\u00a0INFORMATION_SCHEMA\u6570\u636e\u5e93;<\/div>\n
—\u00a0INFORMATION_SCHEMA\u8868;<\/div>\n
1.\u8868\u4fe1\u606f<\/div>\n
\u00a0 \u00a0 \u2022\u00a0COLUMNS:\u8868\u548c\u89c6\u56fe\u4e2d\u7684\u5217<\/div>\n
\u00a0 \u00a0 \u2022\u00a0ENGINES:\u5b58\u50a8\u5f15\u64ce<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SCHEMATA:\u6570\u636e\u5e93<\/div>\n
\u00a0 \u00a0 \u2022\u00a0TABLES:\u6570\u636e\u5e93\u4e2d\u7684\u8868<\/div>\n
\u00a0 \u00a0 \u2022\u00a0VIEWS:\u6570\u636e\u5e93\u4e2d\u7684\u89c6\u56fe<\/div>\n
2.\u5206\u533a<\/div>\n
\u00a0 \u00a0 \u2022\u00a0PARTITIONS:\u8868\u5206\u533a<\/div>\n
\u00a0 \u00a0 \u2022\u00a0FILES:\u5b58\u50a8\u00a0MySQL\u00a0NDB\u00a0\u78c1\u76d8\u6570\u636e\u8868\u7684\u6587\u4ef6<\/div>\n
3.\u7279\u6743<\/div>\n
\u00a0 \u00a0 \u2022\u00a0COLUMN_PRIVILEGES:MySQL\u00a0\u7528\u6237\u5e10\u6237\u6240\u62e5\u6709\u7684\u5217\u7279\u6743<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SCHEMA_PRIVILEGES:MySQL\u00a0\u7528\u6237\u5e10\u6237\u6240\u62e5\u6709\u7684\u6570\u636e\u5e93\u7279\u6743<\/div>\n
\u00a0 \u00a0 \u2022\u00a0TABLE_PRIVILEGES:MySQL\u00a0\u7528\u6237\u5e10\u6237\u6240\u62e5\u6709\u7684\u8868\u7279\u6743<\/div>\n
\u00a0 \u00a0 \u2022\u00a0USER_PRIVILEGES:MySQL\u00a0\u7528\u6237\u5e10\u6237\u6240\u62e5\u6709\u7684\u5168\u5c40\u7279\u6743<\/div>\n
4.\u5b57\u7b26\u96c6\u652f\u6301<\/div>\n
\u00a0 \u00a0 \u2022\u00a0CHARACTER_SETS:\u53ef\u7528\u7684\u5b57\u7b26\u96c6<\/div>\n
\u00a0 \u00a0 \u2022\u00a0COLLATIONS:\u6bcf\u4e2a\u5b57\u7b26\u96c6\u7684\u6392\u5e8f<\/div>\n
\u00a0 \u00a0 \u2022\u00a0COLLATION_CHARACTER_SET_APPLICABILITY:\u9002\u7528\u4e8e\u7279\u5b9a\u5b57\u7b26\u96c6\u7684\u6392\u5e8f<\/div>\n
5.\u7ea6\u675f\u548c\u7d22\u5f15<\/div>\n
\u00a0 \u00a0 \u2022\u00a0KEY_COLUMN_USAGE:\u5173\u952e\u5217\u7684\u7ea6\u675f<\/div>\n
\u00a0 \u00a0 \u2022\u00a0REFERENTIAL_CONSTRAINTS:\u5916\u952e<\/div>\n
\u00a0 \u00a0 \u2022\u00a0STATISTICS:\u8868\u7d22\u5f15<\/div>\n
\u00a0 \u00a0 \u2022\u00a0TABLE_CONSTRAINTS:\u8868\u7684\u7ea6\u675f<\/div>\n
6.\u670d\u52a1\u5668\u8bbe\u7f6e\u548c\u72b6\u6001<\/div>\n
\u00a0 \u00a0 \u2022\u00a0KEY_COLUMN_USAGE:\u7ea6\u675f<\/div>\n
\u00a0 \u00a0 \u2022\u00a0GLOBAL_STATUS:\u6240\u6709\u00a0MySQL\u00a0\u8fde\u63a5\u7684\u72b6\u6001\u503c<\/div>\n
\u00a0 \u00a0 \u2022\u00a0GLOBAL_VARIABLES:\u7528\u4e8e\u65b0\u7684\u00a0MySQL\u00a0\u8fde\u63a5\u7684\u503c<\/div>\n
\u00a0 \u00a0 \u2022\u00a0PLUGINS:\u670d\u52a1\u5668\u63d2\u4ef6<\/div>\n
\u00a0 \u00a0 \u2022\u00a0PROCESSLIST:\u6307\u793a\u54ea\u4e9b\u7ebf\u7a0b\u6b63\u5728\u8fd0\u884c<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SESSION_STATUS:\u5f53\u524d\u00a0MySQL\u00a0\u8fde\u63a5\u7684\u72b6\u6001\u503c<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SESSION_VARIABLES:\u5f53\u524d\u00a0MySQL\u00a0\u8fde\u63a5\u7684\u751f\u6548\u503c<\/div>\n
7.\u4f8b\u7a0b\u53ca\u76f8\u5173\u4fe1\u606f<\/div>\n
\u00a0 \u00a0 \u2022\u00a0EVENTS:\u9884\u5b9a\u4e8b\u4ef6<\/div>\n
\u00a0 \u00a0 \u2022\u00a0ROUTINES:\u5b58\u50a8\u8fc7\u7a0b\u548c\u529f\u80fd<\/div>\n
\u00a0 \u00a0 \u2022\u00a0TRIGGERS:\u6570\u636e\u5e93\u4e2d\u7684\u89e6\u53d1\u5668<\/div>\n
\u00a0 \u00a0 \u2022\u00a0PARAMETERS:\u5b58\u50a8\u8fc7\u7a0b\u548c\u529f\u80fd\u53c2\u6570\u4ee5\u53ca\u5b58\u50a8\u51fd\u6570<\/div>\n
8.InnoDB<\/div>\n
\u00a0 \u00a0 \u2022\u00a0INNODB_CMP\u00a0\u548c\u00a0INNODB_CMP_RESET:\u5bf9\u538b\u7f29\u7684\u00a0InnoDB\u00a0\u8868\u7684\u76f8\u5173\u64cd\u4f5c\u7684\u72b6\u6001<\/div>\n
\u00a0 \u00a0 \u2022\u00a0INNODB_CMPMEM\u00a0\u548c\u00a0INNODB_CMPMEM_RESET:InnoDB\u00a0\u7f13\u51b2\u6c60\u4e2d\u538b\u7f29\u9875\u9762\u7684\u72b6\u6001<\/div>\n
\u00a0 \u00a0 \u2022\u00a0INNODB_LOCKS:InnoDB\u00a0\u4e8b\u52a1\u6240\u8bf7\u6c42\u548c\u6301\u6709\u7684\u6bcf\u4e2a\u9501<\/div>\n
\u00a0 \u00a0 \u2022\u00a0INNODB_LOCK_WAITS:\u6bcf\u4e2a\u963b\u585e\u7684\u00a0InnoDB\u00a0\u4e8b\u52a1\u7684\u4e00\u4e2a\u6216\u591a\u4e2a\u884c\u9501<\/div>\n
\u00a0 \u00a0 \u2022\u00a0INNODB_TRX:\u5f53\u524d\u6b63\u5728\u00a0InnoDB\u00a0\u5185\u90e8\u6267\u884c\u7684\u6240\u6709\u4e8b\u52a1<\/div>\n
\u00a0 \u00a0 \u2022\u00a0TABLESPACES:\u6d3b\u52a8\u7684\u8868\u7a7a\u95f4<\/div>\n
<\/div>\n
—\u00a0INFORMATION_SCHEMA\u8868\u5217;<\/div>\n
—\u00a0\u5bf9INFORMATION_SCHEMA\u4f7f\u7528SELECT;<\/div>\n
—\u00a0INFORMATION_SCHEMA\u793a\u4f8b;<\/div>\n
1.\u663e\u793a\u7528\u4e8e\u7ed9\u5b9a\u6570\u636e\u5e93\u4e2d\u8868\u7684\u5b58\u50a8\u5f15\u64ce;<\/div>\n
2.\u67e5\u627e\u6240\u6709\u5305\u542bSET\u5217\u7684\u8868;<\/div>\n
3.\u663e\u793a\u6bcf\u4e2a\u5b57\u7b26\u96c6\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219;<\/div>\n
4.\u663e\u793a\u6bcf\u4e2a\u6570\u636e\u5e93\u4e2d\u8868\u7684\u7f16\u53f7;<\/div>\n
5.INFORMATION_SCHEMA\u8868\u662f\u53ea\u8bfb\u7684,\u65e0\u6cd5\u7528INSERT\/DELETE\/UPDATE\u4e4b\u7c7b\u7684\u8bed\u53e5\u8fdb\u884c\u4fee\u6539;\u5982\u679c\u6267\u884c\u8fd9\u4e9b\u7c7b\u578b\u7684\u8bed\u53e5\u4ee5\u5c1d\u8bd5\u66f4\u6539INFORMATION_SCHEMA\u8868\u4e2d\u7684\u6570\u636e,\u670d\u52a1\u5668\u5c06\u751f\u6210\u9519\u8bef;<\/div>\n
<\/div>\n
—\u00a0\u4f7f\u7528INFORMATION_SCHEMA\u8868\u521b\u5efaShell\u547d\u4ee4;<\/div>\n
1.\u672c\u5e7b\u706f\u7247\u4e2d\u7684\u793a\u4f8b\u6240\u793a,SQL\u8bed\u53e5\u5c06\u751f\u6210\u4e00\u6761\u8f93\u51fa,\u4ec5\u5bfc\u51faworld_innodb\u6570\u636e\u5e93\u4e2d\u90a3\u4e9b\u4ee5\u5355\u8bcd\u201cCountry\u201d\u5f00\u59cb\u7684\u7684\u8868;<\/div>\n
2.\u8f93\u51fa\u5c06\u751f\u6210\u53ef\u4ee5\u5728shell\u547d\u4ee4\u884c\u4e0a\u6b63\u786e\u6267\u884c\u7684shell\u811a\u672c;\u4e0b\u4e00\u6b65\u662f\u5c06\u6b64\u8f93\u51fa\u5b58\u50a8\u5728\u4e00\u4e2a\u53ef<\/div>\n
\u5728shell\u547d\u4ee4\u884c\u4e2d\u6267\u884c\u7684\u6279\u5904\u7406\u6587\u4ef6\u4e2d,\u8fd9\u901a\u8fc7\u6dfb\u52a0\u5b50\u53e5INTO\u00a0OUTFILE\u6765\u5b8c\u6210:<\/div>\n
\u00a0 \u00a0 SELECT\u00a0CONCAT(“mysqldump\u00a0-uroot\u00a0-pmysql\u00a0“,\u00a0TABLE_SCHEMA,\u00a0”\u00a0“,\u00a0TABLE_NAME,\u00a0”\u00a0>>\u00a0“,TABLE_SCHEMA,\u00a0“.sql”)<\/div>\n
\u00a0 \u00a0 FROM\u00a0TABLES\u00a0WHERE\u00a0TABLE_NAME\u00a0LIKE\u00a0‘Country%’<\/div>\n
\u00a0 \u00a0 INTO\u00a0OUTFILE\u00a0‘\\tmp\\Country_Dump.sh’;<\/div>\n
3.\u7136\u540e\u53ef\u4ee5\u5728\u547d\u4ee4\u884c\u4e2d\u6267\u884c\u6b64\u6587\u4ef6,\u547d\u4ee4\u884c\u5c06\u8fd0\u884c\u672c\u5e7b\u706f\u7247\u4e2d\u6240\u793a\u7684\u4e24\u4e2amysqldump\u547d\u4ee4:<\/div>\n
\u00a0 \u00a0 shell>\u00a0\\tmp\\Country_Dump.sh<\/div>\n
\u00a0 \u00a0 shell>\u00a0\\tmp\\mysqldump\u00a0-uroot\u00a0-pmysql\u00a0world_innodb\u00a0Country\u00a0>>\u00a0world_innodb.sql<\/div>\n
\u00a0 \u00a0 shell>\u00a0\\tmp\\mysqldump\u00a0-uroot\u00a0-pmysql\u00a0world_innodb\u00a0Country_Language\u00a0>>\u00a0world_innodb.sql<\/div>\n
<\/div>\n
—\u00a0\u4f7f\u7528INFORMATION_SCHEMA\u8868\u521b\u5efaSQL\u8bed\u53e5;<\/div>\n
1.\u672c\u5e7b\u706f\u7247\u4e2d\u7684\u793a\u4f8b\u4f7f\u7528mysql\u547d\u4ee4\u6267\u884c\u4e86\u4e00\u4e2a\u8bed\u53e5,\u4ee5\u5236\u4f5cworld_innodb\u6570\u636e\u5e93\u4e2d\u6240\u6709\u8868\u7684\u7cbe\u786e\u526f\u672c;<\/div>\n
\u00a0 \u00a0 1.–silent\u547d\u4ee4\u5728\u8f93\u51fa\u4e2d\u5220\u9664\u5217\u6807\u9898;<\/div>\n
\u00a0 \u00a0 2.–skip-column-names\u547d\u4ee4\u5220\u9664\u8f93\u51fa\u4e2d\u7684\u683c\u5f0f(\u4f7f\u8f93\u51fa\u7c7b\u4f3c\u4e8e\u8868\u7684\u683c\u5f0f);<\/div>\n
\u00a0 \u00a0 3.\u8fd9\u4e24\u4e2a\u547d\u4ee4\u7528\u6765\u786e\u4fdd\u5bf9\u547d\u4ee4\u81ea\u8eab\u7684\u89e3\u91ca\u662f\u6b63\u786e\u7684,\u6ca1\u6709\u4efb\u4f55\u5e72\u6270\u6267\u884c\u7684\u5916\u90e8\u683c\u5f0f\u6216\u6807\u9898\u884c\u95ee\u9898;<\/div>\n
2.\u6dfb\u52a0\u7ba1\u9053\u7b26\u53f7[|]\u5e76\u968f\u4e4b\u6267\u884cmysql\u547d\u4ee4\u4f1a\u5c06\u8fd9\u4e9bSQL\u8bed\u53e5\u53d1\u9001\u5230MySQL\u670d\u52a1\u5668\u4ee5\u4fbf\u6267\u884c:<\/div>\n
shell>\u00a0mysql\u00a0-uroot\u00a0-pmysql\u00a0–silent\u00a0–skip-column-names\u00a0-e\u00a0“SELECT\u00a0CONCAT(‘CREATE\u00a0TABLE\u00a0‘,\u00a0TABLE_SCHEMA,\u00a0‘.’,\u00a0TABLE_NAME,\u00a0‘_backup\u00a0LIKE\u00a0‘,\u00a0TABLE_SCHEMA,\u00a0‘.’,\u00a0TABLE_NAME,\u00a0‘;’)\u00a0FROM\u00a0INFORMATION_SCHEMA.TABLES\u00a0WHERE\u00a0TABLE_SCHEMA\u00a0=\u00a0‘world_innodb’;”\u00a0|\u00a0mysql\u00a0-uroot\u00a0-pmysql<\/div>\n
<\/div>\n
—\u00a0MySQL\u652f\u6301\u7684\u00a0SHOW\u00a0\u8bed\u53e5;<\/div>\n
1.\u9664\u4e86INFORMATION_SCHEMA\u8868\u4e4b\u5916,MySQL\u8fd8\u652f\u6301SHOW\u548cDESCRIBE\u8bed\u53e5,\u4f5c\u4e3a\u8bbf\u95ee\u5143\u6570\u636e\u7684\u5907\u9009\u65b9\u5f0f;<\/div>\n
2.SHOW\u548cDESCRIBE\u8bed\u6cd5\u4e0d\u5982\u4f7f\u7528INFORMATION_SCHEMA\u67e5\u8be2\u7075\u6d3b,\u4f46\u662f\u5bf9\u4e8e\u5927\u591a\u6570\u7528\u9014,SHOW\u548cDESCRIBE\u8bed\u6cd5\u5c31\u8db3\u591f\u4e86;\u5728\u8fd9\u4e9b\u60c5\u51b5\u4e0b,\u4f7f\u7528MySQL\u7279\u5b9a\u8bed\u6cd5\u901a\u5e38\u4f1a\u66f4\u5feb\u901f,\u7b80\u5355;<\/div>\n
3.\u53ef\u4ee5\u901a\u8fc7\u591a\u79cd\u5f62\u5f0f\u4f7f\u7528SHOW\u8bed\u53e5,\u5982\u4e0b\u6240\u793a:<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SHOW\u00a0DATABASES:\u5217\u51fa\u53ef\u7528\u6570\u636e\u5e93\u7684\u540d\u79f0<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SHOW\u00a0TABLES:\u5217\u51fa\u9ed8\u8ba4\u6570\u636e\u5e93\u4e2d\u7684\u8868<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SHOW\u00a0TABLES\u00a0FROM\u00a0<database_name>:\u5217\u51fa\u6307\u5b9a\u6570\u636e\u5e93\u4e2d\u7684\u8868<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SHOW\u00a0COLUMNS\u00a0FROM\u00a0<table_name>:\u663e\u793a\u8868\u7684\u5217\u7ed3\u6784<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SHOW\u00a0INDEX\u00a0FROM\u00a0<table_name>:\u663e\u793a\u8868\u4e2d\u6709\u5173\u7d22\u5f15\u548c\u7d22\u5f15\u5217\u7684\u4fe1\u606f<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SHOW\u00a0CHARACTER\u00a0SET:\u663e\u793a\u53ef\u7528\u7684\u5b57\u7b26\u96c6\u53ca\u5176\u9ed8\u8ba4\u6392\u5e8f<\/div>\n
\u00a0 \u00a0 \u2022\u00a0SHOW\u00a0COLLATION:\u663e\u793a\u6bcf\u4e2a\u5b57\u7b26\u96c6\u7684\u6392\u5e8f<\/div>\n
<\/div>\n
—\u00a0SHOW\u8bed\u53e5\u793a\u4f8b;<\/div>\n
mysql>\u00a0SHOW\u00a0DATABASES;<\/div>\n
mysql>\u00a0SHOW\u00a0TABLES;<\/div>\n
mysql>\u00a0SHOW\u00a0TABLES\u00a0FROM\u00a0mysql;<\/div>\n
mysql>\u00a0SHOW\u00a0TABLES\u00a0FROM\u00a0INFORMATION_SCHEMA;<\/div>\n
mysql>\u00a0SHOW\u00a0COLUMNS\u00a0FROM\u00a0CountryLanguage;<\/div>\n
mysql>\u00a0SHOW\u00a0FULL\u00a0COLUMNS\u00a0FROM\u00a0CountryLanguage\\G<\/div>\n
<\/div>\n
—\u00a0\u5176\u4ed6SHOW\u8bed\u53e5\u793a\u4f8b;<\/div>\n
—\u00a0DESCRIBE\u8bed\u53e5;<\/div>\n
1.DESC\u00a0table_name\u7b49\u6548\u4e8eSHOW\u00a0COLUMNS\u00a0FROM\u00a0table_name;\u4f46\u662f,SHOW\u00a0COLUMNS\u652f\u6301\u53ef\u9009\u7684LIKE\u548cWHERE\u5b50\u53e5,\u800cDESCRIBE\u4e0d\u652f\u6301;<\/div>\n
2.\u5f53\u6307\u5b9a\u8868\u540d\u79f0\u4f5c\u4e3a\u53c2\u6570\u65f6,EXPLAIN\u7b49\u6548\u4e8eDESCRIBE:mysql>\u00a0EXPLAIN\u00a0table_name;<\/div>\n
<\/div>\n
—\u00a0mysqlshow\u5ba2\u6237\u673a;<\/div>\n
1.mysqlshow\u5ba2\u6237\u673a\u4e3a\u5404\u79cd\u683c\u5f0f\u7684SHOW\u8bed\u53e5\u63d0\u4f9b\u4e86\u4e00\u4e2a\u547d\u4ee4\u884c\u754c\u9762,\u8fd9\u4e9b\u8bed\u53e5\u7528\u4e8e\u5217\u51fa\u6570\u636e\u5e93\u7684\u540d\u79f0,\u6570\u636e\u5e93\u4e2d\u7684\u8868\u6216\u6709\u5173\u8868\u5217\u6216\u7d22\u5f15\u7684\u4fe1\u606f;<\/div>\n
2.mysqlshow\u5ba2\u6237\u673a\u7684\u9009\u9879\u90e8\u5206\u53ef\u5305\u542b\u4efb\u4e00\u6807\u51c6\u8fde\u63a5\u53c2\u6570\u9009\u9879,\u4f8b\u5982–host\u6216–user;\u5982\u679c\u9ed8\u8ba4\u8fde\u63a5\u53c2\u6570\u4e0d\u9002\u5408,\u5219\u5fc5\u987b\u63d0\u4f9b\u9009\u9879;mysqlshow\u4e5f\u63a5\u53d7\u7279\u5b9a\u4e8e\u5176\u81ea\u8eab\u8fd0\u884c\u7684\u9009\u9879;<\/div>\n
3.\u4f7f\u7528–help\u9009\u9879\u8c03\u7528mysqlshow\u53ef\u67e5\u770b\u5176\u9009\u9879\u7684\u5b8c\u6574\u5217\u8868;<\/div>\n
4.mysqlshow\u6240\u6267\u884c\u7684\u64cd\u4f5c\u53d6\u51b3\u4e8e\u5df2\u63d0\u4f9b\u7684\u975e\u9009\u9879\u53c2\u6570\u7684\u6570\u91cf;<\/div>\n
<\/div>\n
—\u00a0mysqlshow\u793a\u4f8b;<\/div>\n
1.\u5728\u6ca1\u6709\u53c2\u6570\u7684\u60c5\u51b5\u4e0b,mysqlshow\u5c06\u663e\u793a\u7c7b\u4f3c\u4e8eSHOW\u00a0DATABASES\u7684\u7ed3\u679c;<\/div>\n
2.\u5728\u4f7f\u7528\u5355\u4e2a\u53c2\u6570\u7684\u60c5\u51b5\u4e0b,mysqlshow\u5c06\u8be5\u53c2\u6570\u89e3\u91ca\u4e3a\u6570\u636e\u5e93\u540d\u79f0,\u5e76\u9488\u5bf9\u8be5\u6570\u636e\u5e93\u663e\u793a\u7c7b\u4f3c\u4e8eSHOW\u00a0TABLES\u7684\u7ed3\u679c;<\/div>\n
3.\u5728\u6709\u4e24\u4e2a\u53c2\u6570\u7684\u60c5\u51b5\u4e0b,mysqlshow\u5c06\u53c2\u6570\u89e3\u91ca\u4e3a\u6570\u636e\u5e93\u548c\u8868\u540d\u79f0,\u5e76\u9488\u5bf9\u8be5\u8868\u663e\u793a\u7c7b\u4f3c\u4e8eSHOW\u00a0FULL\u00a0COLUMNS\u7684\u7ed3\u679c;<\/div>\n
4.\u5728\u6709\u4e09\u4e2a\u53c2\u6570\u7684\u60c5\u51b5\u4e0b,\u5176\u8f93\u51fa\u4e0e\u4e24\u4e2a\u53c2\u6570\u7684\u60c5\u51b5\u76f8\u540c,\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e:mysqlshow\u5c06\u7b2c\u4e09\u4e2a\u53c2\u6570\u5f53\u505a\u5217\u540d\u79f0,\u4e14\u4ec5\u9488\u5bf9\u8be5\u5217\u663e\u793aSHOW\u00a0FULL\u00a0COLUMNS\u8f93\u51fa;<\/div>\n
5.\u5982\u679c\u547d\u4ee4\u884c\u4e2d\u6700\u540e\u7684\u53c2\u6570\u5305\u542b\u7279\u6b8a\u5b57\u7b26,mysqlshow\u4f1a\u5c06\u8be5\u53c2\u6570\u89e3\u91ca\u4e3a\u6a21\u5f0f,\u4e14\u4ec5\u663e\u793a\u4e0e\u8be5\u6a21\u5f0f\u5339\u914d\u7684\u540d\u79f0;\u7279\u6b8a\u5b57\u7b26\u5305\u62ec:%\u6216*(\u5339\u914d\u4efb\u4e00\u5b57\u7b26\u5e8f\u5217),\u4ee5\u53ca_\u6216?(\u5339\u914d\u4efb\u4e00\u5355\u4e2a\u5b57\u7b26);\u672c\u793a\u4f8b\u4e2d\u7684\u547d\u4ee4\u4ec5\u663e\u793a\u90a3\u4e9b\u540d\u79f0\u59cb\u4e8ew\u7684\u6570\u636e\u5e93;<\/div>\n
TIPS:\u8fd9\u4e9b\u793a\u4f8b\u8981\u6c42\u5728\u6267\u884c\u547d\u4ee4\u65f6\u4f7f\u7528\u7528\u6237\u548c\u53e3\u4ee4\u4f5c\u4e3a\u53c2\u6570;<\/div>\n
<\/div>\n
—\u00a0\u8bfe\u540e\u7ec3\u4e60;<\/div>\n","protected":false},"excerpt":{"rendered":"

—\u00a0\u5143\u6570\u636e\u8bbf\u95ee\u65b9\u6cd5; 1.\u4ec0\u4e48\u662f\u5143\u6570\u636e:\u6570\u636e\u5e93\u662f\u6570\u636e\u7684\u7ed3\u6784\u5316\u96c6\u5408,\u5143\u6570\u636e\u662f\u201c\u6709\u5173\u6570\u636e\u7684\u6570\u636e\u201d; 2 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[27,31],"class_list":["post-1299","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-mysql_ocp"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1299"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1299\/revisions"}],"predecessor-version":[{"id":1300,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1299\/revisions\/1300"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1299"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}