{"id":144,"date":"2016-10-26T15:30:51","date_gmt":"2016-10-26T06:30:51","guid":{"rendered":"http:\/\/jook.pe.kr\/?p=144"},"modified":"2016-10-26T15:30:51","modified_gmt":"2016-10-26T06:30:51","slug":"mysql-help-tables-%ec%82%ac%ec%9a%a9%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/jook.pe.kr\/?p=144","title":{"rendered":"mysql help tables \uc0ac\uc6a9\ud558\uae30"},"content":{"rendered":"

1. http:\/\/dev.mysql.com\/<\/a> \ud398\uc774\uc9c0\uc5d0 \uc811\uc18d\ud574\uc11c Developer Zone -> Documentation \uba54\ub274\ub85c \ub4e4\uc5b4\uac00\uba74, MySQL Help Tables \ub77c\ub294 \uba54\ub274\uc5d0\uc11c \uc790\uc2e0\uc774 \uc0ac\uc6a9\ud558\ub294 \ubc84\uc804\uc758 help tables\uc555\ucd95 \ud30c\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\ub294\ub2e4.<\/p>\n

2. \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc740 \ud30c\uc77c\uc758 \uc555\ucd95\uc744 \ud480\uba74 help tables\uc758 dump \ud30c\uc77c\uc778 fill_help_tables-\ubc84\uc804.sql \ud30c\uc77c\uc774 \uc0dd\uae30\uac8c \ub41c\ub2e4. \uc774 \ud30c\uc77c\uc744 mysql \uc11c\ubc84\uc5d0 \uc5c5\ub85c\ub4dc \ud558\uace0, \uc544\ub798\uc640 \uac19\uc774 mysql db\uc5d0 sql \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 \uc5c5\ub370\uc774\ud2b8 \ud55c\ub2e4.<\/p>\n

[root@localhost src]# \/usr\/local\/mysql\/bin\/mysql mysql < fill_help_tables-5.1.sql<\/strong><\/p>\n

3. \ub370\uc774\ud130 \uc5c5\ub370\uc774\ud2b8\ub97c \uc644\ub8cc\ud55c \ud6c4 mysql \uc11c\ubc84\uc5d0 \uc811\uc18d\ud558\uba74 mysql db \ub0b4\uc5d0 help_category, help_keyword, help_relation, help_topic \ub124\uac1c\uc758 table\uc774 \uc0dd\uc131\ub41c\ub2e4.<\/p>\n

[root@localhost \/root]# \/usr\/local\/mysql\/bin\/mysql -u root -p mysql<\/strong>
\nEnter password:
\nWelcome to the MySQL monitor.\u00a0 Commands end with ; or g.
\nYour MySQL connection id is 4
\nServer version: 5.1.24-rc-log Source distribution<\/p>\n

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.<\/p>\n

mysql> show tables;<\/strong>
\n+—————————+
\n| Tables_in_mysql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+—————————+
\n| columns_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| event\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| func\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| general_log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| help_category<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| help_keyword<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| help_relation<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| help_topic<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| ndb_binlog_index\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| plugin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| proc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| procs_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| servers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| slow_log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| tables_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| time_zone\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| time_zone_leap_second\u00a0\u00a0\u00a0\u00a0 |
\n| time_zone_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| time_zone_transition\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| time_zone_transition_type |
\n| user\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+—————————+
\n23 rows in set (0.00 sec)<\/p>\n

mysql><\/p>\n

4. \uc774\uc81c \ubcf8\uaca9\uc801\uc73c\ub85c help table\uc744 \uc774\uc6a9\ud574\uc11c mysql \uacf5\ubd80\ub97c \uc2dc\uc791 \ud560 \uc218 \uc788\ub2e4.. ^^
\nhelp \ub2e4\uc74c\uc5d0 \ucffc\ub9ac\ubb38\uc758 \uc77c\ubd80\ubd84\uc744 \uc785\ub825\ud558\uba74 \ud574\ub2f9 \ucffc\ub9ac\uc758 \uc0ac\uc6a9\ubc95 \ub4f1\uc5d0 \ub300\ud55c \uc124\uba85\uc774 \ub098\uc628\ub2e4. (\uc608\uc81c\uae4c\uc9c0<\/strong>.. ^^)<\/p>\n

ex) help select -> select\uc758 \uc0ac\uc6a9\ubc95\uc774 \ucd9c\ub825\ub41c\ub2e4.
\nhelp like -> \ucffc\ub9ac\ubb38\uc911 like \uad6c\ubb38\uc758 \uc0ac\uc6a9\ubc95\uc774 \ucd9c\ub825\ub41c\ub2e4.<\/p>\n

mysql> help select<\/strong>
\nName: ‘SELECT’
\nDescription:
\nSyntax:
\nSELECT
\n[ALL | DISTINCT | DISTINCTROW ]
\n[HIGH_PRIORITY]
\n[STRAIGHT_JOIN]
\n[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
\n[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
\nselect_expr, …
\n[FROM table_references
\n[WHERE where_condition]
\n[GROUP BY {col_name | expr | position}
\n[ASC | DESC], … [WITH ROLLUP]]
\n[HAVING where_condition]
\n[ORDER BY {col_name | expr | position}
\n[ASC | DESC], …]
\n[LIMIT {[offset,] row_count | row_count OFFSET offset}]
\n[PROCEDURE procedure_name(argument_list)]
\n[INTO OUTFILE ‘file_name’ export_options
\n| INTO DUMPFILE ‘file_name’
\n| INTO var_name [, var_name]]
\n[FOR UPDATE | LOCK IN SHARE MODE]]<\/p>\n

SELECT is used to retrieve rows selected from one or more tables, and
\ncan include UNION statements and subqueries. See [HELP UNION], and
\nhttp:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/subqueries.html<\/a>.<\/p>\n

The most commonly used clauses of SELECT statements are these:<\/p>\n

o Each select_expr indicates a column that you want to retrieve. There
\nmust be at least one select_expr.<\/p>\n

o table_references indicates the table or tables from which to retrieve
\nrows. Its syntax is described in [HELP JOIN].<\/p>\n

o The WHERE clause, if given, indicates the condition or conditions
\nthat rows must satisfy to be selected. where_condition is an
\nexpression that evaluates to true for each row to be selected. The
\nstatement selects all rows if there is no WHERE clause.<\/p>\n

In the WHERE clause, you can use any of the functions and operators
\nthat MySQL supports, except for aggregate (summary) functions. See
\n[HELP =].<\/p>\n

SELECT can also be used to retrieve rows computed without reference to
\nany table.<\/p>\n

URL: http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/select.html<\/a>
\nmysql> help count<\/strong>
\nName: ‘COUNT’
\nDescription:
\nSyntax:
\nCOUNT(expr)<\/p>\n

Returns a count of the number of non-NULL values of expr in the rows
\nretrieved by a SELECT statement. The result is a BIGINT value.<\/p>\n

COUNT() returns 0 if there were no matching rows.<\/p>\n

URL: http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/group-by-functions.html<\/a><\/p>\n

Examples:
\nmysql> SELECT student.student_name,COUNT(*)
\n->\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FROM student,course
\n->\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WHERE student.student_id=course.student_id
\n->\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GROUP BY student_name;<\/p>\n

mysql> help like<\/strong>
\nName: ‘LIKE’
\nDescription:
\nSyntax:
\nexpr LIKE pat [ESCAPE ‘escape_char’]<\/p>\n

Pattern matching using SQL simple regular expression comparison.
\nReturns 1 (TRUE) or 0 (FALSE). If either expr or pat is NULL, the
\nresult is NULL.<\/p>\n

The pattern need not be a literal string. For example, it can be
\nspecified as a string expression or table column.<\/p>\n

URL: http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/string-comparison-functions.html<\/a><\/p>\n

Examples:
\nmysql> SELECT ‘David!’ LIKE ‘David_’;
\n-> 1
\nmysql> SELECT ‘David!’ LIKE ‘%D%v%’;
\n-> 1<\/p>\n

mysql><\/p>\n","protected":false},"excerpt":{"rendered":"

1. http:\/\/dev.mysql.com\/ \ud398\uc774\uc9c0\uc5d0 \uc811\uc18d\ud574\uc11c Developer Zone -> Documentation \uba54\ub274\ub85c \ub4e4\uc5b4\uac00\uba74, MySQL Help Tables \ub77c\ub294 \uba54\ub274\uc5d0\uc11c \uc790\uc2e0\uc774 \uc0ac\uc6a9\ud558\ub294 \ubc84\uc804\uc758 help tables\uc555\ucd95<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"_links":{"self":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/144"}],"collection":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=144"}],"version-history":[{"count":0,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/144\/revisions"}],"wp:attachment":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}