求助，请问我的sql语句哪里错了？

Question

在使用mysql建表时一直报错，但不知哪里写错了，求教各位大佬。

create table userconnect(
    -> rentid int(4) primary key not null auto_increment,
    -> rentname varchar(10) not null,
    -> rentcertificate varchar(50) not null,
    -> connectid int(4) foreign key(connectid) references users(userid)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Answer 1

少了一个,

create table userconnect(
    -> rentid int(4) primary key not null auto_increment,
    -> rentname varchar(10) not null,
    -> rentcertificate varchar(50) not null,
    -> connectid int(4),
    -> foreign key(connectid) references users(userid)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Answer 2

create table userconnect(
    rentid int(4) primary key not null auto_increment,
    rentname varchar(10) not null,
    rentcertificate varchar(50) not null,
    connectid int(4),
    foreign key(connectid) references users(userid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;