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

error #1064 u sql fajlu generisanom u MySQL Workbench-u 23.04.2010. u 18:46 · pre 201 mesec #1

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;

Potpis

www.eden.rs
Izdavač duhovne i filozofske literature

Re: error #1064 u sql fajlu generisanom u MySQL Workbench-u 23.04.2010. u 21:43 · pre 201 mesec #2

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

Re: error #1064 u sql fajlu generisanom u MySQL Workbench-u 27.04.2010. u 14:24 · pre 201 mesec #3

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';

Potpis

www.eden.rs
Izdavač duhovne i filozofske literature

Re: error #1064 u sql fajlu generisanom u MySQL Workbench-u 27.04.2010. u 19:55 · pre 201 mesec #4

el postoji mydb.users?

Potpis

arhimed
http://www.mysql.rs/ | http://elco.crsndoo.com/

Re: error #1064 u sql fajlu generisanom u MySQL Workbench-u 28.04.2010. u 09:22 · pre 201 mesec #5

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

Potpis

www.eden.rs
Izdavač duhovne i filozofske literature

Forum kao aplikacija na telefonu

Srodne teme