Database Queries

DELETE FROM `ruolo_sanzioni`

DELETE FROM `n0`

DELETE FROM `n1`

DELETE FROM `n2`

DELETE FROM `n3`

DELETE FROM `n4`

DELETE FROM `n5`

DELETE FROM `n9`

SHOW FULL COLUMNS FROM `db2_bollettario`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_bollettario' AND kcu.table_name = 'db2_bollettario'

SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='7163'

SHOW FULL COLUMNS FROM `db2_infrazione`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_infrazione' AND kcu.table_name = 'db2_infrazione'

SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='7163'

SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario` IN (1, 2, 3, 4, 20)) AND (`id_bollettario_proprietario`='7163')

SHOW FULL COLUMNS FROM `db2_proprietario`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_proprietario' AND kcu.table_name = 'db2_proprietario'

SELECT * FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`='7163'

SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario`=0) AND (`id_bollettario_proprietario`='7163')

SHOW FULL COLUMNS FROM `db2_verbaleveicolo`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo'

SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`='7163'

SHOW FULL COLUMNS FROM `db2_notifica`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_notifica' AND kcu.table_name = 'db2_notifica'

SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='7163'

SELECT * FROM `ruolo_sanzioni`

SHOW FULL COLUMNS FROM `ruolo_sanzioni`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'ruolo_sanzioni' AND kcu.table_name = 'ruolo_sanzioni'

SELECT * FROM `db1_persona` WHERE `id_persona`=2066

SHOW FULL COLUMNS FROM `db1_persona`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db1_persona' AND kcu.table_name = 'db1_persona'

SELECT * FROM `db0_comuni` WHERE `id_comune`=72032

SHOW FULL COLUMNS FROM `db0_comuni`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_comuni' AND kcu.table_name = 'db0_comuni'

SELECT * FROM `articoli_new` WHERE `id_articolo`='1178'

SHOW FULL COLUMNS FROM `articoli_new`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'articoli_new' AND kcu.table_name = 'articoli_new'

SELECT * FROM `istat2018` WHERE `id_articolo`=1178

SHOW FULL COLUMNS FROM `istat2018`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'istat2018' AND kcu.table_name = 'istat2018'

SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=2275

SHOW FULL COLUMNS FROM `db1_veicolo`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db1_veicolo' AND kcu.table_name = 'db1_veicolo'

SELECT EXISTS(SELECT * FROM `ruolo_sanzioni` WHERE `ruolo_sanzioni`.`Progressivo`=1)

INSERT INTO `ruolo_sanzioni` (`Progressivo`, `TipoVerbale`, `TipoTrasgr`, `TipoNotifica`, `Cronologico`, `NrVerbale`, `DataVerbale`, `Cognome`, `Nome`, `Indirizzo`, `Citta`, `Belfiore`, `Prov`, `Cap`, `DataNascita`, `CodiceFiscale`, `Articolo`, `Sanzione`, `Targa`, `Maggiorazione`, `Totale`, `ProgrMinuta`, `DataNotifica`, `NrNotifica`, `SpeseNotMessi`) VALUES (1, 'I', 'T', '', '2996/2018', '1605031/2018', '2018-11-04', 'GASSI', 'FRANCESCO', 'VIA VENEZIA 9', 'Noicattaro', 'F923', 'BA', '70016', '1971-09-01', 'GSSFNC71P01B716X', 'Art. 193 comma 2', 1698, 'CM852BA', 17489.4, 0, 1, '2018-11-04 09:10:36', 'NO', 0)

SELECT * FROM `db2_proprietario` WHERE (`tipo_proprietario`=2) AND (`id_bollettario_proprietario`='7163')

SELECT * FROM `db1_persona` WHERE `id_persona`=2067

SELECT * FROM `ruolo_sanzioni` WHERE (`CodiceFiscale`='MSTSMN68T68H501Z') AND (`Nome`='SIMONA ') AND (`Cronologico`='2996/2018')

SELECT * FROM `ruolo_sanzioni`

SELECT * FROM `db0_comuni` WHERE `id_comune`=72032

SELECT EXISTS(SELECT * FROM `ruolo_sanzioni` WHERE `ruolo_sanzioni`.`Progressivo`=2)

INSERT INTO `ruolo_sanzioni` (`Progressivo`, `Cronologico`, `NrVerbale`, `TipoVerbale`, `Cognome`, `Nome`, `TipoTrasgr`, `Indirizzo`, `Citta`, `Belfiore`, `Prov`, `Cap`, `DataNascita`, `CodiceFiscale`, `DataVerbale`, `Targa`, `TipoNotifica`, `Articolo`, `Sanzione`, `SpeseNotifica`, `SpeseStampa`, `DataNotifica`, `NrNotifica`, `SpeseNotMessi`, `Maggiorazione`, `Totale`, `ProgrMinuta`) VALUES (2, '2996/2018', '1605031/2018', 'I', 'MASTROVITI', 'SIMONA ', 'P', 'VIA VENEZIA 9', 'Noicattaro', 'F923', 'BA', '70016', '1968-12-28', 'MSTSMN68T68H501Z', '2018-11-04', 'CM852BA', '', 'Art. 193 comma 2', 1698, 0, 0, '2018-12-24 10:20:52', '787690198778', NULL, 849, 0, 1)

DELETE FROM `n0`

SHOW FULL COLUMNS FROM `n0`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n0' AND kcu.table_name = 'n0'

INSERT INTO `n0` (`TipoRecord`, `CodEnte`, `DataInvio`) VALUES ('N0', '12144', '20250628')

DELETE FROM `n1`

SHOW FULL COLUMNS FROM `n1`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n1' AND kcu.table_name = 'n1'

INSERT INTO `n1` (`TipoRecord`, `Comune`, `ProgrMinuta`, `TipoRuolo`, `NrRuolo`, `NrRate`, `TipoRuolo2`, `CodSede`, `TipoCompenso`) VALUES ('N1', '072072', '01', '1', '0000', '01', '1', '0000', '0')

SELECT * FROM `ruolo_sanzioni`

SELECT * FROM `n2`

SHOW FULL COLUMNS FROM `n2`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n2' AND kcu.table_name = 'n2'

INSERT INTO `n2` (`TipoRecord`, `Comune`, `ProgrMinuta`, `CodPartita`, `CodiceFiscale`, `NrContribuente`, `CodIndirizzo`, `Indirizzo`, `Civico`, `Lettera`, `Km`, `Cap`, `Belfiore`, `Localita`, `CodIndirizzoRec`, `IndirizzoRec`, `CivicoRec`, `LetteraRec`, `KmRec`, `CapRec`, `BelfioreRec`, `LocalitaRec`, `NaturaGiur`, `CognomeDenominazione`, `Nome`, `Sesso`, `DataNascita`, `BelfioreNasc`, `Filler`, `TipoDebitore`, `Filler2`) VALUES ('N2', '072072', '01', '1 ', 'GSSFNC71P01B716X', '0000000000', '000000', 'VIA VENEZIA 9 ', '00000', ' ', '000000', '70016', 'F923', 'Noicattaro ', '000000', ' ', '00000', ' ', '000000', '00000', ' ', ' ', '1', 'GASSI ', 'FRANCESCO ', 'M', '01091971', 'B716', ' ', 'N', ' ')

SHOW FULL COLUMNS FROM `n4`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n4' AND kcu.table_name = 'n4'

INSERT INTO `n4` (`TipoRecord`, `Comune`, `ProgrMinuta`, `CodPartita`, `Anno`, `CodEntrata`, `Imponibile`, `Tributo`, `NrSemestri`, `DataInteressi`, `CodReparto`, `InfoTributo`, `InfoRuolo`, `Filler`, `Indicatore`, `Categoria`) VALUES ('N4', '072072', '01', '1 ', '2018', '5449', '0000000000000', '0000000169800', '00', '00000000', ' ', 'VER.1605031/2018 04/11/2018 NOT.IL 04/11/2018 TG. CM852BA Art. 193 comma 2 ', 'SVE1605031/201804112018CM852BA ', ' ', ' ', ' ')

INSERT INTO `n4` (`TipoRecord`, `Comune`, `ProgrMinuta`, `CodPartita`, `Anno`, `CodEntrata`, `Imponibile`, `Tributo`, `NrSemestri`, `DataInteressi`, `CodReparto`, `InfoTributo`, `InfoRuolo`, `Filler`, `Indicatore`, `Categoria`) VALUES ('N4', '072072', '01', '1 ', '2018', '5450', '0000000000000', '0000001748940', '00', '00000000', ' ', 'VER.1605031/2018 04/11/2018 NOT.IL 04/11/2018 TG. CM852BA Art. 193 comma 2 ', 'SVE1605031/201804112018CM852BA ', ' ', ' ', ' ')

SELECT * FROM `n2`

SELECT * FROM `ruolo_sanzioni` WHERE (`NrVerbale`='1605031/2018') AND (`TipoTrasgr`='T')

SHOW FULL COLUMNS FROM `n3`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n3' AND kcu.table_name = 'n3'

INSERT INTO `n3` (`TipoRecord`, `Comune`, `ProgrMinuta`, `CodPartita`, `CodiceFiscale`, `CodIndirizzo`, `Indirizzo`, `Civico`, `Lettera`, `Km`, `Cap`, `Belfiore`, `Localita`, `CodIndirizzoRec`, `IndirizzoRec`, `CivicoRec`, `LetteraRec`, `KmRec`, `CapRec`, `BelfioreRec`, `LocalitaRec`, `NaturaGiur`, `CognomeDenominazione`, `Nome`, `Sesso`, `DataNascita`, `BelfioreNasc`, `Filler`) VALUES ('N3', '072072', '01', '1 ', 'MSTSMN68T68H501Z', '000000', 'VIA VENEZIA 9 ', '00000', ' ', '000000', '70016', 'F923', 'Noicattaro ', '000000', ' ', '00000', ' ', '000000', '00000', ' ', ' ', '1', 'MASTROVITI ', 'SIMONA ', 'F', '28121968', 'H501', ' ')

SELECT * FROM `n2`

SELECT * FROM `n3`

SELECT * FROM `n4`

SHOW FULL COLUMNS FROM `n5`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n5' AND kcu.table_name = 'n5'

INSERT INTO `n5` (`TipoRecord`, `Comune`, `ProgrMinuta`, `TotRecord`, `TotN2`, `TotN3`, `TotN4`, `TotTributo`) VALUES ('N5', '072072', '01', '0000006', '0000001', '0000001', '0000002', '000000001918740')

SELECT * FROM `n2`

SELECT * FROM `n3`

SELECT * FROM `n4`

SHOW FULL COLUMNS FROM `n9`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'n9' AND kcu.table_name = 'n9'

INSERT INTO `n9` (`TipoRecord`, `CodEnte`, `TotRecord`, `TotN1`, `TotN2`, `TotN3`, `TotN4`, `TotN5`) VALUES ('N9', '12144', '0000007', '0000001', '0000001', '0000001', '0000002', '0000001')

SELECT * FROM `n0`

SELECT * FROM `n1`

SELECT * FROM `n2`

SELECT * FROM `n5`

SELECT * FROM `n9`

SELECT * FROM `n3` WHERE `CodPartita`='1 '

SELECT * FROM `n4` WHERE `CodPartita`='1 '