CREATE TABLE and CHECK Clause

2003-09-08 Thread Kraan Deufe
XISTS 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 ;) -- MySQL General Ma

Fw: CREATE TABLE and CHECK Clause

2003-09-07 Thread Kraan Deufe
sorry, it's only for testing Kraan Deufe even more than Kojak - Original Message - From: Kraan Deufe To: [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 1:07 PM Subject: CREATE TABLE and CHECK Clause ok here we are, first of all, hi to every one since i'm new to this l

CREATE TABLE and CHECK Clause

2003-09-07 Thread Kraan Deufe
PGRADE, 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