CODEWITHSUNDEEP
mysqlsql
omrehman
omrehman

Reputation: 107

Show whole text in query result in mysql

I am using mysql (mysql Ver 14.14 Distrib 5.5.34, for debian-linux-gnu (x86_64) using readline 6.2). and i am create a column named external_password with description external_password | varchar(200) | null =YES | | default =NULL and inserted data.

When I try preform a select operation through command line i got the following result,

mysql> select external_password from login_user WHERE user_name = 'abc@123';
+---------------------------------------------------------+
| external_password                                       |
+---------------------------------------------------------+
| $S$DEjrvXeeDgACuXAN0XkyM6FEPTFcHLcNqV..3SBHxQBpwR9wN7Fd |
+---------------------------------------------------------+
1 row in set (0.00 sec)

But this not showing the full character. between these substring {LcNqV..3SBHxQB} there are lot of other characters are hidden. how can i get the full text by command line?? please help me

NB: i am using using the ubuntu. Also in a situation i can't use phpmyadmin or any other mysql user interfaces.

Upvotes: 1

Views: 4106

Answers (1)

gianebao
gianebao

Reputation: 18938

use ego. this might display more text compared to the table view.

mysql> select external_password from login_user WHERE user_name = 'abc@123'\G

here are other options you can use http://dev.mysql.com/doc/refman/5.1/en/mysql-commands.html

Upvotes: 2

Related Questions