error #1064 u sql fajlu generisanom u MySQL Workbench-u

[ damso @ 23.04.2010. 17:46 ] @

Nisam mjenjao ni liniju od izgenerisanog fajla.

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;

[ Nikola Poša @ 23.04.2010. 20:43 ] @

Fali ti tip za tu kolonu "idUsers" (pretpostavljam INT), jer ne možeš da staviš samo ime kolone, pa NOT NULL.

[ damso @ 27.04.2010. 13:24 ] @

HVALA

ima jos jedan problem

MySQL said:
#1005 - Can't create table 'mydb.put' (errno: 150)

CREATE TABLE IF NOT EXISTS `mydb`.`Put` (
`idPut` INT NOT NULL AUTO_INCREMENT ,
`Polaziste` INT NULL ,
`Destinacija` INT NULL ,
`Datum` DATE NULL ,
`Vozac` INT NULL ,
`Putnik` INT NULL ,
PRIMARY KEY ( `idPut` ) ,
INDEX `fk_Put_Gradovi` ( `Polaziste` ASC , `Destinacija` ASC ) ,
INDEX `fk_Put_Users` ( `Vozac` ASC , `Putnik` ASC ) ,
CONSTRAINT `fk_Put_Gradovi` FOREIGN KEY ( `Polaziste` , `Destinacija` ) REFERENCES `mydb`.`Gradovi` (
`idGrad` ,
`idGrad`
) ON DELETE NO ACTION ON UPDATE NO ACTION ,
CONSTRAINT `fk_Put_Users` FOREIGN KEY ( `Vozac` , `Putnik` ) REFERENCES `mydb`.`Users` (
`idUsers` ,
`idUsers`
) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE = InnoDB COMMENT = 'definisani put od grada do grada';

[ bogdan.kecman @ 27.04.2010. 18:55 ] @

el postoji mydb.users?

[ damso @ 28.04.2010. 08:22 ] @

Da,postoji tabela ,napravio je obe tabele Users i Gradovi

sva polja imaju tipove,
ID je NOT NULL,AUTO INCREMENT

Evo vise informacija o gresci pomocu SHOW ENGINE innodb STATUS :

LATEST FOREIGN KEY ERROR
------------------------
100428 11:47:20 Error in foreign key constraint of table mydb/put:

FOREIGN KEY (`Polaziste` , `Destinacija` )
REFERENCES `mydb`.`Gradovi` (`idGrad` , `idGrad` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Put_Users`
FOREIGN KEY (`Vozac` , `Putnik` )
REFERENCES `mydb`.`Users` (`idUsers` , `idUsers` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'definisani put od grada do grada':

Cannot find an index in the referenced table where the
referenced columns appear as the first columns, or column types
in the table and the referenced table do not match for constraint.
Note that the internal storage type of ENUM and SET changed in
tables created with >= InnoDB-4.1.12, and such columns in old tables
cannot be referenced by such columns in new tables.
See http://dev.mysql.com/doc/refma...b-foreign-key-constraints.html
for correct foreign key definition

Ovo drugo za gresku otpada jer su svi brojevi stavljeni na INT
Ovo prvo za INDEX ne shvatam dobro

_{[Ovu poruku je menjao damso dana 28.04.2010. u 11:48 GMT+1]}

_{[Ovu poruku je menjao damso dana 28.04.2010. u 11:52 GMT+1]}