insertar datos de la tabla clientes a seguimiento_clientes
| User, date | Message |
|---|---|
|
Written by afal3d
2 years ago Category: General 14 posts since Wed, 06 Jul 11 |
CREATE TABLE `seguimiento_clientes` ( `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `CEDULA` INT(10) UNSIGNED NULL DEFAULT NULL, `LUGAR_EXPEDICION` VARCHAR(50) NULL DEFAULT NULL, `NOMBRE_COMPLETO` VARCHAR(100) NULL DEFAULT NULL, `PROFESION` VARCHAR(50) NULL DEFAULT NULL, `DIRECCION_RESIDENCIAL` VARCHAR(100) NULL DEFAULT NULL, `CIUDAD` VARCHAR(50) NULL DEFAULT NULL, `DEPARTAMENTO` VARCHAR(50) NULL DEFAULT NULL, `EMAIL` VARCHAR(100) NULL DEFAULT NULL, `TEL_RESIDENCIA` INT(10) UNSIGNED NULL DEFAULT NULL, `TEL_TRABAJO` INT(10) UNSIGNED NULL DEFAULT NULL, `NUM_FACTURA` INT(6) UNSIGNED ZEROFILL NOT NULL, `TIPO_CARTERA` VARCHAR(50) NULL DEFAULT NULL, `FECHA_MORA` DATE NULL DEFAULT NULL, `DIAS_MORA` INT(2) UNSIGNED ZEROFILL NULL DEFAULT NULL, `VAL_MORA` DOUBLE UNSIGNED NULL DEFAULT NULL, `V_SEGURO` DOUBLE UNSIGNED NULL DEFAULT NULL, `INTERES_MORA` DOUBLE UNSIGNED NULL DEFAULT NULL, `SALD_RESTANTE` DOUBLE UNSIGNED NULL DEFAULT NULL, `TIPO_COBRO` VARCHAR(50) NULL DEFAULT NULL, `FECHA_ACUERDO_UNO` DATETIME NULL DEFAULT NULL, `ACUERDO_UNO` VARCHAR(255) NULL DEFAULT NULL, `FECHA_ACUERDO_DOS` DATETIME NULL DEFAULT NULL, `ACUERDO_DOS` VARCHAR(255) NULL DEFAULT NULL, `FECHA_ACUERDO_TRES` DATETIME NULL DEFAULT NULL, `ACUERDO_TRES` VARCHAR(255) NULL DEFAULT NULL, `FECHA_ACUERDO_CUATRO` DATETIME NULL DEFAULT NULL, `ACUERDO_CUATRO` VARCHAR(255) NULL DEFAULT NULL, PRIMARY KEY (`ID`) ) CREATE TABLE `clientes` ( `CEDULA` INT(10) UNSIGNED NULL DEFAULT NULL, `LUGAR_EXPEDICION` VARCHAR(50) NULL DEFAULT NULL, `NOMBRE_COMPLETO` VARCHAR(100) NULL DEFAULT NULL, `PROFESION` VARCHAR(50) NULL DEFAULT NULL, `DIRECCION_RESIDENCIAL` VARCHAR(100) NULL DEFAULT NULL, `CIUDAD` VARCHAR(50) NULL DEFAULT NULL, `DEPARTAMENTO` VARCHAR(50) NULL DEFAULT NULL, `EMAIL` VARCHAR(100) NULL DEFAULT NULL, `TEL_RESIDENCIA` INT(10) UNSIGNED NULL DEFAULT NULL, `TEL_TRABAJO` INT(10) UNSIGNED NULL DEFAULT NULL, `NUM_FACTURA` INT(6) UNSIGNED ZEROFILL NOT NULL, `FECHA_CREDITO` DATE NULL DEFAULT NULL, `TIPO_CARTERA` VARCHAR(50) NULL DEFAULT NULL, `VALOR_CREDITO` DOUBLE UNSIGNED NULL DEFAULT NULL, `NUM_CUOTAS` INT(2) UNSIGNED ZEROFILL NULL DEFAULT NULL, PRIMARY KEY (`NUM_FACTURA`) ) I have the customers table and seguimiento_clientes and I would like to insert customer data `CEDULA` INT(10) UNSIGNED NULL DEFAULT NULL, `LUGAR_EXPEDICION` VARCHAR(50) NULL DEFAULT NULL, `NOMBRE_COMPLETO` VARCHAR(100) NULL DEFAULT NULL, `PROFESION` VARCHAR(50) NULL DEFAULT NULL, `DIRECCION_RESIDENCIAL` VARCHAR(100) NULL DEFAULT NULL, `CIUDAD` VARCHAR(50) NULL DEFAULT NULL, `DEPARTAMENTO` VARCHAR(50) NULL DEFAULT NULL, `EMAIL` VARCHAR(100) NULL DEFAULT NULL, `TEL_RESIDENCIA` INT(10) UNSIGNED NULL DEFAULT NULL, `TEL_TRABAJO` INT(10) UNSIGNED NULL DEFAULT NULL, `NUM_FACTURA` INT(6) UNSIGNED ZEROFILL NOT NULL, Table segumiento_clientes as I make this insert query. |
|
Written by afal3d
2 years ago 14 posts since Wed, 06 Jul 11 |
insert data from the Customers table to seguimiento_clientes |
|
Written by ansgar
2 years ago 3960 posts since Fri, 07 Apr 06 |
Is there a hidden question in your post? I can't find it, please help. |
|
Please login to leave a reply, or register at first. |