equal
deleted
inserted
replaced
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 |