表结构:CREATE TABLE `yjmxtb` ( `id` int(11) NOT NULL auto_increment, `yfid` varchar(6) NOT NULL, `ProducNo` varchar(40) NOT NULL, `ProducCN` varchar(50) NOT NULL, `rkcount` double(15,2) NOT NULL default '0.00', `ckcount` double(15,2) NOT NULL default '0.00', `ymjc` double(15,2) NOT NULL default '0.00', `wpbs` varchar(2) NOT NULL, `Sort` varchar(16) default NULL, `yjrq` date NOT NULL, `yqcsl` double(15,2) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1(a.ProducNo,a.ProducCN,a.yqcsl,a.rkcount,a.ckcount,a.ymjc )在表中如果yfid相同的情况下是不会重复的中是否会重复。这是一个月结表,YFID表示的是月结IDCREATE TABLE `famxtb` ( `id` int(11) NOT NULL auto_increment, `ProducNo` varchar(40) NOT NULL, `ProducCN` varchar(50) NOT NULL, `MateNo` varchar(40) NOT NULL, `faname` varchar(40) NOT NULL, `wlmc` varchar(50) NOT NULL, `wlsign` varchar(4) NOT NULL, `gyscode` varchar(16) default NULL, `gysjc` varchar(20) default NULL, `RMBPrice` varchar(16) default NULL, `count` varchar(12) NOT NULL, `htxz` varchar(16) default '随整机下', `Specification` varchar(60) default NULL, `kcs` varchar(3) default NULL, `stc` varchar(6) NOT NULL default '是', `hxgc` varchar(24) NOT NULL default '否', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1CREATE TABLE `fatb` ( `id` int(11) NOT NULL auto_increment, `ProducNo` varchar(40) NOT NULL, `ProducCN` varchar(50) NOT NULL, `faname` varchar(40) NOT NULL, `fazj` varchar(10) NOT NULL, `gyscode` varchar(20) NOT NULL, `gysjc` varchar(30) NOT NULL, `sort` varchar(10) NOT NULL, `gysbj` varchar(12) default NULL, `bhcp` varchar(20) NOT NULL, `fastate` varchar(10) NOT NULL, `fayx` varchar(20) default NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1