Hi there

when in mysql if you type a wrong character, it seems to get stuck in the "->" cursor, how do you cancel it, because currently, I am having to quit mysql delete the database and start again from scratch. Is there a way to undo typo errors, or is this the ultimate in unforgiving software?

Hello

It just means it is waiting for a ; to complete the SQL. So you can either just type ; or press Control+C to abort it.

Edit:

It can also mean you are inside a string. For example you enter

Then you'll have to finish it with "; to complete the SQL. But anyway, you can press Control+C.

Maybe try: \c to cancel current command

Unfortunately, ctrl-C just quits mysql, and I have tried the ";" thing, and that does nothing. It's not very user friendly is it?

Hello "iFunction"

Maybe it would help if you specify what you want to do. I find it very strange that you have to delete the database and start all over again.

If you are new to MySql, you might consider using phpMyAdmin. It will provide a graphical interface to manage a database, and gives you the sql code for actions you perform. You can download a portable version (xampp) fromhttps://www.apachefriends.org/index.html. This will give you the opportunity to test things first before you apply them in your live database.

Please note that with xampp comes MariaDB. This works (as far as I know) exactly the same as MySql.

Wrong character?
usually an unpaired single or double quotes in the sql command does it for me.
If that seems to be the case, issue a ' or a " on the
subsequent prompt from mysql.

The problem I have here is that I am learning, and litterally just putting in a mistyped spelling of something suddenly becomes a case of delete whole thing and start again, in writing this post I have made at least 15 typos, but used the delete key to get rid of them, when using emacs, I can edit as I like, even in the terminal or a python shell, I can go back and redo a mistake, but with MySQL, tap a ' and enter by mistake, and that's it, can't get out of the string cursor, without closing down MySQL, is there not just a simple combination that can cancel the last entry made?

Yes, see my previous posts

1 members found this post helpful.

keefaz, perfect, thank you very much, you also showed me how to search for my own help also (which I should have been able to work out, but with an iq similar to my shoe size I wasn't able to), thanks.