At 22:11 +0100 10/8/06, Deckard wrote:
Hi,How do i dreate a table, let's say: CREATE TABLE wl_articles(wl_articles_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, title TEXT NOT NULL, main TEXT NOT NULL, extended TEXT NOT NULL, permalink VARCHAR(255) NOT NULL, date DATE NOT NULL, ip VARCHAR(15), user_agent VARCHAR(50), status INTEGER NOT NULL, password VARCHAR(32) NOT NULL) TYPE=MyISAM; without allowing INSERTs to repeat rows based on certain fields, for example, "main" and "status" ?
Normally, you would do this by creating a UNIQUE index on the combination of columns. (Or you could use a PRIMARY KEY if both columns are NOT NULL.) However, you cannot do what you want in this case. Why? Because main is a TEXT column, and TEXT columns allow a maximum of 255 initial characters to be indexed. That means you cannot use a UNIQUE index to provide a uniqueness constraint on anything from the 256th character on. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
