Keyboard shortcuts for Mysql command-line window

[SH_GHAM]

Hi
I am creating a basic table using Mysql terminal in command line window. I made a syntax erro
and pressed enter to go next line. Now I want to go back to the previous line to delete or edit that line.
I can not find a keyboard short cut to edit or delete that line. I select the line and do Ctrl + delete or delete but can not fix it.
Where can i find keyboard shortcut for Mysqul command-line windows?
Any help is appreciated.

[Altrea]

you can't. The MySQL CLI is not a text editor where you can go back a line to change that. You need to execute the whole command, will get a syntax error and can retype the command.

[SH_GHAM]

So what is the command to find the syntax error and retype it?
Thx.

[Nobbie]

There is no command. The Mysql Sql Interpreter does not know any edit facilities.

[SH_GHAM]

Are you saying for example while I am creating a table and make a mistake , the only way is to delete the
table and start over again?

[Altrea]

If the table could have created successful you can also edit the table by an ALTER Table command, or you drop the table and create it from scratch. It depends what you need to change and which method reaches the goal mor easy than the other.

[SH_GHAM]

Thank you

[Nobbie]

Are you saying for example while I am creating a table and make a mistake , the only way is to delete the
table and start over again?

It depends, if you accidently delete lines which you did not want to delete, you cannot undo that. That is not a toy and the command line interpreter is only a tool for executing SQL commands. It does not keep a copy of all databases "just in case". Yes, you have to be carefull with SQL Databases. Keep your own backups before changing critical data.

Creating tables on the fly with the keyboard is a bad idea anyway, usually one should create text files with the SQL statements and use these files as input for the interpreter.