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

Nginx Location directive URI matching rules detailed summary

1. Introduction The location instruction is the c...

Detailed tutorial on running multiple Springboot with Docker

Docker runs multiple Springboot First: Port mappi...

How to implement element floating and clear floating with CSS

Basic Introduction to Floating In the standard do...

Implementation of MYSQL (telephone number, ID card) data desensitization

1. Data desensitization explanation In daily deve...

How to package the uniapp project as a desktop application

Installing Electron cnpm install electron -g Inst...

Analysis and solution of flex layout collapse caused by Chrome 73

Phenomenon There are several nested flex structur...

MySQL 5.7.18 release installation guide (including bin file version)

The installation process is basically the same as...

MySQL master-slave principle and configuration details

MySQL master-slave configuration and principle, f...

Two methods to implement MySQL group counting and range aggregation

The first one: normal operation SELECT SUM(ddd) A...

How to use Web front-end vector icons

Preface When writing front-end pages, we often us...

Detailed explanation of Truncate usage in MYSQL

This article guide: There are two ways to delete ...

Overview of the definition of HTC components after IE5.0

Before the release of Microsoft IE 5.0, the bigges...

Summary of Vue's monitoring of keyboard events

Key Modifiers When listening for keyboard events,...