• 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 |

  • 相关阅读:
    01
    py5.30
    py 5.28
    py5.25
    py 5.24
    py 5.22
    py5.21
    py 5.18
    py 5.17
    py 5.16
  • 原文地址:https://www.cnblogs.com/vigarbuaa/p/3208882.html
Copyright © 2020-2023  润新知