「select * from テーブル名」だとテーブルの要素が多かったりする場合、表示するコンソールやソフトのウィンドウが小さいと見にくくなってしまいます。
そういう時は「selct * from テーブル名 ¥G」というコマンドしようすると縦に見やすく表示することができます。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
mysql> select * from users; +-----+------+----------------+------+--------+------+-------------------+---------------------+ | id | name | email | pass | score | sex | memo | created | +-----+------+----------------+------+--------+------+-------------------+---------------------+ | 110 | mike | mike@email.com | pass | 102839 | male | mike is very tall | 2017-03-22 10:22:33 | | 112 | jake | jake@email.com | pass | 102839 | male | mike is very tall | 2017-03-22 10:22:33 | +-----+------+----------------+------+--------+------+-------------------+---------------------+ mysql> select * from users \G *************************** 1. row *************************** id: 110 name: mike email: mike@email.com pass: pass score: 102839 sex: male memo: mike is very tall created: 2017-03-22 10:22:33 *************************** 2. row *************************** id: 112 name: jake email: jake@email.com pass: pass score: 102839 sex: male memo: mike is very tall created: 2017-03-22 10:22:33 2 rows in set (0.00 sec) |
