• mysql 查看帮助


    1.按照层次看帮助

    “?contents”命令来显示所有可供查询的的分类

    mysql> ? contents
    You asked for help about help category: "Contents"
    For more information, type 'help <item>', where <item> is one of the following
    categories:
    Account Management
    Administration
    Data Definition
    Data Manipulation
    Data Types
    Functions
    Functions and Modifiers for Use with GROUP BY
    Geographic Features
    Language Structure
    Plugins
    Storage Engines
    Stored Routines
    Table Maintenance
    Transactions
    Triggers

    MySQL 中都支持哪些数据类型,可以执行“? data types”命令:
    mysql> ? data types
    You asked for help about help category: "Data Types"
    For more information, type 'help <item>', where <item> is one of the following
    topics:
    AUTO_INCREMENT
    BIGINT

    BINARY
    BIT
    BLOB
    BLOB DATA TYPE
    BOOLEAN
    。。。。。。

    2.快速查阅帮助

    在实际应用当中,如果需要快速查阅某项语法时,可以使用关键字进行快速查询。例如,想
    知道show 命令都能看些什么东西,可以用如下命令:
    mysql> ? show
    Name: 'SHOW'
    Description:
    SHOW has many forms that provide information about databases, tables,
    columns, or status information about the server. This section describes
    those following:
    SHOW AUTHORS
    SHOW CHARACTER SET [LIKE 'pattern']
    SHOW COLLATION [LIKE 'pattern']
    SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern']
    SHOW CONTRIBUTORS
    SHOW CREATE DATABASE db_name
    SHOW CREATE EVENT event_name
    SHOW CREATE FUNCTION funcname
    。。。。。。
    例如,如果想参看CREATE TABLE 的语法,可以使用以下命令:
    mysql> ? create table
    Name: 'CREATE TABLE'
    Description:
    Syntax:
    CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name

    56
    [table_option ...]
    [partition_options]
    Or:
    CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
    [(create_definition,...)]
    [table_option ...]
    [partition_options]
    select_statement
    、 。。。。。。

    3.常用的网络资源

    http://dev.mysql.com/downloads/是MySQL 的官方网站,可以下载到各个版本的MySQL 以及
    相关客户端开发工具等。
    http://dev.mysql.com/doc/提供了目前最权威的MySQL 数据库及工具的在线手册。
    http://bugs.mysql.com/这里可以查看到MySQL 已经发布的bug 列表,或者向MySQL 提交bug
    报告。
    http://www.mysql.com/news-and-events/newsletter/通常会发布各种关于MySQL 的最新消息。

  • 相关阅读:
    反向迭代
    c++知识点
    LeetCode-Count Bits
    LeetCode-Perfect Rectangle
    LeetCode-Perfect Squares
    LeetCode-Lexicographical Numbers
    LeetCode-Find Median from Data Stream
    LeetCode-Maximal Square
    LeetCode-Number of Digit One
    LeetCode-Combination Sum IV
  • 原文地址:https://www.cnblogs.com/yangxuming/p/6715108.html
Copyright © 2020-2023  润新知