MySQL Forums
Forum List  »  Newbie

Error Unexpected beginning of statement.
Posted by: Pedro Ruiz
Date: September 27, 2022 01:35PM

Hi i got this error when trying to create a database
I can't understand why, the tipo_vehiculo tabla and the conductor table use the same elements, but one gives me error but the other one doesn't i also get this error Unrecognized statement type. (near "int" at position 455)


SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

DROP SCHEMA IF EXISTS `mensajeria` ;
CREATE SCHEMA IF NOT EXISTS `mensajeria` DEFAULT CHARACTER SET latin1 ;
USE `mensajeria` ;

-- Table `mensajeria`.`Tipo_vehiculo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mensajeria`.`Tipo_vehiculo` (

`id_tipo_vehiculo` int(11)NOT NULL AUTO_INCREMENT,
`tipo_vehiculo` varchar (25),
PRIMARY KEY ('id_tipo_vehiculo'))

-- Table `mensajeria`.`Conductor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mensajeria`.`Conductor` (

`id_conductor` int(11)NOT NULL AUTO_INCREMENT,
`Nombre_conductor` varchar (25),
`Telefono` int (9),
`DNI` varchar(9),
PRIMARY KEY (`id_conductor`))

Options: ReplyQuote


Subject
Written By
Posted
Error Unexpected beginning of statement.
September 27, 2022 01:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.