Форум пользователей MySQL

CREATE TABLE `nomenklatura` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) NOT NULL,
  `sklad` varchar(50) NOT NULL,
  `article` varchar(50) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `original` varchar(2000) NOT NULL,
  `manufacturer` varchar(50) NOT NULL,
  `cen_grup` varchar(50) NOT NULL,
  `srok_sklad` tinyint(4) NOT NULL,
  `nal_sklad` smallint(6) NOT NULL,
  `big` tinyint(4) NOT NULL,
  `price` double NOT NULL,
  `val` varchar(3) NOT NULL,
  `ed` varchar(8) NOT NULL DEFAULT 'шт',
  `opisanie` varchar(1000) NOT NULL,
  `img` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`,`sklad`),
  KEY `article` (`article`,`manufacturer`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8

CREATE TEMPORARY TABLE temptab (uid varchar(50), sklad varchar(50), article varchar(50), name varchar(1000), original varchar(2000), manufacturer varchar(50), cen_grup varchar(50), srok_sklad tinyint(4), nal_sklad smallint(6), big tinyint(4), price double, val varchar(3), ed varchar(8))

LOAD DATA LOCAL INFILE "/home/public_html/load/1.txt" INTO TABLE temptab

INSERT INTO nomenklatura (uid, sklad, article, name, original, manufacturer, cen_grup, srok_sklad, nal_sklad, big, price, val, ed) SELECT temptab.uid, temptab.sklad, temptab.article, temptab.name, temptab.original, temptab.manufacturer, temptab.cen_grup, temptab.srok_sklad, temptab.nal_sklad, temptab.big, temptab.price, temptab.val, temptab.ed FROM temptab ON DUPLICATE KEY UPDATE nomenklatura.article=temptab.article, nomenklatura.name=temptab.name, nomenklatura.original=temptab.original, nomenklatura.manufacturer=temptab.manufacturer, nomenklatura.srok_sklad=temptab.srok_sklad, nomenklatura.nal_sklad=temptab.nal_sklad, nomenklatura.big=temptab.big, nomenklatura.price=temptab.price, nomenklatura.ed=temptab.ed

DROP TABLE temptab