mysql - Handshake inactivity timeout - mysql using sqltools
问题描述
I am using SQL tools however I keep getting this error. I have changed the connection to 5000 but I keep getting this error. I don't know if this is a syntax error, sqltools error, or a MySQL error.
here is my code
--@block
CREATE TABLE Main(
id INT PRIMARY Key,
title VARCHAR(255) NOT NULL UNIQUE,
body TEXT NOT NULL,
mainimageurl VARCHAR(255),
);
the error
Handshake inactivity timeout
it's running on port 3305, using xprotocol. and have opened the udp port
I appreciate any help you can provide!
解决方案
There's an extra comma after mainimageurl VARCHAR(255),
. It should be:
CREATE TABLE Main(
id INT PRIMARY Key,
title VARCHAR(255) NOT NULL UNIQUE,
body TEXT NOT NULL,
mainimageurl VARCHAR(255)
);
I'm not familiar with SQLtools, never used it but usually this type of error is immediately returned as you can see in this demo and you'll know at what point it have error; or at least you can see the error code/message and search for it's information on what's wrong.
推荐阅读
- javascript - 是否可以使用 Postman 在请求中调用另一个请求
- java - tomcat 10: java.lang.NoClassDefFoundError: jakarta/enterprise/context/spi/Contextual 错误
- c# - 如何编码我的 Nunit 测试以从命令行运行?
- javascript - 如何对所有分页页面上的列表进行排序?
- javascript - 在前端使用 Strapi 权限
- ios - _validateTextureView:557:断言失败“纹理视图验证无法从无记忆纹理创建视图”
- javascript - 如何切换相机 webrtc Android
- azure - 使用“2”参数解析异常调用“Parse”:“字符串未被识别为有效的 DateTime。”
- php - 加载更多按钮不起作用并显示页面上的所有记录
- google-cloud-platform - 被拒绝我在 GCP 中的权限