Re: Problems with ALTER TABLE

[pak attack]

An example of what I'm trying to do is:

CREATE TABLE EXAMPLE(
SEX VARCHAR(1),
N1 INT(9)
);
ALTER TABLE EXAMPLE ADD CONSTRAINT EXAMPLE_CONST CHECK(SEX IN('M','W'));

ANOTHER EXAMPLE:

ALTER TABLE EXAMPLE ADD CONSTRAINT EXAMPLE2_CONST CHECK(N1 BETWEEN 100 AND 1000);

Anyway, if I work with table restrictions the program says "QUERRY OK!" and the restriction does not work.

I downloaded the Windows x86 (mysql-4.1.18-win32) from: "http://dev.mysql.com/downloads/mysql/4.1.html";

My Operating System is Windows XP.

Thanks!