Error
SQL query:
-- -----------------------------------------------------
-- Table `mydb`.`Users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Users` (
`idUsers` NOT NULL ,
`Ime` VARCHAR( 45 ) NULL ,
`Prezime` VARCHAR( 45 ) NULL ,
`JMBG` INT NULL ,
PRIMARY KEY ( `idUsers` )
) ENGINE = InnoDB COMMENT = 'Svi ljudi';
MySQL said: Documentation
#1064 - 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 'NOT NULL ,
`Ime` VARCHAR(45) NULL ,
`Prezime` VARCHAR(45) NULL ,
`JMBG`' at line 5
Sto je najzanimljivije slicna tabela "Gradovi " je prosla bez problema:
CREATE TABLE IF NOT EXISTS `mydb`.`Gradovi` (
`Ime` VARCHAR(45) NULL ,
`Drzava` VARCHAR(45) NULL ,
`BrStanovnika` INT NULL ,
`idGrad` INT NOT NULL AUTO_INCREMENT ,
PRIMARY KEY (`idGrad`) )
ENGINE = InnoDB;
SHOW WARNINGS;
Izdavač duhovne i filozofske literature