Posted By

zitter on 06/12/13


Tagged


Versions (?)

SQL to list Italian names


 / Published in: SQL
 

SQL to list and generate common italian names

  1. CREATE TABLE IF NOT EXISTS g_namelist(
  2. id smallint NOT NULL AUTO_INCREMENT PRIMARY KEY,
  3. name varchar(30) NOT NULL,
  4. sex char(1) DEFAULT 'M'
  5. );
  6. INSERT INTO g_namelist (name,sex) VALUES('Andrea','M');
  7. INSERT INTO g_namelist (name,sex) VALUES('Luca','M');
  8. INSERT INTO g_namelist (name,sex) VALUES('Marco','M');
  9. INSERT INTO g_namelist (name,sex) VALUES('Francesco','M');
  10. INSERT INTO g_namelist (name,sex) VALUES('Matteo','M');
  11. INSERT INTO g_namelist (name,sex) VALUES('Alessandro','M');
  12. INSERT INTO g_namelist (name,sex) VALUES('Davide','M');
  13. INSERT INTO g_namelist (name,sex) VALUES('Simone','M');
  14. INSERT INTO g_namelist (name,sex) VALUES('Federico','M');
  15. INSERT INTO g_namelist (name,sex) VALUES('Lorenzo','M');
  16. INSERT INTO g_namelist (name,sex) VALUES('Mattia','M');
  17. INSERT INTO g_namelist (name,sex) VALUES('Stefano','M');
  18. INSERT INTO g_namelist (name,sex) VALUES('Giuseppe','M');
  19. INSERT INTO g_namelist (name,sex) VALUES('Riccardo','M');
  20. INSERT INTO g_namelist (name,sex) VALUES('Daniele','M');
  21. INSERT INTO g_namelist (name,sex) VALUES('Michele','M');
  22. INSERT INTO g_namelist (name,sex) VALUES('Alessio','M');
  23. INSERT INTO g_namelist (name,sex) VALUES('Antonio','M');
  24. INSERT INTO g_namelist (name,sex) VALUES('Giovanni','M');
  25. INSERT INTO g_namelist (name,sex) VALUES('Nicola','M');
  26. INSERT INTO g_namelist (name,sex) VALUES('Gabriele','M');
  27. INSERT INTO g_namelist (name,sex) VALUES('Fabio','M');
  28. INSERT INTO g_namelist (name,sex) VALUES('Alberto','M');
  29. INSERT INTO g_namelist (name,sex) VALUES('Giacomo','M');
  30. INSERT INTO g_namelist (name,sex) VALUES('Giulio','M');
  31. INSERT INTO g_namelist (name,sex) VALUES('Filippo','M');
  32. INSERT INTO g_namelist (name,sex) VALUES('Gianluca','M');
  33. INSERT INTO g_namelist (name,sex) VALUES('Paolo','M');
  34. INSERT INTO g_namelist (name,sex) VALUES('Roberto','M');
  35. INSERT INTO g_namelist (name,sex) VALUES('Salvatore','M');
  36. INSERT INTO g_namelist (name,sex) VALUES('Emanuele','M');
  37. INSERT INTO g_namelist (name,sex) VALUES('Edoardo','M');
  38. INSERT INTO g_namelist (name,sex) VALUES('Enrico','M');
  39. INSERT INTO g_namelist (name,sex) VALUES('Vincenzo','M');
  40. INSERT INTO g_namelist (name,sex) VALUES('Nicolò','M');
  41. INSERT INTO g_namelist (name,sex) VALUES('Leonardo','M');
  42. INSERT INTO g_namelist (name,sex) VALUES('Jacopo','M');
  43. INSERT INTO g_namelist (name,sex) VALUES('Manuel','M');
  44. INSERT INTO g_namelist (name,sex) VALUES('Mirko','M');
  45. INSERT INTO g_namelist (name,sex) VALUES('Tommaso','M');
  46. INSERT INTO g_namelist (name,sex) VALUES('Pietro','M');
  47. INSERT INTO g_namelist (name,sex) VALUES('Luigi','M');
  48. INSERT INTO g_namelist (name,sex) VALUES('Giorgio','M');
  49. INSERT INTO g_namelist (name,sex) VALUES('Angelo','M');
  50. INSERT INTO g_namelist (name,sex) VALUES('Dario','M');
  51. INSERT INTO g_namelist (name,sex) VALUES('Valerio','M');
  52. INSERT INTO g_namelist (name,sex) VALUES('Domenico','M');
  53. INSERT INTO g_namelist (name,sex) VALUES('Claudio','M');
  54. INSERT INTO g_namelist (name,sex) VALUES('Alex','M');
  55. INSERT INTO g_namelist (name,sex) VALUES('Beatrice','F');
  56. INSERT INTO g_namelist (name,sex) VALUES('Valeria','F');
  57. INSERT INTO g_namelist (name,sex) VALUES('Michela','F');
  58. INSERT INTO g_namelist (name,sex) VALUES('Serena','F');
  59. INSERT INTO g_namelist (name,sex) VALUES('Camilla','F');
  60. INSERT INTO g_namelist (name,sex) VALUES('Irene','F');
  61. INSERT INTO g_namelist (name,sex) VALUES('Cristina','F');
  62. INSERT INTO g_namelist (name,sex) VALUES('Simona','F');
  63. INSERT INTO g_namelist (name,sex) VALUES('Maria','F');
  64. INSERT INTO g_namelist (name,sex) VALUES('Noemi','F');
  65. INSERT INTO g_namelist (name,sex) VALUES('Stefania','F');
  66. INSERT INTO g_namelist (name,sex) VALUES('Erika','F');
  67. INSERT INTO g_namelist (name,sex) VALUES('Sofia','F');
  68. INSERT INTO g_namelist (name,sex) VALUES('Lucia','F');
  69. INSERT INTO g_namelist (name,sex) VALUES('Vanessa','F');
  70. INSERT INTO g_namelist (name,sex) VALUES('Greta','F');
  71. INSERT INTO g_namelist (name,sex) VALUES('Debora','F');
  72. INSERT INTO g_namelist (name,sex) VALUES('Nicole','F');
  73. INSERT INTO g_namelist (name,sex) VALUES('Angela','F');
  74. INSERT INTO g_namelist (name,sex) VALUES('Paola','F');
  75. INSERT INTO g_namelist (name,sex) VALUES('Caterina','F');
  76. INSERT INTO g_namelist (name,sex) VALUES('Monica','F');
  77. INSERT INTO g_namelist (name,sex) VALUES('Erica','F');
  78. INSERT INTO g_namelist (name,sex) VALUES('Lisa','F');
  79. INSERT INTO g_namelist (name,sex) VALUES('Gaia','F');

Report this snippet  

You need to login to post a comment.