• mysql 常用指令


    mysql> select @@version;
    +-----------+
    | @@version |
    +-----------+
    | 5.5.14 |
    +-----------+
    1 row in set (0.00 sec)

    mysql> select @@basedir;
    +------------------------------------------+
    | @@basedir |
    +------------------------------------------+
    | C:/Program Files/MySQL/MySQL Server 5.5/ |
    +------------------------------------------+
    1 row in set (0.00 sec)

    mysql> SELECT system_user(),user();
    +----------------+----------------+
    | system_user() | user() |
    +----------------+----------------+
    | root@localhost | root@localhost |
    +----------------+----------------+
    1 row in set (0.00 sec)

    mysql> SELECT user, password FROM mysql.user;
    +-----------+-------------------------------------------+
    | user | password |
    +-----------+-------------------------------------------+
    | Worklight | *78A91369E3BAD0CD4B70C348CE2A5BC5E0A70E2D |
    | Worklight | *78A91369E3BAD0CD4B70C348CE2A5BC5E0A70E2D |
    | root | *21E3F9D13177B74511F2D274F17C92488DC6F4FB |
    +-----------+-------------------------------------------+
    3 rows in set (0.09 sec)

    mysql> SELECT table_schema, table_name FROM information_schema.tables;
    +--------------------+----------------------------------------------+
    | table_schema | table_name |
    +--------------------+----------------------------------------------+
    | information_schema | CHARACTER_SETS |
    | information_schema | COLLATIONS |
    | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY |
    | information_schema | COLUMNS |
    | information_schema | COLUMN_PRIVILEGES |
    | information_schema | ENGINES |
    | information_schema | EVENTS |
    | information_schema | FILES |
    | information_schema | GLOBAL_STATUS |
    | information_schema | GLOBAL_VARIABLES |
    | information_schema | KEY_COLUMN_USAGE |

  • 相关阅读:
    leetcode Super Ugly Number
    leetcode Find Median from Data Stream
    leetcode Remove Invalid Parentheses
    leetcode Range Sum Query
    leetcode Range Sum Query
    leetcode Minimum Height Trees
    hdu 3836 Equivalent Sets
    hdu 1269 迷宫城堡
    hud 2586 How far away ?
    poj 1330 Nearest Common Ancestors
  • 原文地址:https://www.cnblogs.com/vigarbuaa/p/3208882.html
Copyright © 2020-2023  润新知