如何正确格式化sqlite shell输出?
发布时间:2020-12-12 19:09:29 所属栏目:百科 来源:网络整理
导读:如果我去 mysql shell并输入SELECT * FROM users我得到 – +--------+----------------+---------------------------------+----------+-----------+--------------------+--------------------+| USERID | NAME | EMAILID | PASSWORD | USER_TYPE | CONTACT
如果我去
mysql shell并输入SELECT * FROM users我得到 –
+--------+----------------+---------------------------------+----------+-----------+--------------------+--------------------+ | USERID | NAME | EMAILID | PASSWORD | USER_TYPE | CONTACT_ID_FKUSERS | COMPANY_ID_FKUSERS | +--------+----------------+---------------------------------+----------+-----------+--------------------+--------------------+ | 137 | X | b@cc.com | # | ADMIN | 166 | 110 | | 138 | Kshitiz | ksharma@aaa.com | asdf | ADMIN | 167 | 111 | +--------+----------------+---------------------------------+----------+-----------+--------------------+--------------------+ Oracle sqlplus显示 – USERID NAME EMAILID PASSWORD USER_TYPE CONTACT_ID_FKUSERS COMPANY_ID_FKUSERS ---------- ----- ---------- ---------- ---------- ------------------ ------------------ 137 X b@cc.com # ADMIN 166 110 137 X b@cc.com # ADMIN 166 110 Sqlite shell显示 – 137|X|b@cc.com|#|ADMIN|166|110 138|Kshitiz|ksharma@aaa.com|asdf|ADMIN|167|111 >有没有办法美化sqlite shell的输出? sqlite> select * from foo; 234|kshitiz|dba.se sqlite> .mode column sqlite> select * from foo; 234 kshitiz dba.se sqlite> .headers on sqlite> select * from foo; bar baz baf ---------- ---------- ---------- 234 kshitiz dba.se (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |