MySQL Forums
Forum List  »  Chinese

Re: 【求助】MySQL8.0查询语句错误
Posted by: Peter Brawley
Date: January 16, 2022 09:08AM

I neither read nor write Chinese so I'll respond in English and append a Google translation.

DDL: utfmb3 is deprecated; comment needs to be followed by a string literal; create table statements need terminating semicolons.

After those corrections, the query runs without error or warning in 8.0.27.

Your error has been reported with Connector/J, for example https://stackoverflow.com/questions/24835800/jdbc-mysql-communications-link-failure-to-remote-database.

---------------

我不会读也不会写中文,所以我会用英文回复并附上谷歌翻译。

DDL:不推荐使用 utfmb3; 注释后面需要跟一个字符串文字; create table 语句需要以分号结尾。

在这些更正之后,查询在 8.0.27 中运行而不会出现错误或警告。

例如,Connector/J 已报告您的错误 https://stackoverflow.com/questions/24835800/jdbc-mysql-communications-link-failure-to-remote-database

Options: ReplyQuote


Subject
Views
Written By
Posted
409
January 16, 2022 07:51AM
Re: 【求助】MySQL8.0查询语句错误
249
January 16, 2022 09:08AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.