constraints

[Rodrigo Sakai]

  Hi, I need to do a constraint that checks if the field 'salary' of one table is not
smaller than zero. Like:

  create table employee (

     name varchar(30),
     salary numeric(10,2)

     constraint  ck_salary check (salary > 0)
  );

  What´s the sintaxe? I'am not finding the correct sintaxe to do this constraint.

  I'm using MySQL 4.1