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`='13670'

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`='13670'

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

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`='13670'

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

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`='13670'

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`='13670'

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`=11366

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`=110003

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`='157'

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`=157

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`=4116

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, 'D', 'T', '', '3194/2018', '1602525/2018', '2018-04-18', 'VENTURA', 'VINCENZO', 'VIA MONTEBELLO 7', 'Bisceglie', 'A883', 'BT', '76011', '1964-09-22', 'VNTVCN64P22C983N', 'Art. 80 c. 14', 680, 'BA390ML', 7004, 0, 1, '2018-04-23 11:55:49', '76745125852-0', 0)

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

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

SELECT * FROM `ruolo_sanzioni` WHERE (`CodiceFiscale`='MNANNT71B55C983C') AND (`Nome`='ANTONIETTA') AND (`Cronologico`='3194/2018')

SELECT * FROM `ruolo_sanzioni`

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

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, '3194/2018', '1602525/2018', 'D', 'MAINO', 'ANTONIETTA', 'P', 'VIA TRANI 65', 'Corato', 'C983', 'BA', '70033', '1971-02-15', 'MNANNT71B55C983C', '2018-04-18', 'BA390ML', '', 'Art. 80 c. 14', 680, 6.8, 8, '2018-04-23 11:55:49', '76745125852-0', NULL, 476, 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', '20250629')

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 ', 'VNTVCN64P22C983N', '0000000000', '000000', 'VIA MONTEBELLO 7 ', '00000', ' ', '000000', '76011', 'A883', 'Bisceglie ', '000000', ' ', '00000', ' ', '000000', '00000', ' ', ' ', '1', 'VENTURA ', 'VINCENZO ', 'M', '22091964', 'C983', ' ', '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', '0000000068000', '00', '00000000', ' ', 'VER.1602525/2018 18/04/2018 NOT.IL 23/04/2018 TG. BA390ML Art. 80 c. 14 ', 'SVE1602525/201818042018BA390ML ', ' ', ' ', ' ')

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', '0000000700400', '00', '00000000', ' ', 'VER.1602525/2018 18/04/2018 NOT.IL 23/04/2018 TG. BA390ML Art. 80 c. 14 ', 'SVE1602525/201818042018BA390ML ', ' ', ' ', ' ')

SELECT * FROM `n2`

SELECT * FROM `ruolo_sanzioni` WHERE (`NrVerbale`='1602525/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 ', 'MNANNT71B55C983C', '000000', 'VIA TRANI 65 ', '00000', ' ', '000000', '70033', 'C983', 'Corato ', '000000', ' ', '00000', ' ', '000000', '00000', ' ', ' ', '1', 'MAINO ', 'ANTONIETTA ', 'F', '15021971', 'C983', ' ')

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', '000000000768400')

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 '