Re: Insert doesn't work
Sorry for the delay.
Here is the insert statement that presents the problem:
INSERT INTO clientes (CliCode, CliName, CliShort, CliFecIni, CliAddr, CliRTN, CliPhone1, CliPhone2, CliWeb, CliSect, CliAct, CliReg, CliAnno, CliCorr, CliComPar)
SELECT CLICODIGO, CLINOMBRE, coalesce(CLINOMBRE_CORTO, left(CLINOMBRE, 30)), coalesce(CLIFECINI, str_to_date(mid(CLICODIGO, 4, 4), '%Y')), CLI_DIRECCION, CLIRTN, CLITELEFONO1, CLITELEFONO2, CLIWEB, CLISECT, CLIACT, CLIREG, CLIANNO, CLICORR, 0 FROM clientes25abr WHERE EVAL = 0;
The recieving (destination) table is CLIENTES. It has 4131 rows. I can provide a csv table with content but you would have to tell me how to send it to you.
CREATE TABLE `clientes` (
`CliCode` bigint(20) unsigned NOT NULL COMMENT 'Código del cliente: CliReg * 100000000 + CliAnno*10000 + CliCorr',
`CliName` varchar(160) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'Nombre (completo) del Cliente',
`CliShort` varchar(30) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'Siglas o nombre abreviado\n',
`CliFecIni` datetime DEFAULT NULL,
`CliAddr` varchar(256) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'Direccion',
`CliSocSecID` varchar(20) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'Numero patronal IHSS',
`CliRTN` varchar(25) COLLATE latin1_spanish_ci DEFAULT NULL,
`CliPhone1` varchar(20) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'Telefono 1',
`CliPhone2` varchar(20) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'Telefono 2',
`CliWeb` varchar(120) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'Sitio web del cliente',
`CliSect` char(1) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'Sector Económico',
`CliAct` smallint(4) unsigned DEFAULT NULL COMMENT 'Actividad Economica',
`CliReg` smallint(4) unsigned DEFAULT NULL,
`CliAnno` smallint(4) unsigned DEFAULT NULL,
`CliCorr` smallint(4) unsigned DEFAULT NULL,
`CliComPar` tinyint(1) DEFAULT NULL COMMENT 'Si tiene o no comite paritario (Comisión Mixta de Higiene y Seguridad)',
PRIMARY KEY (`CliCode`),
KEY `fk_CliCIIU_idx` (`CliSect`,`CliAct`),
KEY `fk_CliReg_idx` (`CliReg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci COMMENT='Contiene los datos generales de los patronos inscritos'
The table of origin is CLIENTES25ABR. This table has 3443 rows but only 15 comply with EVAL = 0. I can also send a csv data table.
CREATE TABLE `clientes25abr` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CLICODIGO` bigint(20) DEFAULT NULL,
`CLINOMBRE` varchar(255) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLINOMBRE_CORTO` varchar(45) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLIFECINI` datetime DEFAULT NULL,
`CLI_DIRECCION` varchar(255) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLISOCSECID` varchar(25) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLIRTN` varchar(25) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLITELEFONO1` varchar(45) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLITELEFONO2` varchar(45) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLIWEB` varchar(45) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLISECT` varchar(5) COLLATE latin1_spanish_ci DEFAULT NULL,
`CLIACT` int(11) DEFAULT NULL,
`CLIREG` int(11) DEFAULT NULL,
`CLIANNO` int(11) DEFAULT NULL,
`CLICORR` int(11) DEFAULT NULL,
`CLICOMPAR` varchar(5) COLLATE latin1_spanish_ci DEFAULT NULL,
`ESTADO` varchar(5) COLLATE latin1_spanish_ci DEFAULT NULL,
`FECHA` datetime DEFAULT NULL,
`EVAL` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3447 DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci
These tables have