Question

MYSQL #1064(42000)错误 我运行SQL代码的时候出现1064错误，我看不是很懂 麻烦大家帮我解决一下，谢谢了

错误提示：
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '
company_name VARCHAR,
city VARCHAR,
job_type VARCHAR,
salary VARCHAR,
work_year' at line 3

创建的表格语句：
CREATE TABLE lagou_data(
id BIGINT(7) NOT NULL AUTO_INCREMENT,
position VARCHAR,
company_name VARCHAR,
city VARCHAR,
job_type VARCHAR,
salary VARCHAR,
work_year VARCHAR,
education VARCHAR,
industry VARCHAR,
scale VARCHAR,
advantage VARCHAR,
created_time VARCHAR,
entered_time VARCHAR,
PRIMARY KEY(id));

Answer 1

VARCHAR 后面跟着大小试试 例如：VARCHAR(255)

Answer 2

网页链接

网页链接

可以参考一下这两篇博客