agrovocterm structure

agrovocterm

CREATE TABLE IF NOT EXISTS `agrovocterm` (
  `termcode` int(11) NOT NULL DEFAULT '0',
  `languagecode` varchar(2) NOT NULL,
  `termspell` varchar(170) NOT NULL,
  `statusid` tinyint(4) DEFAULT NULL,
  `createdate` datetime DEFAULT NULL,
  `frequencyiad` int(11) DEFAULT NULL,
  `frequencycad` int(11) DEFAULT NULL,
  `lastupdate` datetime DEFAULT NULL,
  `scopeid` varchar(2) DEFAULT NULL,
  `idowner` tinyint(4) DEFAULT '10',
  `termsense` tinyint(4) DEFAULT NULL,
  `termoffset` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`termcode`,`languagecode`,`termspell`),
  KEY `agrovocterm_termcode` (`termcode`),
  KEY `agrovocterm_languagecode` (`languagecode`),
  KEY `agrovocterm_termspell` (`termspell`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

exportar a csv

SELECT termcode, languagecode, termspell FROM agrovocterm INTO OUTFILE '/tmp/agrovocterm2.csv' FIELDS TERMINATED BY '|' ENCLOSED BY '"' LINES TERMINATED BY '\n';