Ok, naow i have this:
CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT, name
VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(32)
NOT NULL, PRIMARY KEY (wl_user_id, name, email, password)) TYPE=MyISAM;
and it lets repeated rows.
How can i avoid the repeates rows ?
Paul DuBois wrote:
> At 22:11 +0100 10/8/06, Deckard wrote:
>> 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.