"Kraan Deufe" <[EMAIL PROTECTED]> wrote: > ok here we are, > > first of all, hi to every one since i'm new to this list. > > then it's my first real advanced experience with mysql, even if i've already > used SQL Server, PostgreSQL and (kof kof) Access. > > well, then i'm trying to create a heavy database with many relations and > check clauses. > > And i'm blocking on the check clause constraint. > > So i'm asking here for precisions: > is the check clause working ? (i've seen some post saying that it is not > working)
No, Currently CHECK doesn't work. > Wich kind of tables (BDB, InnoDB, ....) is supporting CHECK clauses, CASCADE > DELETE, CASCADE UPGRADE, REFERENCES. FOREIN KEY CONSTRAINTS with ON DELETE CASCADE, ON UPDATE CASCADE is supported on InnoDB tables. > and what is the problem with the following Query ? : > > CREATE TABLE IF NOT EXISTS definitions_avantages ( > id_avantage BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, > nom_avantage VARCHAR(128) NOT NULL UNIQUE CONSTRAINT CHECK (<> ''), -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]