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

This article mainly introduces the methods that can display double quotation marks in Mysql construction table sentences. The content of the article is carefully selected and edited by the author. It has a certain pertinence and is of great significance to everyone's reference. The following is to understand with the author which methods that can display double quotation marks in Mysql construction table sentences.

Using the Mysql database in the work, it is found that the ddl after building the table shows that the table names and fields are all in double quotation marks. This kind of ddl online work order system cannot be passed, so you need to convert the double quotation marks into back quotation marks (`).

By executing the command show VARIABLES like'% sql%', it is found that the value of sql_mode is ANSI_QUOTES.

Looking at the my.cnf configuration file, you can find the following configuration:

# configuration of local mysql clients [client] # default-character-set = utf8# configuration of other remotely connected mysql clients [mysql] default-character-set = configuration of utf8# local mysql services [mysqld] datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0character-set-server = utf8sql_mode='ANSI_QUOTES'default-storage-engine=INNODBserver-id=1log-bin=mysql-binbinlog_ Format=MIXEDexpire_logs_days= 30[mysqld _ safe] log-error=/var/log/mysqld.log

Remove the sql_mode configuration under mysqld and restart the service.

After reading the above about Mysql table sentences which can display double quotation marks, many readers must have some understanding, if you need to get more industry knowledge and information, you can continue to follow our industry information column.

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.