How to clear mysql screen console in windows

Question

The title is my question  I googled and try something like  mysql gt     clear mysql gt     cls mysql gt  system cls mysql gt  system clear   blah blah       but none of them works  anyone show me how to clear screen  just like cls command in window

User · Accepted Answer

This is not possible on Windows   There is an open bug for this issue  Bug  58680  Windows Clear Screen Command

User · Answer

you can type the following step    mysql  exit   C  xampp mysql bin  cls  C  xampp mysql bin  mysql -u root -h localhost  it s work

User · Answer

EDIT  I don t think Any of the commands will work  In linux Ctrl-L will do the job  in windows there is no equivalent  You can only Exit MySql  Type CLS and then re-enter MySql

User · Answer

mysql gt   root xion    mysql -uroot -ppassword  Welcome to the MySQL monitor   Commands end with   or  g  Your MySQL connection id is 33291 Server version  5 0 51a-3ubuntu5 4  Ubuntu   Type  help   or   h  for help  Type   c  to clear the buffer   mysql gt     clear

User · Answer

just type  system cls took me a couple hours to get it jejej

User · Answer

mysql console can cleared out on windows by using shortcut key   CTRL   L

User · Answer

Unfortunately in Windows  It is not possible  The only way out is to exit and type cls and then again open mySQL

User · Answer

For Window 10 Use the command system cls and this will clear the MYSQL Command Line window in Windows

User · Answer

This is what I did to get around this bug  The windows console  cmd  is just not worth using for anything other than some simple commands  So the following is what I did   Installed Cygwin  Go here  It is pretty straight forward to install  You can watch this video  It explains very easily how to install cygwin  Make sure when you select the packages that you want to install includes Mintt  it is basically a better shell or cmd  and mysql client package    Once you are done installing it  you should add the bin folder from cygwin in your PATH Environmental Variables The above video explains that as well   Now You will have an icon on the desktop for cygwin  Open it up and login to mysql using the normal commands  You will need to put the ip of the mysql server in the command to make it work  I use the following logging in MySQL which was installed through wamp  mysql -u root -p -h 127 0 0 1    You can add more arguments in there if you want  Once you get in mysql just press ctrl   L and you will clear the screen

User · Answer

For windows command prompt  Use   system cls

User · Answer

You are typing the command wrong  It is  quot   quot  before  quot   quot  and not after  The command ctrl L will not work for windows  To clear mysql console screen  type following command  mysql gt     cls  This will do the job for windows   quot    quot  is used to execute system shell command   quot cls quot  is command to clear windows command prompt screen  Similarly if you are on linux  you will type  quot ctrl L quot  or following  mysql gt     clear  source  https   dev mysql com doc refman 8 0 en mysql-commands html

User · Answer

I handle it as follows    Right click on cmd open property s goto layout Set screen buffer height to 9999 and ok Now whenever you want to type a new query  just scroll with the mouse and you will get a blank screen

User · Answer

I had the same issue  and CTRL L worked for me on Windows 10

User · Answer

On linux   you can use ctrl   L or type command system clear

User · Answer

Fixed in 8 0 19  Previously  the system     command for the mysql command-line client worked only for Unix and Unix-like systems  It now works on Windows as well  For example  system cls or   cls may be used to clear the screen

User · Answer

Just scroll down with your mouse  In Linux Ctrl L will do but if your scroll up you will see the old commands  So I would suggest scrolling down in windows using mouse

User · Answer

Well  if you installed MySql Server e g  Version 5 5  which has it s folder located in      C  Program Files MySQL MySQL Server 5 5 bin   The best way would be to include it in your paths    First run sysdm cpl applet from run i e  WinKey   R Navigate to Advanced -  Environment Variables Select PATH and Click Edit  Scroll to the end of the text  and add   C  Program Files MySQL MySQL Server 5 5 bin  without quotes  Notice the semicolon starting the text  this should only be added if it s not already there     Now you can just call      start  b  wait mysql -u root -p   via command prompt   To clear the screen now  you can just exit in mysql  amp  call cls  Kinda trickish hack but does the job   If you re using WAMP or other tool  it s even easier   Open command prompt and type      C  wamp mysql bin mysql -u root -p   Enter as normal  then whenever you want to clear screen  do      exit or quit   And then clear using DOS      cls   You can easily re-enter by pressing up twice to get your mysql call command

User · Answer

although there is bug for clearing the screen in MySQL  I have found one tactic trick whatever you want to say     you can easily clear the screen using this     just press   ctrl   down arrow   until you reach to top    happy codding

User · Answer

SQL  clear scr   This command clears the screen in MYSQL

User · Answer

It worked for me using this   clear screen

User · Answer

The bug on Windows which most people are talking is probably fixed  Ctrl   L is works for clearing the screen on Windows 10  Mysql 8

User · Answer

Click with contextMenu button on Mysql prompt and choose  Scroll   because I didn t find any way to clean too   P

User · Answer

Open Properties by clicking the upper left console window icon  go to Layout tab  take note of the value set in Screen Buffer Size- gt Height  and change it to 1  Click OK  You ll see a 1 row console  Open Properties again and change that value back to what it had before  Resize the console down and you ll have a clean console

User · Answer

I used the command line client prompt and to clear the screen I typed - system cls

[mysql] How to clear mysql screen console in windows?

Examples related to mysql

Examples related to windows

Examples related to command-line

Examples related to sqlcommand