下面的SQL语法哪里错了?怎样改正?create table catch_dedecms(id int auto_increment primary key,litpic varchar,litpic_path varchar,title varchar,area varchar,language varchar,year int,director varchar,actor varchar);报错:ERROR 1064 (4200
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 18:25:48
![下面的SQL语法哪里错了?怎样改正?create table catch_dedecms(id int auto_increment primary key,litpic varchar,litpic_path varchar,title varchar,area varchar,language varchar,year int,director varchar,actor varchar);报错:ERROR 1064 (4200](/uploads/image/z/10332090-18-0.jpg?t=%E4%B8%8B%E9%9D%A2%E7%9A%84SQL%E8%AF%AD%E6%B3%95%E5%93%AA%E9%87%8C%E9%94%99%E4%BA%86%3F%E6%80%8E%E6%A0%B7%E6%94%B9%E6%AD%A3%3Fcreate+table+catch_dedecms%28id+int+auto_increment+primary+key%2Clitpic+varchar%2Clitpic_path+varchar%2Ctitle+varchar%2Carea+varchar%2Clanguage+varchar%2Cyear+int%2Cdirector+varchar%2Cactor+varchar%29%3B%E6%8A%A5%E9%94%99%EF%BC%9AERROR+1064+%284200)
下面的SQL语法哪里错了?怎样改正?create table catch_dedecms(id int auto_increment primary key,litpic varchar,litpic_path varchar,title varchar,area varchar,language varchar,year int,director varchar,actor varchar);报错:ERROR 1064 (4200
下面的SQL语法哪里错了?怎样改正?
create table catch_dedecms
(id int auto_increment primary key,
litpic varchar,
litpic_path varchar,
title varchar,
area varchar,
language varchar,
year int,
director varchar,
actor varchar);
报错:
ERROR 1064 (42000):You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the r
ight syntax to use near '
litpic_path varchar,
title varchar,
area varchar,
language varchar,
y' at line 3
下面的SQL语法哪里错了?怎样改正?create table catch_dedecms(id int auto_increment primary key,litpic varchar,litpic_path varchar,title varchar,area varchar,language varchar,year int,director varchar,actor varchar);报错:ERROR 1064 (4200
您的varchar没有设定最大长度.varchar是可变的,所以必须要设定长度.
create table catch_dedecms
(id int auto_increment primary key,
litpic varchar(200),
litpic_path varchar(200),
title varchar(200),
area varchar(200),
language varchar(200),
year int,
director varchar(200),
actor varchar(200));