Code:
CREATE TABLE `dokument_glava` (
`id_glava` int(10) unsigned NOT NULL AUTO_INCREMENT,
`broj` int(6) unsigned zerofill NOT NULL,
`rel_id_dok` mediumint(3) unsigned NOT NULL,
`rel_id_kupac` int(4) unsigned zerofill NOT NULL,
`datum` date NOT NULL,
`pdv` decimal(4,2) unsigned NOT NULL,
`id_val` int(1) unsigned NOT NULL COMMENT 'id valute',
`kurs` decimal(8,4) unsigned NOT NULL,
`napomena` varchar(300) NOT NULL,
`rok_placanja` int(4) unsigned NOT NULL,
PRIMARY KEY (`id_glava`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8
Code:
CREATE TABLE `dokument_stavke` (
`redni_broj` int(10) unsigned NOT NULL,
`broj` int(6) unsigned zerofill NOT NULL,
`rel_id_dok` mediumint(3) unsigned NOT NULL,
`rel_id_proizvod` int(5) unsigned NOT NULL,
`kolicina` decimal(8,2) unsigned NOT NULL,
`cena_jm` decimal(10,2) unsigned NOT NULL,
`rel_id_mere` int(1) unsigned NOT NULL,
`rabat` decimal(4,2) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Code:
CREATE TABLE `veza_dokumenata` (
`rel_id_dok` int(3) unsigned NOT NULL,
`broj` int(6) unsigned NOT NULL,
`rel_drugi_dok` int(3) unsigned NOT NULL,
`broj_drugi_dok` int(6) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
E ovo je konkretan primer...
Broj i rel_id_dok u prve dve tabele moram imati... treca mi je za vezu između dokumenata...
Upit:
Code:
DELETE dokument_glava.*, dokument_stavke.*, veza_dokumenata.* FROM dokument_glava,dokument_stavke,veza_dokumenata
WHERE dokument_glava.broj = dokument_stavke.broj AND dokument_glava.rel_id_dok = dokument_stavke.rel_id_dok
AND dokument_glava.broj = veza_dokumenata.broj_drugi_dok AND dokument_glava.rel_id_dok = veza_dokumenata.rel_drugi_dok
AND dokument_glava.broj=130004 AND dokument_glava.rel_id_dok=100;
Brisanje slogova iz više tabela
