Update Table contents from another table I want to update the products table from my store db from a temp table.. the production table 'Products' needs to update all columns from the temp table 'tmpprod' based on StockCode and not change any other columns in the Products table

UPDATE Products
JOIN tmpprod
ON Products.StockCode = tmpprod.StockCode
    SET Products.CategoryCode = tmpprod.CategoryCode,
        Products.CategoryName = tmpprod.CategoryName,
        Products.SubcategoryID = tmpprod.SubcategoryID,
        Products.SubcategoryName = tmpprod.SubcategoryName,
        Products.BarCode = tmpprod.BarCode,
        Products.Weight = tmpprod.Weight,
        Products.ManufacturerSKU = tmpprod.ManufacturerSKU,
        Products.ProductName = tmpprod.ProductName,
        Products.WarrantyLength = tmpprod.WarrantyLength,
        Products.Manufacturer = tmpprod.Manufacturer,
        Products.DBP = tmpprod.DBP,
        Products.DBP5 = tmpprod.DBP5,
        Products.RRP = tmpprod.RRP,
        Products.StandardRRP = tmpprod.StandardRRP,
        Products.AvailabilityTotal = tmpprod.AvailabilityTotal,
        Products.AvailabilityAdelaide = tmpprod.AvailabilityAdelaide,
        Products.AvailabilityBrisbane = tmpprod.AvailabilityBrisbane,
        Products.AvailabilitySydney = tmpprod.AvailabilitySydney,
        Products.AvailabilityMelbourne = tmpprod.AvailabilityMelbourne,
        Products.AvailabilityPerth = tmpprod.AvailabilityPerth,
        Products.ImageUrl = tmpprod.ImageUrl,
        Products.ImageFilename = tmpprod.ImageFilename,
        Products.DescriptionLink = tmpprod.DescriptionLink


and...

CREATE TABLE `Products` (
    `StockCode` text, 
    `CategoryCode` text, 
    `CategoryName` text, 
    `SubcategoryID` int(11) DEFAULT NULL, 
    `SubcategoryName` text, 
    `BarCode` text, 
    `Weight` double DEFAULT NULL, 
    `ManufacturerSKU` text, 
    `ProductName` text, 
    `WarrantyLength` int(11) DEFAULT NULL, 
    `Manufacturer` text, 
    `DBP` int(11) DEFAULT NULL, 
    `DBP5` int(11) DEFAULT NULL, 
    `RRP` double DEFAULT NULL, 
    `StandardRRP` double DEFAULT NULL, 
    `AvailabilityTotal` text, 
    `AvailabilityAdelaide` text, 
    `AvailabilityBrisbane` text, 
    `AvailabilitySydney` text, 
    `AvailabilityMelbourne` text, 
    `AvailabilityPerth` text, 
    `ImageUrl` text, 
    `WebsiteUrl` text, 
    `ImageFilename` text, 
    `DescriptionLink` text, 
    `DateAdded` datetime DEFAULT CURRENT_TIMESTAMP, 
    `ForSale` int(11) NOT NULL DEFAULT \'0\'
) ENGINE=InnoDB DEFAULT CHARSET=latin1'


and...

'CREATE TABLE `tmpprod` (
    `StockCode` text,
    `CategoryCode` text,
    `CategoryName` text,
    `SubcategoryID` int(11) DEFAULT NULL, 
    `SubcategoryName` text, 
    `BarCode` text, 
    `Weight` double DEFAULT NULL, 
    `ManufacturerSKU` text, 
    `ProductName` text, 
    `WarrantyLength` int(11) DEFAULT NULL, 
    `Manufacturer` text, 
    `DBP` int(11) DEFAULT NULL, 
    `DBP5` int(11) DEFAULT NULL, 
    `RRP` double DEFAULT NULL, 
    `StandardRRP` double DEFAULT NULL, 
    `AvailabilityTotal` text, 
    `AvailabilityAdelaide` text, 
    `AvailabilityBrisbane` text, 
    `AvailabilitySydney` text, 
    `AvailabilityMelbourne` text, 
    `AvailabilityPerth` text, 
    `ImageUrl` text, 
    `WebsiteUrl` text, 
    `ImageFilename` text, 
    `DescriptionLink` text, 
    `DateAdded` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1'
According to Postgres docs (9.6):

UPDATE Products as P
SET P.CategoryCode = T.CategoryCode,
    P.CategoryName = T.CategoryName,
    P.SubcategoryID = T.SubcategoryID,
    P.SubcategoryName = T.SubcategoryName,
    P.BarCode = T.BarCode,
    P.Weight = T.Weight,
    P.ManufacturerSKU = T.ManufacturerSKU,
    P.ProductName = T.ProductName,
    P.WarrantyLength = T.WarrantyLength,
    P.Manufacturer = T.Manufacturer,
    P.DBP = T.DBP,
    P.DBP5 = T.DBP5,
    P.RRP = T.RRP,
    P.StandardRRP = T.StandardRRP,
    P.AvailabilityTotal = T.AvailabilityTotal,
    P.AvailabilityAdelaide = T.AvailabilityAdelaide,
    P.AvailabilityBrisbane = T.AvailabilityBrisbane,
    P.AvailabilitySydney = T.AvailabilitySydney,
    P.AvailabilityMelbourne = T.AvailabilityMelbourne,
    P.AvailabilityPerth = T.AvailabilityPerth,
    P.ImageUrl = T.ImageUrl,
    P.ImageFilename = T.ImageFilename,
    P.DescriptionLink = T.DescriptionLink
FROM tmpprod as T
WHERE P.StockCode = T.StockCode;


Although I used an alias, it is not indispensable.