equal
deleted
inserted
replaced
35 Python command line client with completion. Usage:: |
35 Python command line client with completion. Usage:: |
36 |
36 |
37 $ mycli -u $USER |
37 $ mycli -u $USER |
38 Password: <== Type password. |
38 Password: <== Type password. |
39 |
39 |
40 List databases, tables, columns. |
40 List databases, tables, columns, indexes. |
41 ================================ |
41 ========================================= |
42 :: |
42 :: |
43 |
43 |
44 $ mysql -u $USER -p |
44 $ mysql -u $USER -p |
45 Enter password: <== Type password. |
45 Enter password: <== Type password. |
46 |
46 |
57 |
57 |
58 MariaDB [mysql]> SHOW CREATE DATABASE mysql; |
58 MariaDB [mysql]> SHOW CREATE DATABASE mysql; |
59 MariaDB [mysql]> SHOW CREATE TABLE user; |
59 MariaDB [mysql]> SHOW CREATE TABLE user; |
60 |
60 |
61 MariaDB [mysql]> SHOW GRANTS; |
61 MariaDB [mysql]> SHOW GRANTS; |
|
62 |
|
63 List indexes:: |
|
64 |
|
65 SELECT * FROM INFORMATION_SCHEMA.STATISTICS; |
|
66 |
|
67 SHOW INDEX FROM tbl; |
|
68 |
|
69 SHOW INDEX FROM tbl FROM db; |
|
70 |
|
71 SHOW CREATE TABLE tbl; |
62 |
72 |
63 Table/index sizes. |
73 Table/index sizes. |
64 ================== |
74 ================== |
65 :: |
75 :: |
66 |
76 |