Générateur de données
Cette page permet de générer automatiquement des informations concernant 100 personnes différentes dans une table.
La table contient 4 attributs :
- id : clé primaire de type INT
- nom : chaîne de caractère de type TEXT
- prenom : chaîne de caractère de type TEXT
- sexe : chaîne de caractère de type TEXT valant soit 'M' soit 'F'
Voici les données des 100 personnes clairement présentées sous forme de tableau :
| id | nom | prenom | sexe |
| 1 | DAUXIAN | Elsa | F |
| 2 | SWERTVAEGER | Didier | M |
| 3 | BELUAU | Timothé | M |
| 4 | MARTORA | Amélie | F |
| 5 | DJELOUDANE | Anthony | M |
| 6 | RIQUIER | Georges | M |
| 7 | BERNARD | Jules | M |
| 8 | LANOE | Romuald | M |
| 9 | DABON | Noémie | F |
| 10 | RABAHI | Frédéric | M |
| 11 | AMAND | Julie | F |
| 12 | BOISSEAU | Liane | F |
| 13 | LUYCKX | Rose | F |
| 14 | DORON | Gisèle | F |
| 15 | LEHOUX | Sheila | F |
| 16 | GALLOIS | Bastien | M |
| 17 | GUERRAOUI | Renée | F |
| 18 | VASSEMON | Ludivine | F |
| 19 | THOMAS | Charles | M |
| 20 | KERVADEC | Robin | M |
| 21 | PARIS | Rémi | M |
| 22 | CHAMPENOIS | Laurent | M |
| 23 | HERVIEU | Arlette | F |
| 24 | BLANDET | Sabrina | F |
| 25 | EUSTACHE | Martine | F |
| 26 | LEGRAND | Sylvain | M |
| 27 | DURIEU | Lucy | F |
| 28 | HUE | Pierrette | F |
| 29 | SEHIER | Abraham | M |
| 30 | MADELAINE | Régine | F |
| 31 | DELOVINA | Muriel | F |
| 32 | DELAROCHE | Marie | F |
| 33 | BOYON | Stella | F |
| 34 | JALON | Lésia | F |
| 35 | RAMPNOUX | Grégory | M |
| 36 | CHAVANT | Gilles | M |
| 37 | COMES | Enzo | M |
| 38 | ANTUNES | Marguerite | F |
| 39 | MARIE | Jeanne | F |
| 40 | LE BOUCHER | Mathilde | F |
| 41 | GUITON | Enora | F |
| 42 | BONE | Émile | M |
| 43 | DUPUIS | Syndie | F |
| 44 | BAZOUD | Francis | M |
| 45 | NIELLEZ | Mathieu | M |
| 46 | FERREIRA | Mélanie | F |
| 47 | LESOIF | Raoul | M |
| 48 | STILO | Serge | M |
| 49 | HAMARD | Brice | M |
| 50 | BONNET | Jean | M |
| 51 | HOUEL | Henriette | F |
| 52 | BORNE | Éveline | F |
| 53 | LEROUX | Hercule | M |
| 54 | LEDUFAUD | Balthazar | M |
| 55 | SARRAZIN | Gabriel | M |
| 56 | LETHIMONNIER | Alphonse | M |
| 57 | ROULLAND | Benoit | M |
| 58 | MANCEL | Léna | F |
| 59 | LECHAUVE | Amandine | F |
| 60 | DOUCET | Gaspard | M |
| 61 | ELKABBADJ | Gérard | M |
| 62 | HEDDI | Bénédicte | F |
| 63 | DEMMER | Nina | F |
| 64 | BECQUET | Nadine | F |
| 65 | MATHIEU | Florian | M |
| 66 | CAILLIOT | Timothée | M |
| 67 | HEON | Florence | F |
| 68 | BORREL | Alexandre | M |
| 69 | HOSNI | Émilie | F |
| 70 | COUESBOT | Fabienne | F |
| 71 | LERICHE | Lucette | F |
| 72 | COLOMB | Daniel | M |
| 73 | LAZARRE | Marjolaine | F |
| 74 | LABOULAIS | Lyne | F |
| 75 | SCHINK | David | M |
| 76 | LEMENOREL | Anémone | F |
| 77 | ADIBO | Baptiste | M |
| 78 | MARTEL | Thomas | M |
| 79 | LE BANNARD | Colette | F |
| 80 | TIENER | Corinne | F |
| 81 | COLAS | Nicolas | M |
| 82 | LECOMTE | Léonard | M |
| 83 | BONHOMME | Barbara | F |
| 84 | JANY | Maxence | M |
| 85 | DUPIN | Luc | M |
| 86 | DUREL | Cédric | M |
| 87 | BEUZELIN | Alexendra | F |
| 88 | FLEURY | Andrée | F |
| 89 | TANQUE | Anna | F |
| 90 | VAN CAUTER | Bruno | M |
| 91 | HUET | Brigitte | F |
| 92 | MICHEL | Frédérique | F |
| 93 | BELLAMY | Véronique | F |
| 94 | SALLAÏ | Antoine | M |
| 95 | MOREL | Gertrude | F |
| 96 | JOUVE | Blaise | M |
| 97 | LAURENCE | Olivia | F |
| 98 | POIRIER | Yvette | F |
| 99 | VALIN | Nolwenn | F |
| 100 | LAZZARI | Roland | M |
Voici les données de cette table au format CSV :
1,"DAUXIAN","Elsa","F"
2,"SWERTVAEGER","Didier","M"
3,"BELUAU","Timothé","M"
4,"MARTORA","Amélie","F"
5,"DJELOUDANE","Anthony","M"
6,"RIQUIER","Georges","M"
7,"BERNARD","Jules","M"
8,"LANOE","Romuald","M"
9,"DABON","Noémie","F"
10,"RABAHI","Frédéric","M"
11,"AMAND","Julie","F"
12,"BOISSEAU","Liane","F"
13,"LUYCKX","Rose","F"
14,"DORON","Gisèle","F"
15,"LEHOUX","Sheila","F"
16,"GALLOIS","Bastien","M"
17,"GUERRAOUI","Renée","F"
18,"VASSEMON","Ludivine","F"
19,"THOMAS","Charles","M"
20,"KERVADEC","Robin","M"
21,"PARIS","Rémi","M"
22,"CHAMPENOIS","Laurent","M"
23,"HERVIEU","Arlette","F"
24,"BLANDET","Sabrina","F"
25,"EUSTACHE","Martine","F"
26,"LEGRAND","Sylvain","M"
27,"DURIEU","Lucy","F"
28,"HUE","Pierrette","F"
29,"SEHIER","Abraham","M"
30,"MADELAINE","Régine","F"
31,"DELOVINA","Muriel","F"
32,"DELAROCHE","Marie","F"
33,"BOYON","Stella","F"
34,"JALON","Lésia","F"
35,"RAMPNOUX","Grégory","M"
36,"CHAVANT","Gilles","M"
37,"COMES","Enzo","M"
38,"ANTUNES","Marguerite","F"
39,"MARIE","Jeanne","F"
40,"LE BOUCHER","Mathilde","F"
41,"GUITON","Enora","F"
42,"BONE","Émile","M"
43,"DUPUIS","Syndie","F"
44,"BAZOUD","Francis","M"
45,"NIELLEZ","Mathieu","M"
46,"FERREIRA","Mélanie","F"
47,"LESOIF","Raoul","M"
48,"STILO","Serge","M"
49,"HAMARD","Brice","M"
50,"BONNET","Jean","M"
51,"HOUEL","Henriette","F"
52,"BORNE","Éveline","F"
53,"LEROUX","Hercule","M"
54,"LEDUFAUD","Balthazar","M"
55,"SARRAZIN","Gabriel","M"
56,"LETHIMONNIER","Alphonse","M"
57,"ROULLAND","Benoit","M"
58,"MANCEL","Léna","F"
59,"LECHAUVE","Amandine","F"
60,"DOUCET","Gaspard","M"
61,"ELKABBADJ","Gérard","M"
62,"HEDDI","Bénédicte","F"
63,"DEMMER","Nina","F"
64,"BECQUET","Nadine","F"
65,"MATHIEU","Florian","M"
66,"CAILLIOT","Timothée","M"
67,"HEON","Florence","F"
68,"BORREL","Alexandre","M"
69,"HOSNI","Émilie","F"
70,"COUESBOT","Fabienne","F"
71,"LERICHE","Lucette","F"
72,"COLOMB","Daniel","M"
73,"LAZARRE","Marjolaine","F"
74,"LABOULAIS","Lyne","F"
75,"SCHINK","David","M"
76,"LEMENOREL","Anémone","F"
77,"ADIBO","Baptiste","M"
78,"MARTEL","Thomas","M"
79,"LE BANNARD","Colette","F"
80,"TIENER","Corinne","F"
81,"COLAS","Nicolas","M"
82,"LECOMTE","Léonard","M"
83,"BONHOMME","Barbara","F"
84,"JANY","Maxence","M"
85,"DUPIN","Luc","M"
86,"DUREL","Cédric","M"
87,"BEUZELIN","Alexendra","F"
88,"FLEURY","Andrée","F"
89,"TANQUE","Anna","F"
90,"VAN CAUTER","Bruno","M"
91,"HUET","Brigitte","F"
92,"MICHEL","Frédérique","F"
93,"BELLAMY","Véronique","F"
94,"SALLAÏ","Antoine","M"
95,"MOREL","Gertrude","F"
96,"JOUVE","Blaise","M"
97,"LAURENCE","Olivia","F"
98,"POIRIER","Yvette","F"
99,"VALIN","Nolwenn","F"
100,"LAZZARI","Roland","M"
Et voici ces mêmes données au format SQL :
INSERT INTO personne (id, nom, prenom, sexe) VALUES (1,"DAUXIAN","Elsa","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (2,"SWERTVAEGER","Didier","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (3,"BELUAU","Timothé","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (4,"MARTORA","Amélie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (5,"DJELOUDANE","Anthony","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (6,"RIQUIER","Georges","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (7,"BERNARD","Jules","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (8,"LANOE","Romuald","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (9,"DABON","Noémie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (10,"RABAHI","Frédéric","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (11,"AMAND","Julie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (12,"BOISSEAU","Liane","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (13,"LUYCKX","Rose","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (14,"DORON","Gisèle","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (15,"LEHOUX","Sheila","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (16,"GALLOIS","Bastien","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (17,"GUERRAOUI","Renée","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (18,"VASSEMON","Ludivine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (19,"THOMAS","Charles","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (20,"KERVADEC","Robin","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (21,"PARIS","Rémi","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (22,"CHAMPENOIS","Laurent","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (23,"HERVIEU","Arlette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (24,"BLANDET","Sabrina","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (25,"EUSTACHE","Martine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (26,"LEGRAND","Sylvain","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (27,"DURIEU","Lucy","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (28,"HUE","Pierrette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (29,"SEHIER","Abraham","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (30,"MADELAINE","Régine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (31,"DELOVINA","Muriel","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (32,"DELAROCHE","Marie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (33,"BOYON","Stella","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (34,"JALON","Lésia","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (35,"RAMPNOUX","Grégory","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (36,"CHAVANT","Gilles","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (37,"COMES","Enzo","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (38,"ANTUNES","Marguerite","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (39,"MARIE","Jeanne","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (40,"LE BOUCHER","Mathilde","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (41,"GUITON","Enora","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (42,"BONE","Émile","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (43,"DUPUIS","Syndie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (44,"BAZOUD","Francis","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (45,"NIELLEZ","Mathieu","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (46,"FERREIRA","Mélanie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (47,"LESOIF","Raoul","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (48,"STILO","Serge","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (49,"HAMARD","Brice","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (50,"BONNET","Jean","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (51,"HOUEL","Henriette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (52,"BORNE","Éveline","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (53,"LEROUX","Hercule","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (54,"LEDUFAUD","Balthazar","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (55,"SARRAZIN","Gabriel","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (56,"LETHIMONNIER","Alphonse","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (57,"ROULLAND","Benoit","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (58,"MANCEL","Léna","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (59,"LECHAUVE","Amandine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (60,"DOUCET","Gaspard","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (61,"ELKABBADJ","Gérard","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (62,"HEDDI","Bénédicte","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (63,"DEMMER","Nina","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (64,"BECQUET","Nadine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (65,"MATHIEU","Florian","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (66,"CAILLIOT","Timothée","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (67,"HEON","Florence","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (68,"BORREL","Alexandre","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (69,"HOSNI","Émilie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (70,"COUESBOT","Fabienne","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (71,"LERICHE","Lucette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (72,"COLOMB","Daniel","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (73,"LAZARRE","Marjolaine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (74,"LABOULAIS","Lyne","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (75,"SCHINK","David","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (76,"LEMENOREL","Anémone","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (77,"ADIBO","Baptiste","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (78,"MARTEL","Thomas","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (79,"LE BANNARD","Colette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (80,"TIENER","Corinne","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (81,"COLAS","Nicolas","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (82,"LECOMTE","Léonard","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (83,"BONHOMME","Barbara","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (84,"JANY","Maxence","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (85,"DUPIN","Luc","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (86,"DUREL","Cédric","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (87,"BEUZELIN","Alexendra","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (88,"FLEURY","Andrée","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (89,"TANQUE","Anna","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (90,"VAN CAUTER","Bruno","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (91,"HUET","Brigitte","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (92,"MICHEL","Frédérique","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (93,"BELLAMY","Véronique","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (94,"SALLAÏ","Antoine","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (95,"MOREL","Gertrude","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (96,"JOUVE","Blaise","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (97,"LAURENCE","Olivia","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (98,"POIRIER","Yvette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (99,"VALIN","Nolwenn","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (100,"LAZZARI","Roland","M");
Les données se récupèrent ci-dessus par un simple copier/coller (en sélectionnant le nombre de lignes souhaité) puis doivent être enregistrées dans un fichier texte sous l'éditeur Notepad++ avant de les insérer dans SQLite ou de lire le fichier texte avec Python.
nsi.gecif.net
© Janvier 2026