"ENUM" is not vallid at his position, expecting ')' I'm keeping this error and I'm very new to mySQL so I don't know what is going on. The only way I found to remove this error  message is to put ')' before the ENUM and then the message change - &quot;ENUM&quot; is not valid at this position, expecting EOF, ';'.
USE labo3_partie2;
CREATE TABLE fournisseur(
        numero SMALLINT UNSIGNED PRIMARY KEY,
        nom VARCHAR(40) NOT NULL,
        prenom VARCHAR(40),
        chiffreAffaire DECIMAL(7,2) CHECK ((chiffreAffaire &gt;= 20000) &amp;&amp; (chiffreAffaire &lt;= 1000000)),
        province CHAR(2) DEFAULT 'QC' ENUM('QC','ON','NB')
);
MySQL (and SQL in general??) is very picky about the order of things1.
province CHAR(2) DEFAULT 'QC' ENUM('QC','ON','NB')

--&gt;
province  ENUM('QC','ON','NB')  DEFAULT 'QC'  -- if you want ENUM

But also, ENUM and CHAR are two different datatypes.  So, maybe you wanted this:
province CHAR(2) DEFAULT 'QC'                 -- if you want CHAR


1 - You should try to become comfortable reading syntax diagrams, such as this for the create table statement.