[es] - error #1064 u sql fajlu generisanom u MySQL Workbench-u

damso
Novi Sad

Član broj: 78853
Poruke: 158
*.dynamic.sbb.rs.

+9 Profil

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

^{23.04.2010. u 17:46 - pre 170 meseci}

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;

www.eden.rs
Izdavač duhovne i filozofske literature

Odgovor na temu

Nikola Poša
Backend (PHP) developer
Beograd

Član broj: 173839
Poruke: 1616
*.adsl-a-1.sezampro.yu.

+33 Profil

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

^{23.04.2010. u 20:43 - pre 170 meseci}

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

Odgovor na temu

damso
Novi Sad

Član broj: 78853
Poruke: 158
*.dynamic.sbb.rs.

+9 Profil

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

^{27.04.2010. u 13:24 - pre 170 meseci}

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

www.eden.rs
Izdavač duhovne i filozofske literature

Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.31.24.217.adsl2.beograd.com.

Sajt: mysql.rs

+2377 Profil

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

^{27.04.2010. u 18:55 - pre 170 meseci}

el postoji mydb.users?

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

Odgovor na temu

damso
Novi Sad

Član broj: 78853
Poruke: 158
*.dynamic.sbb.rs.

+9 Profil

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

^{28.04.2010. u 08:22 - pre 170 meseci}

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]}

www.eden.rs
Izdavač duhovne i filozofske literature

Odgovor na temu