Databases
StackOverflow2013
Postsdbo
POCommand history in mysql client only showing last line of multiline query
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCommand history in mysql client only showing last line of multiline query
    primarykey
    data
    text
    <p>I'm using Mysql's command-line client in Screen/Tmux, from Bash in OSX's Terminal.app. When using arrow-up to re-display a previously run query that spanned more than on line, AND when the cursor is on the very last line of the Terminal, the command in mysql's command history gets 'truncated', or cut off. This never happens when I use the same tools on my Ubuntu workstation</p> <p>Here's a visual representation of what happens:</p> <p>Typing some query; nothing wrong here.</p> <pre><code>+-------------------------------------------+ |mysql&gt; | |mysql&gt; | |mysql&gt; | |mysql&gt;select * from tables where legs = 4 a| |nd colour = 'green'; | +-------------------------------------------+ </code></pre> <p>Run it, results are displayed:</p> <pre><code>+-------------------------------------------+ || 2 | ....... | ..... | | |+---+---------+-------+ | | x rows in set (0.00 sec) | | | |mysql&gt; | +-------------------------------------------+ </code></pre> <p>Hitting [arrow-up] to re-display last query leaves me with:</p> <pre><code>+-------------------------------------------+ || 2 | ....... | ..... | | |+---+---------+-------+ | | x rows in set (0.00 sec) | | | |nd colour = 'green'; | +-------------------------------------------+ </code></pre> <p>Hit [arrow-up] again, I get:</p> <pre><code>+-------------------------------------------+ || 2 | ....... | ..... | | |+---+---------+-------+ | | x rows in set (0.00 sec) | |mysql&gt;select * from tables where legs = 4 a| |nd colour = 'green'; | +-------------------------------------------+ </code></pre> <p>Could the be solved by changing a setting? Or is it a bug in Mysql's client?</p> <p>Software versions:</p> <pre><code>OSX 10.7.3 Terminal Version 2.2.2 (303) GNU bash, version 3.2.48(1)-release (x86_64-apple-darwin11) mysql Ver 14.14 Distrib 5.5.19, for osx10.7 (i386) using readline 5.1 Screen version 4.00.03 (FAU) 23-Oct-06 tmux 1.6 </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USklokop
    1. USklokop
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCommand history in mysql client only showing last line of multiline query
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCommand history in mysql client only showing last line of multiline query
      1. USshellter
      1. VTFavorite
    3. VO
      singulars
      1. POCommand history in mysql client only showing last line of multiline query
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 for excellent problem illustration. but sorry, don't know how to help on this one. Good luck.
      singulars
      1. POCommand history in mysql client only showing last line of multiline query
      1. USshellter
    2. COIf it really affects both, `tmux` and `screen`, it's probably caused by some bug or version incompatibility in `libreadline` or the `mysql` client itself. Have you tried updating yet? If so, you could now check the value of the env. variable TERM in your `tmux` session against the list of supported terminal types - and adjust it if necessary..
      singulars
      1. POCommand history in mysql client only showing last line of multiline query
      1. USmjhennig
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload