Re: [PHP-DB] MySQL: CREATE TABLE, BLOB, UNIQUE, INDEX etc

2003-08-29 Thread Ignatius Reilly
Ignatius _ - Original Message - From: "Dillon, John" <[EMAIL PROTECTED]> To: "php" <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 5:06 PM Subject: [PHP-DB] MySQL: CREATE TABLE, BLOB, UNIQUE, INDEX etc My code: $query=" CREATE TA

[PHP-DB] MySQL: CREATE TABLE, BLOB, UNIQUE, INDEX etc

2003-08-29 Thread Dillon, John
My code: $query=" CREATE TABLE IF NOT EXISTS temp3 UNIQUE(CON175) IGNORE SELECT DISTINCT CONCAT($tbl2.this,$tbl2.that) AS CON175 FROM $tbl2 WHERE $tbl2.this='$rcc' "; gives error: Query failed: BLOB column 'CON175' used in key specification without a key length. Manua