Witam, użyłem programu DBDesingner do utworzenia poniżaszych tabel.
CREATE TABLE dball (
id_dball INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
proc VARCHAR(8) NULL,
plec CHAR(1) NULL,
data_2 DATETIME NULL,
imie VARCHAR(45) NULL,
nazwa VARCHAR(45) NULL,
kores CHAR(1) NULL,
adr_s_p VARCHAR(6) NULL,
adres_stary_1 VARCHAR(45) NULL,
adres_stary_2 VARCHAR(45) NULL,
adr_n_p VARCHAR(6) NULL,
adres_nowy_1 VARCHAR(45) NULL,
adres_nowy_2 VARCHAR(45) NULL,
adr_k_p VARCHAR(6) NULL,
adres_kores_1 VARCHAR(45) NULL,
adres_kores_2 VARCHAR(45) NULL,
init VARCHAR(45) NULL,
uniqNr INTEGER(9) NULL,
PRIMARY KEY(id_dball)
);
CREATE TABLE dbaneks (
id_dbaneks INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
dbewid_id_dbewid INTEGER UNSIGNED NOT NULL,
proc VARCHAR(8) NULL,
data_2 DATETIME NULL,
stary_numer INTEGER(9) NULL,
uniqNr INTEGER(9) NULL,
init VARCHAR(45) NULL,
PRIMARY KEY(id_dbaneks),
INDEX dbaneks_FKIndex1(dbewid_id_dbewid)
);
CREATE TABLE dbewid (
id_dbewid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
dball_id_dball INTEGER UNSIGNED NOT NULL,
data_2 DATETIME NULL,
nowa_nazwa VARCHAR(45) NULL,
stary_numer INTEGER(9) NULL,
stary_nrdo_1 CHAR(6) NULL,
stary_nrdo_2 INTEGER(9) NULL,
nowy_nrdo_1 CHAR(6) NULL,
nowy_nrdo_2 INTEGER(9) NULL,
stary_pesel DECIMAL NULL,
nowy_pesel DECIMAL NULL,
stary_regon DECIMAL NULL,
nowy_regon DECIMAL NULL,
stary_nipp DECIMAL NULL,
nowy_nipp DECIMAL NULL,
nrCrm INTEGER(10) NULL,
PRIMARY KEY(id_dbewid),
INDEX dbewid_FKIndex1(dball_id_dball)
);
CREATE TABLE dbstac (
id_dbstac INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
dbaneks_id_dbaneks INTEGER UNSIGNED NOT NULL,
dball_id_dball INTEGER UNSIGNED NOT NULL,
wtstat CHAR(1) NULL,
zach CHAR(1) NULL,
data_2 DATETIME NULL,
stary_numer INTEGER(9) NULL,
nowy_numer INTEGER(9) NULL,
zastrz CHAR(1) NULL,
tel000 VARCHAR(20) NULL,
PRIMARY KEY(id_dbstac),
INDEX dbstac_FKIndex1(dball_id_dball),
INDEX dbstac_FKIndex2(dbaneks_id_dbaneks)
);
jakiego zapytania użyć żeby zapisywać jednocześnie do każdej tabeli dane ?