| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Deckard | Date: | October 8 2006 9:11pm |
| Subject: | How to not repeat fields | ||
| View as plain text | |||
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" ?
Any help would be appreciated.
Warm Regards,
Deckard
| Thread | ||
|---|---|---|
| • How to not repeat fields | Deckard | 8 Oct |
| • Re: How to not repeat fields | Paul DuBois | 8 Oct |
| • Re: How to not repeat fields | Deckard | 8 Oct |
| • Re: How to not repeat fields | Paul DuBois | 8 Oct |
| • Re: How to not repeat fields | Deckard | 8 Oct |
| • Re: How to not repeat fields | Paul DuBois | 9 Oct |
| • Re: How to not repeat fields | Deckard | 9 Oct |
| • Re: How to not repeat fields | Paul DuBois | 9 Oct |
| • Re: How to not repeat fields | Martijn Tonies | 9 Oct |
| • Re: How to not repeat fields | Martijn Tonies | 9 Oct |
| • Re: How to not repeat fields | Deckard | 9 Oct |
