RE: All command has no content, only yield "x rows in set"

2013-09-18 Thread Rick James
Check your ~/.my.cnf and other places where configuration might be causing the 
problem (such as "pager").

> -Original Message-
> From: Radoulov, Dimitre [mailto:cichomit...@gmail.com]
> Sent: Wednesday, September 18, 2013 7:32 AM
> To: zxycscj; mysql
> Subject: Re: All command has no content, only yield "x rows in set"
> 
> On 18/09/2013 16:17, zxycscj wrote:
> > execute mysql command has no content. help [...]
> >
> > mysql> use ijdb;
> > Database changed
> > mysql> show tables;
> > 7 rows in set (0.00 sec)
> >
> [...]
> 
> I suppose that the mysql pager is set to a non-default value.
> On the mysql prompt try:
> 
> pager
> repeat your command here ...
> 
> Regards
> Dimitre
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: All command has no content, only yield "x rows in set"

2013-09-18 Thread Radoulov, Dimitre

On 18/09/2013 16:17, zxycscj wrote:

execute mysql command has no content. help
[...]

mysql> use ijdb;
Database changed
mysql> show tables;
7 rows in set (0.00 sec)


[...]

I suppose that the mysql pager is set to a non-default value.
On the mysql prompt try:

pager
repeat your command here ...

Regards
Dimitre

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql