database - MYSQL key column does not exist -

i need assistance, 'key column' says not exist when does.

create table publisher (   lisher_id int primarykey,   lisher_name varchar(5nnull,   lisher_address varchar(not null,   lisher_phone varchar(5) null,  lisher_email varchar(4) null); 

the column name in foreign key clause has exist in table on you're defining constraint - in case, has column in table contract.

at guess, think want

create table contract (   ...   constraint fk_contract_publication foreign key (publication_pub_id)     references publication (pub_id));