Indexing method used (BTREE、FULLTEXT、HASH、RTREE)
If this column can contain NULL values, then YES is used otherwise, '' is used. If the column is only partially indexed, the number of indexed characters. The higher the cardinality, the more likely it is that MySQL will use this index when performing a join. It refers to the types of values that a column can take. How the column is sorted in MySQL, this is either "A" (ascending) or NULL (unsorted) The column sequence number in the index, starting from 1. Index name if this index is primary key, the name of key is always PRIMARY | members | 1 | idx_members_id_01 | 1 | id | A | 0 | | | | BTREE | | for search member quickly |Ġ if the index cannot contain duplicates, 1 if it can. | members | 0 | email | 1 | email | A | 0 | | | | BTREE | | | | members | 0 | name | 1 | name | A | 0 | | | | BTREE | | | Ottimo e dolce esfoliante è ben accettato per la quasi totale assenza di effetti collaterali: a differenza dei prodotti a base di acido glicolico, i cosmetici M圜li a base di acido mandelico esfoliano senza essere fotosensibilizzanti e senza provocare particolari irritazioni cutanee. | members | 0 | PRIMARY | 1 | id | A | 0 | | | | BTREE | | | | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
MYCLI OPINIONI INSTALL
You can install mycli by homebrew or pip. It's colored and has a nice list of candidates! Here is a screenshot of the connection with the mycli command. It's hard to see and the command completion doesn't work. The screenshot above shows the connection screen using the normal mysql command. Table names and other completion suggestions will be displayed.The best part is that the completion makes it easier to type commands on the terminal and reduce typos. So, what are you happy about using mycli? Mycli is a CLI interface for common DB management systems such as MySQL (and MariaDB). ※ If you want to read the Japanese version of this article, If you want to operate a full-scale DB, it is easier to use a GUI such as Sequel Pro, but if you just want to touch the DB, it is easier to use the mycli on terminal.
Want to play around with the DB using the CLI (the black screen of the terminal) If you have heard of SELECT and INSERT, you should be fine.
0 kommentar(er)
