mysql.rst
changeset 1811 072cc8a704ce
parent 1810 752c192306ff
child 1836 4864231db031
equal deleted inserted replaced
1810:752c192306ff 1811:072cc8a704ce
    31 Python command line client with completion. Usage::
    31 Python command line client with completion. Usage::
    32 
    32 
    33   $ mycli -u $USER
    33   $ mycli -u $USER
    34   Password:         <== Type password.
    34   Password:         <== Type password.
    35 
    35 
       
    36 List databases, tables, columns.
       
    37 ================================
       
    38 ::
       
    39 
       
    40   $ mysql -u $USER -p
       
    41   Enter password:   <== Type password.
       
    42 
       
    43   SHOW DATABASES;
       
    44 
       
    45   USE mysql;
       
    46   MariaDB [mysql]> SHOW TABLES;
       
    47 
       
    48   MariaDB [mysql]> SHOW COLUMNS FROM user;
       
    49 
       
    50   MariaDB [mysql]> DESCRIBE user;
       
    51 
       
    52   MariaDB [mysql]> SHOW STATUS;
       
    53 
       
    54   MariaDB [mysql]> SHOW CREATE DATABASE mysql;
       
    55   MariaDB [mysql]> SHOW CREATE TABLE user;
       
    56 
       
    57   MariaDB [mysql]> SHOW GRANTS;
       
    58 
       
    59   MariaDB [mysql]> SHOW WARNINGS;
       
    60   MariaDB [mysql]> SHOW ERRORS;
       
    61