Re: How to not repeat fields

2006-10-09 Thread Deckard
Hi, Now it's working :) CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(40) NOT NULL, UNIQUE (name, email, password)) TYPE=MyISAM; Thank you all. Warm Regards, Deckard Martijn Tonies wrote: >> No

Re: How to not repeat fields

2006-10-09 Thread Paul DuBois
At 17:17 +0100 10/9/06, Deckard wrote: Hi Paul, Now, i have this: CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(40) NOT NULL, UNIQUE (wl_user_id, email)) TYPE=MyISAM; and the issue persists :(

Re: How to not repeat fields

2006-10-09 Thread Martijn Tonies
> Now, i have this: > > CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY > KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password > VARCHAR(40) NOT NULL, UNIQUE (wl_user_id, email)) TYPE=MyISAM; > > and the issue persists :( Show us the data you're inserting int

Re: How to not repeat fields

2006-10-09 Thread Deckard
Hi Paul, Now, i have this: CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(40) NOT NULL, UNIQUE (wl_user_id, email)) TYPE=MyISAM; and the issue persists :( Best Regards, Deckard Paul DuBois wrot

Re: How to not repeat fields

2006-10-09 Thread Paul DuBois
At 22:43 +0100 10/8/06, Deckard wrote: Hi, Yes, it still allows duplicate (equal) rows to be inserted :( Best Regards, Deckard I don't see the test case I asked for. If you're seeing that records are duplicate except that they differ in ID value, that doesn't count as duplicate. But in that

Re: How to not repeat fields

2006-10-09 Thread Martijn Tonies
Hi, > Yes, it still allows duplicate (equal) rows to be inserted :( Show us the result of your SELECT * from wl_users Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database develo

Re: How to not repeat fields

2006-10-08 Thread Deckard
Hi, Yes, it still allows duplicate (equal) rows to be inserted :( Best Regards, Deckard Paul DuBois wrote: > At 22:21 +0100 10/8/06, Deckard wrote: >> Hi, >> >> Ok, naow i have this: >> >> CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT, name >> VARCHAR(255) NOT NULL, email VARCHAR(

Re: How to not repeat fields

2006-10-08 Thread Paul DuBois
At 22:21 +0100 10/8/06, Deckard wrote: Hi, 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 repeat

Re: How to not repeat fields

2006-10-08 Thread Deckard
Hi, 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 ro

Re: How to not repeat fields

2006-10-08 Thread Paul DuBois
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 VARCH