Shulou(Shulou.com)06/01 Report--

This article mainly introduces what the mysql escape character refers to, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The mysql escape character is [`], which is used to avoid the conflict between the column name or table name and the keyword of mysql itself. It is usually used to indicate that the content is database name, table name, field name, not keyword.

`is the escape character of MySQL, which is used to avoid key conflicts between column names or table names and mysql itself.

All databases have similar settings, but mysql only uses `. It is usually used to indicate that the content is the database name, table name, field name, not keyword. For example:

Select * from table_name where `key` = 'key_name'

Where key is the keyword of mysql. If the column name is key, you need to escape it with ``.

Extension:\ is required to escape `in the string, otherwise an error will be reported and a syntax error will be reported.

Mysql-uUser-pPasswd-e "select * from table_name where\ `key\ `= 'name';" Thank you for reading this article carefully. I hope the editor will share what the mysql escape characters refer to. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.