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