creating table syntax error I have a problem creating the table. It says unexpected parenthesis at line 3

CREATE DATABASE scl_teachers;

USE scl_teachers;

CREATE TABLE clteacher (
    'id' INT (10) PRIMARY KEY auto_increment,
    'f_name' VARCHAR(255) NOT NULL,
    'mid_initials' (255) IS NULL,
    'l_name' VARCHAR(255) NOT NULL,
    'saturation' VARCHAR(2)
);
You don't use single quotes ' to quote identifiers in MySQL.  You use a backtick ` or you can use nothing at all, if the identifier isn't a reserved word. 

'mid_initials' (255) IS NULL,


Should be

`mid_initials` VARCHAR(255) DEFAULT NULL,


...although using a VARCHAR(255) seems unnecessarily large.