Hi, Check this first: http://www.mysql.com/doc/en/CREATE_TABLE.html
On Mon, 2003-09-08 at 18:34, Kraan Deufe wrote: > hi, it's the third time i'm trying to post this message to the list.. so > please reply , even if it is for saying nothing.. only to be sure that this > mail have been distributed. > > Thanx > --------------- > > > > 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) > Wich kind of tables (BDB, InnoDB, ....) is supporting CHECK clauses, CASCADE > DELETE, CASCADE UPGRADE, REFERENCES. > 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 (<> ''), > description_avantage TEXT) > > thanx for your help. > > Kraan Deufe > even more than Kojak ;) > > -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]