distal-attribute
distal-attribute
distal-attribute
distal-attribute

insertar datos de la tabla clientes a seguimiento_clientes

User, date Message
Written by afal3d
3 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
3 years ago
14 posts since Wed, 06 Jul 11
insert data from the Customers table to seguimiento_clientes
Written by ansgar
3 years ago
5045 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.