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 fieldsDeckard8 Oct
  • Re: How to not repeat fieldsPaul DuBois8 Oct
    • Re: How to not repeat fieldsDeckard8 Oct
      • Re: How to not repeat fieldsPaul DuBois8 Oct
        • Re: How to not repeat fieldsDeckard8 Oct
          • Re: How to not repeat fieldsPaul DuBois9 Oct
            • Re: How to not repeat fieldsDeckard9 Oct
              • Re: How to not repeat fieldsPaul DuBois9 Oct
  • Re: How to not repeat fieldsMartijn Tonies9 Oct
  • Re: How to not repeat fieldsMartijn Tonies9 Oct
    • Re: How to not repeat fieldsDeckard9 Oct