Posted By

zitter on 06/12/13

Tagged

Versions (?)

Last Edited at 06/12/13 06:52am

Statistics

Viewed 115 times

Favorited by 0 user(s)

Related snippets

SQL to list Italian names

/ Published in: SQL

SQL to list and generate common italian names

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

CREATE TABLE IF NOT EXISTS g_namelist(
id SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
sex CHAR(1) DEFAULT 'M'
);
INSERT INTO g_namelist (name,sex) VALUES('Andrea','M');
INSERT INTO g_namelist (name,sex) VALUES('Luca','M');
INSERT INTO g_namelist (name,sex) VALUES('Marco','M');
INSERT INTO g_namelist (name,sex) VALUES('Francesco','M');
INSERT INTO g_namelist (name,sex) VALUES('Matteo','M');
INSERT INTO g_namelist (name,sex) VALUES('Alessandro','M');
INSERT INTO g_namelist (name,sex) VALUES('Davide','M');
INSERT INTO g_namelist (name,sex) VALUES('Simone','M');
INSERT INTO g_namelist (name,sex) VALUES('Federico','M');
INSERT INTO g_namelist (name,sex) VALUES('Lorenzo','M');
INSERT INTO g_namelist (name,sex) VALUES('Mattia','M');
INSERT INTO g_namelist (name,sex) VALUES('Stefano','M');
INSERT INTO g_namelist (name,sex) VALUES('Giuseppe','M');
INSERT INTO g_namelist (name,sex) VALUES('Riccardo','M');
INSERT INTO g_namelist (name,sex) VALUES('Daniele','M');
INSERT INTO g_namelist (name,sex) VALUES('Michele','M');
INSERT INTO g_namelist (name,sex) VALUES('Alessio','M');
INSERT INTO g_namelist (name,sex) VALUES('Antonio','M');
INSERT INTO g_namelist (name,sex) VALUES('Giovanni','M');
INSERT INTO g_namelist (name,sex) VALUES('Nicola','M');
INSERT INTO g_namelist (name,sex) VALUES('Gabriele','M');
INSERT INTO g_namelist (name,sex) VALUES('Fabio','M');
INSERT INTO g_namelist (name,sex) VALUES('Alberto','M');
INSERT INTO g_namelist (name,sex) VALUES('Giacomo','M');
INSERT INTO g_namelist (name,sex) VALUES('Giulio','M');
INSERT INTO g_namelist (name,sex) VALUES('Filippo','M');
INSERT INTO g_namelist (name,sex) VALUES('Gianluca','M');
INSERT INTO g_namelist (name,sex) VALUES('Paolo','M');
INSERT INTO g_namelist (name,sex) VALUES('Roberto','M');
INSERT INTO g_namelist (name,sex) VALUES('Salvatore','M');
INSERT INTO g_namelist (name,sex) VALUES('Emanuele','M');
INSERT INTO g_namelist (name,sex) VALUES('Edoardo','M');
INSERT INTO g_namelist (name,sex) VALUES('Enrico','M');
INSERT INTO g_namelist (name,sex) VALUES('Vincenzo','M');
INSERT INTO g_namelist (name,sex) VALUES('NicolÃ²','M');
INSERT INTO g_namelist (name,sex) VALUES('Leonardo','M');
INSERT INTO g_namelist (name,sex) VALUES('Jacopo','M');
INSERT INTO g_namelist (name,sex) VALUES('Manuel','M');
INSERT INTO g_namelist (name,sex) VALUES('Mirko','M');
INSERT INTO g_namelist (name,sex) VALUES('Tommaso','M');
INSERT INTO g_namelist (name,sex) VALUES('Pietro','M');
INSERT INTO g_namelist (name,sex) VALUES('Luigi','M');
INSERT INTO g_namelist (name,sex) VALUES('Giorgio','M');
INSERT INTO g_namelist (name,sex) VALUES('Angelo','M');
INSERT INTO g_namelist (name,sex) VALUES('Dario','M');
INSERT INTO g_namelist (name,sex) VALUES('Valerio','M');
INSERT INTO g_namelist (name,sex) VALUES('Domenico','M');
INSERT INTO g_namelist (name,sex) VALUES('Claudio','M');
INSERT INTO g_namelist (name,sex) VALUES('Alex','M');
INSERT INTO g_namelist (name,sex) VALUES('Beatrice','F');
INSERT INTO g_namelist (name,sex) VALUES('Valeria','F');
INSERT INTO g_namelist (name,sex) VALUES('Michela','F');
INSERT INTO g_namelist (name,sex) VALUES('Serena','F');
INSERT INTO g_namelist (name,sex) VALUES('Camilla','F');
INSERT INTO g_namelist (name,sex) VALUES('Irene','F');
INSERT INTO g_namelist (name,sex) VALUES('Cristina','F');
INSERT INTO g_namelist (name,sex) VALUES('Simona','F');
INSERT INTO g_namelist (name,sex) VALUES('Maria','F');
INSERT INTO g_namelist (name,sex) VALUES('Noemi','F');
INSERT INTO g_namelist (name,sex) VALUES('Stefania','F');
INSERT INTO g_namelist (name,sex) VALUES('Erika','F');
INSERT INTO g_namelist (name,sex) VALUES('Sofia','F');
INSERT INTO g_namelist (name,sex) VALUES('Lucia','F');
INSERT INTO g_namelist (name,sex) VALUES('Vanessa','F');
INSERT INTO g_namelist (name,sex) VALUES('Greta','F');
INSERT INTO g_namelist (name,sex) VALUES('Debora','F');
INSERT INTO g_namelist (name,sex) VALUES('Nicole','F');
INSERT INTO g_namelist (name,sex) VALUES('Angela','F');
INSERT INTO g_namelist (name,sex) VALUES('Paola','F');
INSERT INTO g_namelist (name,sex) VALUES('Caterina','F');
INSERT INTO g_namelist (name,sex) VALUES('Monica','F');
INSERT INTO g_namelist (name,sex) VALUES('Erica','F');
INSERT INTO g_namelist (name,sex) VALUES('Lisa','F');
INSERT INTO g_namelist (name,sex) VALUES('Gaia','F');

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.