What should I do if I want to cancel an incorrect MySQL command?

What should I do if I want to cancel an incorrect MySQL command?

I typed a wrong mysql command and want to cancel it. What should I do? If you use ctrl + c, you will exit directly. What should I do? Let’s take a look:

mysql> show tables; \c
+-------------------+
| Tables_in_db_test |
+-------------------+
| tb_test |
| tb_test_ex |
+-------------------+
2 rows in set (0.00 sec)

mysql> show tables \c
mysql> show tabxx \c
mysql> 

If you don't know this little trick, it's really annoying.

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links

You may also be interested in:
  • How to solve the problem of case insensitivity in MySQL queries
  • MySQL optimization strategy (recommended)
  • Detailed explanation of how MySQL solves phantom reads
  • Detailed explanation of the 10061 unknown error when using Navicat to connect to a remote Linux MySQL database
  • Detailed explanation of MySQL database addition, deletion and modification operations
  • How to add index to mysql using shell script
  • MySQL character set garbled characters and solutions
  • MySQL starts slow SQL and analyzes the causes
  • Will MySQL execute the update statement again if it has the same data as the original one?
  • Reasons and solutions for slow MySQL query stuck in sending data

<<:  The whole process of installing and configuring Harbor1.7 on CentOS7.5

>>:  Vue3 implements CSS infinite seamless scrolling effect

Recommend

HTML+CSS+JavaScript to achieve list loop scrolling example code

Description: Set a timer to replace the content of...

How to automatically backup mysql remotely under Linux

Preface: Basically, whether it is for our own use...

Vue realizes the palace grid rotation lottery

Vue implements the palace grid rotation lottery (...

MySQL database operations (create, select, delete)

MySQL Create Database After logging into the MySQ...

Mobile front-end adaptation solution (summary)

I searched online and found that many interviews ...

Tutorial on how to create a comment box with emoticons using HTML and CSS

HTML comment box with emoticons. The emoticons ar...

Basic knowledge of HTML: a preliminary understanding of web pages

HTML is the abbreviation of Hypertext Markup Langu...

The whole process record of Vue export Excel function

Table of contents 1. Front-end leading process: 2...

Element avatar upload practice

This article uses the element official website an...

Analysis and treatment of scroll bars in both HTML and embedded Flash

We often encounter this situation when doing devel...

MySQL master-slave data is inconsistent, prompt: Slave_SQL_Running: No solution

This article uses an example to describe the solu...

Detailed process analysis of docker deployment of snail cinema system

Environmental Statement Host OS: Cetnos7.9 Minimu...

Example of using supervisor to manage nginx+tomcat containers

need: Use docker to start nginx + tomcat dual pro...