Display fields depending on whether one field is a duplicate of another

Databases
21

Below is what I put together but nothing worked. I may have to just do it manually


CREATE TABLE WebsiteTemp
( WebsiteTitle VARCHAR(200) NOT NULL
, WebsiteName VARCHAR(200) NOT NULL
, WebsiteURL VARCHAR(200) NOT NULL
, Description VARCHAR(200) NOT NULL
, AffiliateURL VARCHAR(200) NOT NULL
, SEOTitle VARCHAR(200) NOT NULL
, SEOKeyword VARCHAR(200) NOT NULL
, IsActive VARCHAR(200) NOT NULL
, IsFeatured VARCHAR(200) NOT NULL
, SearchKeywords VARCHAR(200) NOT NULL
, DateAdded TIMESTAMP 
, Views INTEGER NOT NULL  
, WebsiteID INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT )
SELECT t.WebsiteID
     , t.WebsiteTitle
     , t.WebsiteName
     , t.WebsiteURL
     , t.Description
     , t.AffiliateURL
     , t.SEOTitle
     , t.SEOKeyword
     , t.IsActive
     , t.IsFeatured
     , t.SearchKeywords
     , t.DateAdded
     , t.Views   
  FROM Website AS t
INNER
  JOIN ( SELECT WebsiteTitle
              , MIN(WebsiteID) AS min_id
           FROM Website
         GROUP
             BY WebsiteTitle ) AS x
    ON x.min_id = t.WebsiteID;

DROP TABLE Website;

RENAME
22

compare the columns in your CREATE TABLE statement with the columns in the SELECT statement which is feeding them

notice the sequence is wrong… WebsiteID goes into WebsiteTitle, WebsiteTitle goes into WebsiteName, and so on

they have to line up exactly