Respuesta: MySQL Workbench: ¿Qué les parece? hola disculpen, yo creo una base de datos, la lleno en el work, y cuando la quiero cargar con el administrator me tira todo esto, y me tira las tablas vacias, y hay una de ellas que no me las pasa.
Error while executing this query:CREATE TABLE IF NOT EXISTS `Computación`.`Direcciones` (
`id_direccion` INT NOT NULL ,
`Ciudad_idCiudad` INT NOT NULL ,
`Codigo_postal` VARCHAR(45) NULL ,
`nombre` NULL ,
`Region_idRegion` INT NOT NULL ,
PRIMARY KEY (`id_direccion`) ,
INDEX `fk_Direcciones_Ciudad` (`Ciudad_idCiudad` ASC) ,
INDEX `fk_Direcciones_Region` (`Region_idRegion` ASC) ,
CONSTRAINT `fk_Direcciones_Ciudad`
FOREIGN KEY (`Ciudad_idCiudad` )
REFERENCES `Computación`.`Ciudad` (`idCiudad` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Direcciones_Region`
FOREIGN KEY (`Region_idRegion` )
REFERENCES `Computación`.`Region` (`idRegion` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB DEFAULT CHARSET=utf8;
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL ,
`Region_idRegion` INT NOT NULL ,
PRIMARY KEY (`id_direccion`) ,
IND' at line 5
Error while executing this query:CREATE TABLE IF NOT EXISTS `Computación`.`Stock` (
`IdStock` INT NOT NULL ,
`Comentario` VARCHAR(45) NULL DEFAULT NULL ,
`Fecha_Ingreso` DATETIME NULL DEFAULT NULL ,
`Stock_Max` INT NULL DEFAULT NULL ,
`Stock` INT NULL DEFAULT NULL ,
`Punto_Repo` VARCHAR(45) NULL DEFAULT NULL ,
`Almacenes_IdDeposito` INT NOT NULL DEFAULT NULL ,
`Productos_Cod_Prod` INT NOT NULL DEFAULT NULL ,
PRIMARY KEY (`IdStock`, `Almacenes_IdDeposito`, `Productos_Cod_Prod`) ,
INDEX `fk_Stock_Almacenes` (`Almacenes_IdDeposito` ASC) ,
INDEX `fk_Stock_Productos` (`Productos_Cod_Prod` ASC) ,
CONSTRAINT `fk_Stock_Almacenes`
FOREIGN KEY (`Almacenes_IdDeposito` )
REFERENCES `Computación`.`Almacenes` (`IdDeposito` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Stock_Productos`
FOREIGN KEY (`Productos_Cod_Prod` )
REFERENCES `Computación`.`Productos` (`Cod_Prod` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB DEFAULT CHARSET=utf8;
The server has returned this error message:Invalid default value for 'Almacenes_IdDeposito'
Error while executing this query:INSERT INTO `Computación`.`Region` (`idRegion`, `Nombre`) VALUES ('1', 'Capital Federal, Gran Buenos Aires, Mar del Plata');
The server has returned this error message:Data too long for column 'Nombre' at row 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('1', '0', '1875', \func ba18, '1');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func ba18, '1')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('2', '0', '1876', \func sa19, '2');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func sa19, '2')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('3', '0', '1877', \func su78, '3');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func su78, '3')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('4', '0', '1878', \func cae1235, '4');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func cae1235, '4')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('5', '0', '1879', \func bar033, '5');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func bar033, '5')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('6', '0', '1875', \func daes88, '1');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func daes88, '1')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('7', '0', '1875', \func juo1569, '2');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func juo1569, '2')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('8', '0', '1875', \func lop1587, '3');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func lop1587, '3')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES ('9', '0', '1875', \func erp120, '4');
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\func erp120, '4')' at line 1
Error while executing this query:INSERT INTO `Computación`.`Direcciones` (`id_direccion`, `Ciudad_idCiudad`, `Codigo_postal`, `nombre`, `Region_idRegion`) VALUES (NULL, NULL, NULL, NULL, '');
The server has returned this error message:Table 'computación.direcciones' doesn't exist
Error while executing this query:INSERT INTO `Computación`.`Clientes` (`idClientes`, `Nombre`, `Telefono`, `Rango_cred`, `Observacion`, `idTipo`, `Paises_idPaises`, `Direcciones_id_direccion`, `Ciudad_idCiudad`) VALUES ('1', 'Nation Wide', '4111-111', '5000', NULL, '1', '1', '1', '1');
The server has returned this error message:Cannot add or update a child row: a foreign key constraint fails (`computación`.`clientes`, CONSTRAINT `fk_Clientes_Tipo_Cliente` FOREIGN KEY (`idTipo`) REFERENCES `pre_cliente` (`idTipo`) ON DELETE NO ACTION ON UPDATE NO ACTION)
Error while executing this query:INSERT INTO `Computación`.`Clientes` (`idClientes`, `Nombre`, `Telefono`, `Rango_cred`, `Observacion`, `idTipo`,
alguien sabe como arreglarlo? |