Advanced Search

Return to Snippet

Revision: 63843
at June 12, 2013 07:12 by zitter
Updated Code 
CREATE TABLE IF NOT EXISTS g_lastnamelist(
id smallint not null auto_increment primary key,
lastname varchar(30) not null
);

INSERT INTO g_lastnamelist (lastname) VALUES('ROSSI');
INSERT INTO g_lastnamelist (lastname) VALUES('RUSSO');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRARI');
INSERT INTO g_lastnamelist (lastname) VALUES('ESPOSITO');
INSERT INTO g_lastnamelist (lastname) VALUES('BIANCHI');
INSERT INTO g_lastnamelist (lastname) VALUES('ROMANO');
INSERT INTO g_lastnamelist (lastname) VALUES('COLOMBO');
INSERT INTO g_lastnamelist (lastname) VALUES('RICCI');
INSERT INTO g_lastnamelist (lastname) VALUES('MARINO');
INSERT INTO g_lastnamelist (lastname) VALUES('GRECO');
INSERT INTO g_lastnamelist (lastname) VALUES('BRUNO');
INSERT INTO g_lastnamelist (lastname) VALUES('GALLO');
INSERT INTO g_lastnamelist (lastname) VALUES('CONTI');
INSERT INTO g_lastnamelist (lastname) VALUES('DELUCA');
INSERT INTO g_lastnamelist (lastname) VALUES('MANCINI');
INSERT INTO g_lastnamelist (lastname) VALUES('COSTA');
INSERT INTO g_lastnamelist (lastname) VALUES('GIORDANO');
INSERT INTO g_lastnamelist (lastname) VALUES('RIZZO');
INSERT INTO g_lastnamelist (lastname) VALUES('LOMBARDI');
INSERT INTO g_lastnamelist (lastname) VALUES('MORETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('BARBIERI');
INSERT INTO g_lastnamelist (lastname) VALUES('FONTANA');
INSERT INTO g_lastnamelist (lastname) VALUES('SANTORO');
INSERT INTO g_lastnamelist (lastname) VALUES('MARIANI');
INSERT INTO g_lastnamelist (lastname) VALUES('RINALDI');
INSERT INTO g_lastnamelist (lastname) VALUES('CARUSO');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRARA');
INSERT INTO g_lastnamelist (lastname) VALUES('GALLI');
INSERT INTO g_lastnamelist (lastname) VALUES('MARTINI');
INSERT INTO g_lastnamelist (lastname) VALUES('LEONE');
INSERT INTO g_lastnamelist (lastname) VALUES('LONGO');
INSERT INTO g_lastnamelist (lastname) VALUES('GENTILE');
INSERT INTO g_lastnamelist (lastname) VALUES('MARTINELLI');
INSERT INTO g_lastnamelist (lastname) VALUES('VITALE');
INSERT INTO g_lastnamelist (lastname) VALUES('LOMBARDO');
INSERT INTO g_lastnamelist (lastname) VALUES('SERRA');
INSERT INTO g_lastnamelist (lastname) VALUES('COPPOLA');
INSERT INTO g_lastnamelist (lastname) VALUES('DESANTIS');
INSERT INTO g_lastnamelist (lastname) VALUES('D\'ANGELO');
INSERT INTO g_lastnamelist (lastname) VALUES('MARCHETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('PARISI');
INSERT INTO g_lastnamelist (lastname) VALUES('VILLA');
INSERT INTO g_lastnamelist (lastname) VALUES('CONTE');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRARO');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRI');
INSERT INTO g_lastnamelist (lastname) VALUES('FABBRI');
INSERT INTO g_lastnamelist (lastname) VALUES('BIANCO');
INSERT INTO g_lastnamelist (lastname) VALUES('MARINI');
INSERT INTO g_lastnamelist (lastname) VALUES('GRASSO');
INSERT INTO g_lastnamelist (lastname) VALUES('VALENTINI');
INSERT INTO g_lastnamelist (lastname) VALUES('MESSINA');
INSERT INTO g_lastnamelist (lastname) VALUES('SALA');
INSERT INTO g_lastnamelist (lastname) VALUES('DEANGELIS');
INSERT INTO g_lastnamelist (lastname) VALUES('GATTI');
INSERT INTO g_lastnamelist (lastname) VALUES('PELLEGRINI');
INSERT INTO g_lastnamelist (lastname) VALUES('PALUMBO');
INSERT INTO g_lastnamelist (lastname) VALUES('SANNA');
INSERT INTO g_lastnamelist (lastname) VALUES('FARINA');
INSERT INTO g_lastnamelist (lastname) VALUES('RIZZI');
INSERT INTO g_lastnamelist (lastname) VALUES('MONTI');
INSERT INTO g_lastnamelist (lastname) VALUES('CATTANEO');
INSERT INTO g_lastnamelist (lastname) VALUES('MORELLI');
INSERT INTO g_lastnamelist (lastname) VALUES('AMATO');
INSERT INTO g_lastnamelist (lastname) VALUES('SILVESTRI');
INSERT INTO g_lastnamelist (lastname) VALUES('MAZZA');
INSERT INTO g_lastnamelist (lastname) VALUES('TESTA');
INSERT INTO g_lastnamelist (lastname) VALUES('GRASSI');
INSERT INTO g_lastnamelist (lastname) VALUES('PELLEGRINO');
INSERT INTO g_lastnamelist (lastname) VALUES('CARBONE');
INSERT INTO g_lastnamelist (lastname) VALUES('GIULIANI');
INSERT INTO g_lastnamelist (lastname) VALUES('BENEDETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('BARONE');
INSERT INTO g_lastnamelist (lastname) VALUES('ROSSETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('CAPUTO');
INSERT INTO g_lastnamelist (lastname) VALUES('MONTANARI');
INSERT INTO g_lastnamelist (lastname) VALUES('GUERRA');
INSERT INTO g_lastnamelist (lastname) VALUES('PALMIERI');
INSERT INTO g_lastnamelist (lastname) VALUES('BERNARDI');
INSERT INTO g_lastnamelist (lastname) VALUES('MARTINO');
INSERT INTO g_lastnamelist (lastname) VALUES('FIORE');
INSERT INTO g_lastnamelist (lastname) VALUES('DEROSA');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('BELLINI');
INSERT INTO g_lastnamelist (lastname) VALUES('BASILE');
INSERT INTO g_lastnamelist (lastname) VALUES('RIVA');
INSERT INTO g_lastnamelist (lastname) VALUES('DONATI');
INSERT INTO g_lastnamelist (lastname) VALUES('PIRAS');
INSERT INTO g_lastnamelist (lastname) VALUES('VITALI');
INSERT INTO g_lastnamelist (lastname) VALUES('BATTAGLIA');
INSERT INTO g_lastnamelist (lastname) VALUES('SARTORI');
INSERT INTO g_lastnamelist (lastname) VALUES('NERI');
INSERT INTO g_lastnamelist (lastname) VALUES('COSTANTINI');
INSERT INTO g_lastnamelist (lastname) VALUES('MILANI');
INSERT INTO g_lastnamelist (lastname) VALUES('PAGANO');
INSERT INTO g_lastnamelist (lastname) VALUES('RUGGIERO');
INSERT INTO g_lastnamelist (lastname) VALUES('SORRENTINO');
INSERT INTO g_lastnamelist (lastname) VALUES('D\'AMICO');
INSERT INTO g_lastnamelist (lastname) VALUES('ORLANDO');
INSERT INTO g_lastnamelist (lastname) VALUES('DAMICO');
INSERT INTO g_lastnamelist (lastname) VALUES('NEGRI');

Revision: 63842
at June 12, 2013 07:11 by zitter
Initial Code 
CREATE TABLE IF NOT EXISTS g_lastnamelist(
id smallint not null auto_increment primary key,
lastname varchar(30) not null,
);

INSERT INTO g_lastnamelist (lastname) VALUES('ROSSI');
INSERT INTO g_lastnamelist (lastname) VALUES('RUSSO');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRARI');
INSERT INTO g_lastnamelist (lastname) VALUES('ESPOSITO');
INSERT INTO g_lastnamelist (lastname) VALUES('BIANCHI');
INSERT INTO g_lastnamelist (lastname) VALUES('ROMANO');
INSERT INTO g_lastnamelist (lastname) VALUES('COLOMBO');
INSERT INTO g_lastnamelist (lastname) VALUES('RICCI');
INSERT INTO g_lastnamelist (lastname) VALUES('MARINO');
INSERT INTO g_lastnamelist (lastname) VALUES('GRECO');
INSERT INTO g_lastnamelist (lastname) VALUES('BRUNO');
INSERT INTO g_lastnamelist (lastname) VALUES('GALLO');
INSERT INTO g_lastnamelist (lastname) VALUES('CONTI');
INSERT INTO g_lastnamelist (lastname) VALUES('DELUCA');
INSERT INTO g_lastnamelist (lastname) VALUES('MANCINI');
INSERT INTO g_lastnamelist (lastname) VALUES('COSTA');
INSERT INTO g_lastnamelist (lastname) VALUES('GIORDANO');
INSERT INTO g_lastnamelist (lastname) VALUES('RIZZO');
INSERT INTO g_lastnamelist (lastname) VALUES('LOMBARDI');
INSERT INTO g_lastnamelist (lastname) VALUES('MORETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('BARBIERI');
INSERT INTO g_lastnamelist (lastname) VALUES('FONTANA');
INSERT INTO g_lastnamelist (lastname) VALUES('SANTORO');
INSERT INTO g_lastnamelist (lastname) VALUES('MARIANI');
INSERT INTO g_lastnamelist (lastname) VALUES('RINALDI');
INSERT INTO g_lastnamelist (lastname) VALUES('CARUSO');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRARA');
INSERT INTO g_lastnamelist (lastname) VALUES('GALLI');
INSERT INTO g_lastnamelist (lastname) VALUES('MARTINI');
INSERT INTO g_lastnamelist (lastname) VALUES('LEONE');
INSERT INTO g_lastnamelist (lastname) VALUES('LONGO');
INSERT INTO g_lastnamelist (lastname) VALUES('GENTILE');
INSERT INTO g_lastnamelist (lastname) VALUES('MARTINELLI');
INSERT INTO g_lastnamelist (lastname) VALUES('VITALE');
INSERT INTO g_lastnamelist (lastname) VALUES('LOMBARDO');
INSERT INTO g_lastnamelist (lastname) VALUES('SERRA');
INSERT INTO g_lastnamelist (lastname) VALUES('COPPOLA');
INSERT INTO g_lastnamelist (lastname) VALUES('DESANTIS');
INSERT INTO g_lastnamelist (lastname) VALUES('D\'ANGELO');
INSERT INTO g_lastnamelist (lastname) VALUES('MARCHETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('PARISI');
INSERT INTO g_lastnamelist (lastname) VALUES('VILLA');
INSERT INTO g_lastnamelist (lastname) VALUES('CONTE');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRARO');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRI');
INSERT INTO g_lastnamelist (lastname) VALUES('FABBRI');
INSERT INTO g_lastnamelist (lastname) VALUES('BIANCO');
INSERT INTO g_lastnamelist (lastname) VALUES('MARINI');
INSERT INTO g_lastnamelist (lastname) VALUES('GRASSO');
INSERT INTO g_lastnamelist (lastname) VALUES('VALENTINI');
INSERT INTO g_lastnamelist (lastname) VALUES('MESSINA');
INSERT INTO g_lastnamelist (lastname) VALUES('SALA');
INSERT INTO g_lastnamelist (lastname) VALUES('DEANGELIS');
INSERT INTO g_lastnamelist (lastname) VALUES('GATTI');
INSERT INTO g_lastnamelist (lastname) VALUES('PELLEGRINI');
INSERT INTO g_lastnamelist (lastname) VALUES('PALUMBO');
INSERT INTO g_lastnamelist (lastname) VALUES('SANNA');
INSERT INTO g_lastnamelist (lastname) VALUES('FARINA');
INSERT INTO g_lastnamelist (lastname) VALUES('RIZZI');
INSERT INTO g_lastnamelist (lastname) VALUES('MONTI');
INSERT INTO g_lastnamelist (lastname) VALUES('CATTANEO');
INSERT INTO g_lastnamelist (lastname) VALUES('MORELLI');
INSERT INTO g_lastnamelist (lastname) VALUES('AMATO');
INSERT INTO g_lastnamelist (lastname) VALUES('SILVESTRI');
INSERT INTO g_lastnamelist (lastname) VALUES('MAZZA');
INSERT INTO g_lastnamelist (lastname) VALUES('TESTA');
INSERT INTO g_lastnamelist (lastname) VALUES('GRASSI');
INSERT INTO g_lastnamelist (lastname) VALUES('PELLEGRINO');
INSERT INTO g_lastnamelist (lastname) VALUES('CARBONE');
INSERT INTO g_lastnamelist (lastname) VALUES('GIULIANI');
INSERT INTO g_lastnamelist (lastname) VALUES('BENEDETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('BARONE');
INSERT INTO g_lastnamelist (lastname) VALUES('ROSSETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('CAPUTO');
INSERT INTO g_lastnamelist (lastname) VALUES('MONTANARI');
INSERT INTO g_lastnamelist (lastname) VALUES('GUERRA');
INSERT INTO g_lastnamelist (lastname) VALUES('PALMIERI');
INSERT INTO g_lastnamelist (lastname) VALUES('BERNARDI');
INSERT INTO g_lastnamelist (lastname) VALUES('MARTINO');
INSERT INTO g_lastnamelist (lastname) VALUES('FIORE');
INSERT INTO g_lastnamelist (lastname) VALUES('DEROSA');
INSERT INTO g_lastnamelist (lastname) VALUES('FERRETTI');
INSERT INTO g_lastnamelist (lastname) VALUES('BELLINI');
INSERT INTO g_lastnamelist (lastname) VALUES('BASILE');
INSERT INTO g_lastnamelist (lastname) VALUES('RIVA');
INSERT INTO g_lastnamelist (lastname) VALUES('DONATI');
INSERT INTO g_lastnamelist (lastname) VALUES('PIRAS');
INSERT INTO g_lastnamelist (lastname) VALUES('VITALI');
INSERT INTO g_lastnamelist (lastname) VALUES('BATTAGLIA');
INSERT INTO g_lastnamelist (lastname) VALUES('SARTORI');
INSERT INTO g_lastnamelist (lastname) VALUES('NERI');
INSERT INTO g_lastnamelist (lastname) VALUES('COSTANTINI');
INSERT INTO g_lastnamelist (lastname) VALUES('MILANI');
INSERT INTO g_lastnamelist (lastname) VALUES('PAGANO');
INSERT INTO g_lastnamelist (lastname) VALUES('RUGGIERO');
INSERT INTO g_lastnamelist (lastname) VALUES('SORRENTINO');
INSERT INTO g_lastnamelist (lastname) VALUES('D\'AMICO');
INSERT INTO g_lastnamelist (lastname) VALUES('ORLANDO');
INSERT INTO g_lastnamelist (lastname) VALUES('DAMICO');
INSERT INTO g_lastnamelist (lastname) VALUES('NEGRI');
Initial URL 









Initial Description





lista cognomi italiani









Initial Title





Cognomi italiani









Initial Tags














Initial Language





SQL