MySQL自增和主键的报错

mysql遇到的两个报错原因
表中的’courseid’字段没有设置为自增

 Field 'courseid' doesn't have a default value

要设置为自增字段的字段不是主键

Incorrect table definition; there can be only one auto column and 
it must be defined as a key