Ajoutez à votre bd tous les jours de l'année ainsi que le saint correspondant

Soyez le premier à donner votre avis sur cette source.

Snippet vu 7 436 fois - Téléchargée 29 fois

Contenu du snippet

Ce code SQL permet d'ajouter tous les fetes en fonction du jours!
Je pense que ça peu etre interessant!

Source / Exemple :


CREATE TABLE fetedujour (jour int(2) NOT NULL, mois int(2) NOT NULL, saint varchar(50) NOT NULL, PRIMARY KEY (jour, mois) );

INSERT INTO fetedujour VALUES(  '1',  '1', 'Jour de l\'an');
INSERT INTO fetedujour VALUES(  '2',  '1', 'St Basile');
INSERT INTO fetedujour VALUES(  '3',  '1', 'Ste Geneviève');
INSERT INTO fetedujour VALUES(  '4',  '1', 'St Odilon');
INSERT INTO fetedujour VALUES(  '5',  '1', 'St Edouard');
INSERT INTO fetedujour VALUES(  '6',  '1', 'Ste Mélaine');
INSERT INTO fetedujour VALUES(  '7',  '1', 'St Raymond');
INSERT INTO fetedujour VALUES(  '8',  '1', 'St Lucien');
INSERT INTO fetedujour VALUES(  '9',  '1', 'Ste Alix');
INSERT INTO fetedujour VALUES( '10',  '1', 'St Guillaume');
INSERT INTO fetedujour VALUES( '11',  '1', 'St Paulin');
INSERT INTO fetedujour VALUES( '12',  '1', 'Ste Tatiana');
INSERT INTO fetedujour VALUES( '13',  '1', 'Ste Yvette');
INSERT INTO fetedujour VALUES( '14',  '1', 'Ste Nina');
INSERT INTO fetedujour VALUES( '15',  '1', 'St Rémi');
INSERT INTO fetedujour VALUES( '16',  '1', 'St Marcel');
INSERT INTO fetedujour VALUES( '17',  '1', 'Ste Roseline');
INSERT INTO fetedujour VALUES( '18',  '1', 'Ste Prisca');
INSERT INTO fetedujour VALUES( '19',  '1', 'St Marius');
INSERT INTO fetedujour VALUES( '20',  '1', 'St Sébastien');
INSERT INTO fetedujour VALUES( '21',  '1', 'Ste Agnès');
INSERT INTO fetedujour VALUES( '22',  '1', 'St Vincent');
INSERT INTO fetedujour VALUES( '23',  '1', 'St Barnard');
INSERT INTO fetedujour VALUES( '24',  '1', 'St François de Sales');
INSERT INTO fetedujour VALUES( '25',  '1', 'St Apollos');
INSERT INTO fetedujour VALUES( '26',  '1', 'Ste Paule');
INSERT INTO fetedujour VALUES( '27',  '1', 'Ste Angèle');
INSERT INTO fetedujour VALUES( '28',  '1', 'St Thomas d\'Aquin');
INSERT INTO fetedujour VALUES( '29',  '1', 'St Gildas');
INSERT INTO fetedujour VALUES( '30',  '1', 'Ste Martine');
INSERT INTO fetedujour VALUES( '31',  '1', 'Ste Marcelle');
INSERT INTO fetedujour VALUES(  '1',  '2', 'Ste Ella');
INSERT INTO fetedujour VALUES(  '2',  '2', 'St Théophane');
INSERT INTO fetedujour VALUES(  '3',  '2', 'St Blaise');
INSERT INTO fetedujour VALUES(  '4',  '2', 'Ste Véronique');
INSERT INTO fetedujour VALUES(  '5',  '2', 'Ste Agathe');
INSERT INTO fetedujour VALUES(  '6',  '2', 'St Gaston');
INSERT INTO fetedujour VALUES(  '7',  '2', 'Ste Eugénie');
INSERT INTO fetedujour VALUES(  '8',  '2', 'Ste Jacqueline');
INSERT INTO fetedujour VALUES(  '9',  '2', 'Ste Apolline');
INSERT INTO fetedujour VALUES( '10',  '2', 'St Arnaud');
INSERT INTO fetedujour VALUES( '11',  '2', 'ND de Lourdes');
INSERT INTO fetedujour VALUES( '12',  '2', 'St Félix');
INSERT INTO fetedujour VALUES( '13',  '2', 'Ste Béatrice');
INSERT INTO fetedujour VALUES( '14',  '2', 'St Valentin');
INSERT INTO fetedujour VALUES( '15',  '2', 'St Claude');
INSERT INTO fetedujour VALUES( '16',  '2', 'Ste Julienne');
INSERT INTO fetedujour VALUES( '17',  '2', 'St Alexis');
INSERT INTO fetedujour VALUES( '18',  '2', 'Ste Bernadette');
INSERT INTO fetedujour VALUES( '19',  '2', 'St Gabin');
INSERT INTO fetedujour VALUES( '20',  '2', 'Ste Aimée');
INSERT INTO fetedujour VALUES( '21',  '2', 'St Damien');
INSERT INTO fetedujour VALUES( '22',  '2', 'Ste Isabelle');
INSERT INTO fetedujour VALUES( '23',  '2', 'St Lazare');
INSERT INTO fetedujour VALUES( '24',  '2', 'St Modeste');
INSERT INTO fetedujour VALUES( '25',  '2', 'St Roméo');
INSERT INTO fetedujour VALUES( '26',  '2', 'St Nestor');
INSERT INTO fetedujour VALUES( '27',  '2', 'Ste Honorine');
INSERT INTO fetedujour VALUES( '28',  '2', 'St Romain');
INSERT INTO fetedujour VALUES( '29',  '2', 'St Auguste');
INSERT INTO fetedujour VALUES(  '1',  '3', 'St Aubin');
INSERT INTO fetedujour VALUES(  '2',  '3', 'St Jaouen');
INSERT INTO fetedujour VALUES(  '3',  '3', 'St Gwénola');
INSERT INTO fetedujour VALUES(  '4',  '3', 'St Casimir');
INSERT INTO fetedujour VALUES(  '5',  '3', 'St Olive');
INSERT INTO fetedujour VALUES(  '6',  '3', 'Ste Colette');
INSERT INTO fetedujour VALUES(  '7',  '3', 'Ste Félicité');
INSERT INTO fetedujour VALUES(  '8',  '3', 'St Jean de Dieu');
INSERT INTO fetedujour VALUES(  '9',  '3', 'Ste Françoise');
INSERT INTO fetedujour VALUES( '10',  '3', 'St Vivien');
INSERT INTO fetedujour VALUES( '11',  '3', 'Ste Rosine');
INSERT INTO fetedujour VALUES( '12',  '3', 'Ste Justine');
INSERT INTO fetedujour VALUES( '13',  '3', 'St Rodrigue');
INSERT INTO fetedujour VALUES( '14',  '3', 'Ste Mathilde');
INSERT INTO fetedujour VALUES( '15',  '3', 'Ste Louise');
INSERT INTO fetedujour VALUES( '16',  '3', 'Ste Bénédicte');
INSERT INTO fetedujour VALUES( '17',  '3', 'St Patrick');
INSERT INTO fetedujour VALUES( '18',  '3', 'St Cyrille');
INSERT INTO fetedujour VALUES( '19',  '3', 'St Joseph');
INSERT INTO fetedujour VALUES( '20',  '3', 'St Herbert');
INSERT INTO fetedujour VALUES( '21',  '3', 'Ste Clémence');
INSERT INTO fetedujour VALUES( '22',  '3', 'Ste Léa');
INSERT INTO fetedujour VALUES( '23',  '3', 'St Victorien');
INSERT INTO fetedujour VALUES( '24',  '3', 'Ste Karine');
INSERT INTO fetedujour VALUES( '25',  '3', 'Annonciation');
INSERT INTO fetedujour VALUES( '26',  '3', 'Ste Lara');
INSERT INTO fetedujour VALUES( '27',  '3', 'St Habib');
INSERT INTO fetedujour VALUES( '28',  '3', 'St Gontran');
INSERT INTO fetedujour VALUES( '29',  '3', 'Ste Gwladys');
INSERT INTO fetedujour VALUES( '30',  '3', 'St Amédée');
INSERT INTO fetedujour VALUES( '31',  '3', 'St Benjamin');
INSERT INTO fetedujour VALUES(  '1',  '4', 'St Hugues');
INSERT INTO fetedujour VALUES(  '2',  '4', 'Ste Sandrine');
INSERT INTO fetedujour VALUES(  '3',  '4', 'St Richard');
INSERT INTO fetedujour VALUES(  '4',  '4', 'St Isidore');
INSERT INTO fetedujour VALUES(  '5',  '4', 'Ste Irène');
INSERT INTO fetedujour VALUES(  '6',  '4', 'St Marcellin');
INSERT INTO fetedujour VALUES(  '7',  '4', 'St Jean-Baptiste');
INSERT INTO fetedujour VALUES(  '8',  '4', 'Ste Julie');
INSERT INTO fetedujour VALUES(  '9',  '4', 'St Gautier');
INSERT INTO fetedujour VALUES( '10',  '4', 'St Fulbert');
INSERT INTO fetedujour VALUES( '11',  '4', 'St Stanislas');
INSERT INTO fetedujour VALUES( '12',  '4', 'St Jules');
INSERT INTO fetedujour VALUES( '13',  '4', 'Ste Ida');
INSERT INTO fetedujour VALUES( '14',  '4', 'St Maxime');
INSERT INTO fetedujour VALUES( '15',  '4', 'St Paterne');
INSERT INTO fetedujour VALUES( '16',  '4', 'St Benoît-Joseph');
INSERT INTO fetedujour VALUES( '17',  '4', 'St Anicet');
INSERT INTO fetedujour VALUES( '18',  '4', 'St Parfait');
INSERT INTO fetedujour VALUES( '19',  '4', 'Ste Emma');
INSERT INTO fetedujour VALUES( '20',  '4', 'Ste Odette');
INSERT INTO fetedujour VALUES( '21',  '4', 'St Anselme');
INSERT INTO fetedujour VALUES( '22',  '4', 'St Alexandre');
INSERT INTO fetedujour VALUES( '23',  '4', 'St Georges');
INSERT INTO fetedujour VALUES( '24',  '4', 'St Fidèle');
INSERT INTO fetedujour VALUES( '25',  '4', 'St Marc');
INSERT INTO fetedujour VALUES( '26',  '4', 'Ste Alida');
INSERT INTO fetedujour VALUES( '27',  '4', 'Ste Zita');
INSERT INTO fetedujour VALUES( '28',  '4', 'Ste Valérie');
INSERT INTO fetedujour VALUES( '29',  '4', 'Ste Catherine');
INSERT INTO fetedujour VALUES( '30',  '4', 'St Robert');
INSERT INTO fetedujour VALUES(  '1',  '5', 'St Jeremie');
INSERT INTO fetedujour VALUES(  '2',  '5', 'St Boris');
INSERT INTO fetedujour VALUES(  '3',  '5', 'St Philippe');
INSERT INTO fetedujour VALUES(  '4',  '5', 'St Sylvain');
INSERT INTO fetedujour VALUES(  '5',  '5', 'Ste Judith');
INSERT INTO fetedujour VALUES(  '6',  '5', 'Ste Prudence');
INSERT INTO fetedujour VALUES(  '7',  '5', 'Ste Gisèle');
INSERT INTO fetedujour VALUES(  '8',  '5', 'St Désiré');
INSERT INTO fetedujour VALUES(  '9',  '5', 'Ste Pacôme');
INSERT INTO fetedujour VALUES( '10',  '5', 'Ste Solange');
INSERT INTO fetedujour VALUES( '11',  '5', 'Ste Estelle');
INSERT INTO fetedujour VALUES( '12',  '5', 'St Achille');
INSERT INTO fetedujour VALUES( '13',  '5', 'Ste Rolande');
INSERT INTO fetedujour VALUES( '14',  '5', 'St Matthias');
INSERT INTO fetedujour VALUES( '15',  '5', 'Ste Denise');
INSERT INTO fetedujour VALUES( '16',  '5', 'St Honoré');
INSERT INTO fetedujour VALUES( '17',  '5', 'St Pascal');
INSERT INTO fetedujour VALUES( '18',  '5', 'St Eric');
INSERT INTO fetedujour VALUES( '19',  '5', 'St Yves');
INSERT INTO fetedujour VALUES( '20',  '5', 'St Bernardin');
INSERT INTO fetedujour VALUES( '21',  '5', 'St Constantin');
INSERT INTO fetedujour VALUES( '22',  '5', 'St Emile');
INSERT INTO fetedujour VALUES( '23',  '5', 'St Didier');
INSERT INTO fetedujour VALUES( '24',  '5', 'St Donatien');
INSERT INTO fetedujour VALUES( '25',  '5', 'Ste Sophie');
INSERT INTO fetedujour VALUES( '26',  '5', 'St Bérenger');
INSERT INTO fetedujour VALUES( '27',  '5', 'St Augustin');
INSERT INTO fetedujour VALUES( '28',  '5', 'St Germain');
INSERT INTO fetedujour VALUES( '29',  '5', 'St Aymard');
INSERT INTO fetedujour VALUES( '30',  '5', 'St Ferdinand');
INSERT INTO fetedujour VALUES( '31',  '5', 'Ste Perrette');
INSERT INTO fetedujour VALUES(  '1',  '6', 'St Justin');
INSERT INTO fetedujour VALUES(  '2',  '6', 'Ste Blandine');
INSERT INTO fetedujour VALUES(  '3',  '6', 'St Kevin');
INSERT INTO fetedujour VALUES(  '4',  '6', 'Ste Clotilde');
INSERT INTO fetedujour VALUES(  '5',  '6', 'St Igor');
INSERT INTO fetedujour VALUES(  '6',  '6', 'St Norbert');
INSERT INTO fetedujour VALUES(  '7',  '6', 'St Gilbert');
INSERT INTO fetedujour VALUES(  '8',  '6', 'St Médard');
INSERT INTO fetedujour VALUES(  '9',  '6', 'Ste Diane');
INSERT INTO fetedujour VALUES( '10',  '6', 'Ste Trinité');
INSERT INTO fetedujour VALUES( '11',  '6', 'St Barnabé');
INSERT INTO fetedujour VALUES( '12',  '6', 'St Guy');
INSERT INTO fetedujour VALUES( '13',  '6', 'St Antoine');
INSERT INTO fetedujour VALUES( '14',  '6', 'St Elisée');
INSERT INTO fetedujour VALUES( '15',  '6', 'Ste Germaine');
INSERT INTO fetedujour VALUES( '16',  '6', 'St Régis');
INSERT INTO fetedujour VALUES( '17',  '6', 'St Hervé');
INSERT INTO fetedujour VALUES( '18',  '6', 'St Léonce');
INSERT INTO fetedujour VALUES( '19',  '6', 'St Romuald');
INSERT INTO fetedujour VALUES( '20',  '6', 'St Silvère');
INSERT INTO fetedujour VALUES( '21',  '6', 'St Rodolphe');
INSERT INTO fetedujour VALUES( '22',  '6', 'St Alban');
INSERT INTO fetedujour VALUES( '23',  '6', 'Ste Audrey');
INSERT INTO fetedujour VALUES( '24',  '6', 'St Yann');
INSERT INTO fetedujour VALUES( '25',  '6', 'St Prosper');
INSERT INTO fetedujour VALUES( '26',  '6', 'St Anthelme');
INSERT INTO fetedujour VALUES( '27',  '6', 'St Fernand');
INSERT INTO fetedujour VALUES( '28',  '6', 'St Irénée');
INSERT INTO fetedujour VALUES( '29',  '6', 'St Pierre, St Paul');
INSERT INTO fetedujour VALUES( '30',  '6', 'St Martial');
INSERT INTO fetedujour VALUES(  '1',  '7', 'St Thierry');
INSERT INTO fetedujour VALUES(  '2',  '7', 'St Martinien');
INSERT INTO fetedujour VALUES(  '3',  '7', 'St Thomas');
INSERT INTO fetedujour VALUES(  '4',  '7', 'St Florent');
INSERT INTO fetedujour VALUES(  '5',  '7', 'St Antoine');
INSERT INTO fetedujour VALUES(  '6',  '7', 'Ste Mariette');
INSERT INTO fetedujour VALUES(  '7',  '7', 'St Eliane');
INSERT INTO fetedujour VALUES(  '8',  '7', 'St Thibaud');
INSERT INTO fetedujour VALUES(  '9',  '7', 'Ste Amandine');
INSERT INTO fetedujour VALUES( '10',  '7', 'St Ulric');
INSERT INTO fetedujour VALUES( '11',  '7', 'St Benoît');
INSERT INTO fetedujour VALUES( '12',  '7', 'St Olivier');
INSERT INTO fetedujour VALUES( '13',  '7', 'St Henri, St Joël');
INSERT INTO fetedujour VALUES( '14',  '7', 'St Camille, Fête Nationale');
INSERT INTO fetedujour VALUES( '15',  '7', 'St Donald');
INSERT INTO fetedujour VALUES( '16',  '7', 'Ste Carmen');
INSERT INTO fetedujour VALUES( '17',  '7', 'Ste Charlotte');
INSERT INTO fetedujour VALUES( '18',  '7', 'St Frédéric');
INSERT INTO fetedujour VALUES( '19',  '7', 'St Arsène');
INSERT INTO fetedujour VALUES( '20',  '7', 'Ste Marina');
INSERT INTO fetedujour VALUES( '21',  '7', 'St Victor');
INSERT INTO fetedujour VALUES( '22',  '7', 'Ste Marie-Madeleine');
INSERT INTO fetedujour VALUES( '23',  '7', 'Ste Brigitte');
INSERT INTO fetedujour VALUES( '24',  '7', 'Ste Christine');
INSERT INTO fetedujour VALUES( '25',  '7', 'St Jacques');
INSERT INTO fetedujour VALUES( '26',  '7', 'Ste Anne');
INSERT INTO fetedujour VALUES( '27',  '7', 'Ste Nathalie');
INSERT INTO fetedujour VALUES( '28',  '7', 'St Samson');
INSERT INTO fetedujour VALUES( '29',  '7', 'Ste Marthe');
INSERT INTO fetedujour VALUES( '30',  '7', 'Ste Juliette');
INSERT INTO fetedujour VALUES( '31',  '7', 'St Ignace');
INSERT INTO fetedujour VALUES(  '1',  '8', 'St Alphonse');
INSERT INTO fetedujour VALUES(  '2',  '8', 'St Julien');
INSERT INTO fetedujour VALUES(  '3',  '8', 'Ste Lydie');
INSERT INTO fetedujour VALUES(  '4',  '8', 'St Jean-Marie');
INSERT INTO fetedujour VALUES(  '5',  '8', 'St Abel');
INSERT INTO fetedujour VALUES(  '6',  '8', 'St Octavien');
INSERT INTO fetedujour VALUES(  '7',  '8', 'St Gaétan');
INSERT INTO fetedujour VALUES(  '8',  '8', 'St Dominique');
INSERT INTO fetedujour VALUES(  '9',  '8', 'St Amour');
INSERT INTO fetedujour VALUES( '10',  '8', 'St Laurent');
INSERT INTO fetedujour VALUES( '11',  '8', 'Ste Claire');
INSERT INTO fetedujour VALUES( '12',  '8', 'Ste Clarisse');
INSERT INTO fetedujour VALUES( '13',  '8', 'St Hippolyte');
INSERT INTO fetedujour VALUES( '14',  '8', 'St Evrard');
INSERT INTO fetedujour VALUES( '15',  '8', 'Ste Marie, Assomption');
INSERT INTO fetedujour VALUES( '16',  '8', 'St Armel');
INSERT INTO fetedujour VALUES( '17',  '8', 'St Hyacinthe');
INSERT INTO fetedujour VALUES( '18',  '8', 'Ste Hélène');
INSERT INTO fetedujour VALUES( '19',  '8', 'St Jean-Eudes');
INSERT INTO fetedujour VALUES( '20',  '8', 'St Bernard');
INSERT INTO fetedujour VALUES( '21',  '8', 'St Christophe');
INSERT INTO fetedujour VALUES( '22',  '8', 'St Fabrice');
INSERT INTO fetedujour VALUES( '23',  '8', 'Ste Rose');
INSERT INTO fetedujour VALUES( '24',  '8', 'St Barthélémy');
INSERT INTO fetedujour VALUES( '25',  '8', 'St Louis');
INSERT INTO fetedujour VALUES( '26',  '8', 'Ste Natacha');
INSERT INTO fetedujour VALUES( '27',  '8', 'Ste Monique');
INSERT INTO fetedujour VALUES( '28',  '8', 'St Augustin');
INSERT INTO fetedujour VALUES( '29',  '8', 'Ste Sabine');
INSERT INTO fetedujour VALUES( '30',  '8', 'St Fiacre');
INSERT INTO fetedujour VALUES( '31',  '8', 'St Aristide');
INSERT INTO fetedujour VALUES(  '1',  '9', 'St Gilles');
INSERT INTO fetedujour VALUES(  '2',  '9', 'Ste Ingrid');
INSERT INTO fetedujour VALUES(  '3',  '9', 'St Grégoire');
INSERT INTO fetedujour VALUES(  '4',  '9', 'Ste Rosalie');
INSERT INTO fetedujour VALUES(  '5',  '9', 'Ste Raïssa');
INSERT INTO fetedujour VALUES(  '6',  '9', 'St Bertrand');
INSERT INTO fetedujour VALUES(  '7',  '9', 'Ste Reine');
INSERT INTO fetedujour VALUES(  '8',  '9', 'St Adrien');
INSERT INTO fetedujour VALUES(  '9',  '9', 'St Alain');
INSERT INTO fetedujour VALUES( '10',  '9', 'Ste Inès');
INSERT INTO fetedujour VALUES( '11',  '9', 'St Adelphe');
INSERT INTO fetedujour VALUES( '12',  '9', 'St Apollinaire');
INSERT INTO fetedujour VALUES( '13',  '9', 'St Aimé');
INSERT INTO fetedujour VALUES( '14',  '9', 'St Materne');
INSERT INTO fetedujour VALUES( '15',  '9', 'St Roland');
INSERT INTO fetedujour VALUES( '16',  '9', 'Ste Edith');
INSERT INTO fetedujour VALUES( '17',  '9', 'St Renaud');
INSERT INTO fetedujour VALUES( '18',  '9', 'Ste Nadège');
INSERT INTO fetedujour VALUES( '19',  '9', 'Ste Emilie');
INSERT INTO fetedujour VALUES( '20',  '9', 'St Davy');
INSERT INTO fetedujour VALUES( '21',  '9', 'St Matthieu');
INSERT INTO fetedujour VALUES( '22',  '9', 'St Maurice');
INSERT INTO fetedujour VALUES( '23',  '9', 'St Constant');
INSERT INTO fetedujour VALUES( '24',  '9', 'Ste Thècle');
INSERT INTO fetedujour VALUES( '25',  '9', 'St Hermann');
INSERT INTO fetedujour VALUES( '26',  '9', 'St Côme, St Damien');
INSERT INTO fetedujour VALUES( '27',  '9', 'St Vincent de Paul');
INSERT INTO fetedujour VALUES( '28',  '9', 'St Venceslas');
INSERT INTO fetedujour VALUES( '29',  '9', 'Sts Michel');
INSERT INTO fetedujour VALUES( '30',  '9', 'St Jérôme');
INSERT INTO fetedujour VALUES(  '1', '10', 'Ste Thérèse');
INSERT INTO fetedujour VALUES(  '2', '10', 'St Léger');
INSERT INTO fetedujour VALUES(  '3', '10', 'St Gérard');
INSERT INTO fetedujour VALUES(  '4', '10', 'St François');
INSERT INTO fetedujour VALUES(  '5', '10', 'Ste Fleur');
INSERT INTO fetedujour VALUES(  '6', '10', 'St Bruno');
INSERT INTO fetedujour VALUES(  '7', '10', 'St Serge');
INSERT INTO fetedujour VALUES(  '8', '10', 'Ste Pélagie');
INSERT INTO fetedujour VALUES(  '9', '10', 'St Denis');
INSERT INTO fetedujour VALUES( '10', '10', 'St Ghislain');
INSERT INTO fetedujour VALUES( '11', '10', 'St Firmin');
INSERT INTO fetedujour VALUES( '12', '10', 'St Wilfrid');
INSERT INTO fetedujour VALUES( '13', '10', 'St Géraud');
INSERT INTO fetedujour VALUES( '14', '10', 'St Juste');
INSERT INTO fetedujour VALUES( '15', '10', 'Ste Thérèse');
INSERT INTO fetedujour VALUES( '16', '10', 'Ste Edwige');
INSERT INTO fetedujour VALUES( '17', '10', 'St Baudouin');
INSERT INTO fetedujour VALUES( '18', '10', 'St Luc');
INSERT INTO fetedujour VALUES( '19', '10', 'St René Goupil');
INSERT INTO fetedujour VALUES( '20', '10', 'Ste Adeline');
INSERT INTO fetedujour VALUES( '21', '10', 'Ste Céline');
INSERT INTO fetedujour VALUES( '22', '10', 'Ste Elodie');
INSERT INTO fetedujour VALUES( '23', '10', 'St Jean de Capistran');
INSERT INTO fetedujour VALUES( '24', '10', 'St Florentin');
INSERT INTO fetedujour VALUES( '25', '10', 'St Crépin');
INSERT INTO fetedujour VALUES( '26', '10', 'St Dimitri');
INSERT INTO fetedujour VALUES( '27', '10', 'Ste Emeline');
INSERT INTO fetedujour VALUES( '28', '10', 'St Simon');
INSERT INTO fetedujour VALUES( '29', '10', 'St Narcisse');
INSERT INTO fetedujour VALUES( '30', '10', 'Ste Bienvenue');
INSERT INTO fetedujour VALUES( '31', '10', 'St Quentin');
INSERT INTO fetedujour VALUES(  '1', '11', 'Toussaint');
INSERT INTO fetedujour VALUES(  '2', '11', 'Défunts');
INSERT INTO fetedujour VALUES(  '3', '11', 'St Hubert');
INSERT INTO fetedujour VALUES(  '4', '11', 'St Charles');
INSERT INTO fetedujour VALUES(  '5', '11', 'Ste Sylvie');
INSERT INTO fetedujour VALUES(  '6', '11', 'Ste Bertille');
INSERT INTO fetedujour VALUES(  '7', '11', 'Ste Carine');
INSERT INTO fetedujour VALUES(  '8', '11', 'St Geoffroy');
INSERT INTO fetedujour VALUES(  '9', '11', 'St Théodore');
INSERT INTO fetedujour VALUES( '10', '11', 'St Léon');
INSERT INTO fetedujour VALUES( '11', '11', 'St Martin');
INSERT INTO fetedujour VALUES( '12', '11', 'St Christian');
INSERT INTO fetedujour VALUES( '13', '11', 'St Brice');
INSERT INTO fetedujour VALUES( '14', '11', 'St Sidoine');
INSERT INTO fetedujour VALUES( '15', '11', 'St Albert');
INSERT INTO fetedujour VALUES( '16', '11', 'Ste Marguerite');
INSERT INTO fetedujour VALUES( '17', '11', 'Ste Elisabeth');
INSERT INTO fetedujour VALUES( '18', '11', 'Ste Aude');
INSERT INTO fetedujour VALUES( '19', '11', 'St Tanguy');
INSERT INTO fetedujour VALUES( '20', '11', 'St Edmond');
INSERT INTO fetedujour VALUES( '21', '11', 'Présentation de Marie');
INSERT INTO fetedujour VALUES( '22', '11', 'Ste Cécile');
INSERT INTO fetedujour VALUES( '23', '11', 'St Clément');
INSERT INTO fetedujour VALUES( '24', '11', 'Ste Flora');
INSERT INTO fetedujour VALUES( '25', '11', 'Ste Catherine');
INSERT INTO fetedujour VALUES( '26', '11', 'Ste Delphine');
INSERT INTO fetedujour VALUES( '27', '11', 'St Séverin');
INSERT INTO fetedujour VALUES( '28', '11', 'St Jacques de la Marche');
INSERT INTO fetedujour VALUES( '29', '11', 'St Saturnin');
INSERT INTO fetedujour VALUES( '30', '11', 'St André');
INSERT INTO fetedujour VALUES(  '1', '12', 'Ste Florence');
INSERT INTO fetedujour VALUES(  '2', '12', 'Ste Viviane');
INSERT INTO fetedujour VALUES(  '3', '12', 'St Xavier');
INSERT INTO fetedujour VALUES(  '4', '12', 'Ste Barbara');
INSERT INTO fetedujour VALUES(  '5', '12', 'St Gérald');
INSERT INTO fetedujour VALUES(  '6', '12', 'St Nicolas');
INSERT INTO fetedujour VALUES(  '7', '12', 'St Ambroise');
INSERT INTO fetedujour VALUES(  '8', '12', 'Ste Frida');
INSERT INTO fetedujour VALUES(  '9', '12', 'St Pierre Fourier');
INSERT INTO fetedujour VALUES( '10', '12', 'St Romaric');
INSERT INTO fetedujour VALUES( '11', '12', 'St Daniel');
INSERT INTO fetedujour VALUES( '12', '12', 'Ste Chantal');
INSERT INTO fetedujour VALUES( '13', '12', 'St Lucie');
INSERT INTO fetedujour VALUES( '14', '12', 'Ste Odile');
INSERT INTO fetedujour VALUES( '15', '12', 'Ste Ninon');
INSERT INTO fetedujour VALUES( '16', '12', 'Ste Alice');
INSERT INTO fetedujour VALUES( '17', '12', 'St Gaël');
INSERT INTO fetedujour VALUES( '18', '12', 'St Gatien');
INSERT INTO fetedujour VALUES( '19', '12', 'St Urbain');
INSERT INTO fetedujour VALUES( '20', '12', 'St Théophile');
INSERT INTO fetedujour VALUES( '21', '12', 'St Pierre Canisius');
INSERT INTO fetedujour VALUES( '22', '12', 'Ste Françoise-Xavière');
INSERT INTO fetedujour VALUES( '23', '12', 'St Armand');
INSERT INTO fetedujour VALUES( '24', '12', 'Ste Adèle');
INSERT INTO fetedujour VALUES( '25', '12', 'Noël');
INSERT INTO fetedujour VALUES( '26', '12', 'St Etienne');
INSERT INTO fetedujour VALUES( '27', '12', 'St Jean');
INSERT INTO fetedujour VALUES( '28', '12', 'St Gaspard');
INSERT INTO fetedujour VALUES( '29', '12', 'St David');
INSERT INTO fetedujour VALUES( '30', '12', 'St Roger');
INSERT INTO fetedujour VALUES( '31', '12', 'St Sylvestre');

A voir également

Ajouter un commentaire Commentaires
Messages postés
56
Date d'inscription
mercredi 29 septembre 2004
Statut
Membre
Dernière intervention
4 janvier 2010
1
Messages postés
1182
Date d'inscription
mercredi 21 janvier 2004
Statut
Membre
Dernière intervention
6 septembre 2011
14
sympa :)
Messages postés
124
Date d'inscription
mardi 30 décembre 2003
Statut
Membre
Dernière intervention
12 février 2010

parle mieux la france pour qu'on te comprenne svp, merci
Messages postés
1
Date d'inscription
dimanche 6 mai 2007
Statut
Membre
Dernière intervention
26 juin 2007

salut tout le monde j ai creer une appliccation c est un peu compliquer en bref mon probleme ce que a chaque fois que j exute l application l espace de ma base de donnée access augmente et j aimerai savoir si quelqu un a la solution merci
Messages postés
1765
Date d'inscription
jeudi 12 octobre 2000
Statut
Modérateur
Dernière intervention
11 décembre 2013
6
Pas mal pour les saints, sinon pour les dates et jours fériés, vous avez aussi quelque chose ici :
- http://www.asp-php.net/scripts/asp.net/table_sql_temps.php

Pour ceux que ca intéressera.

Romelard Fabrice.
Afficher les 11 commentaires

Vous n'êtes pas encore membre ?

inscrivez-vous, c'est gratuit et ça prend moins d'une minute !

Les membres obtiennent plus de réponses que les utilisateurs anonymes.

Le fait d'être membre vous permet d'avoir un suivi détaillé de vos demandes et codes sources.

Le fait d'être membre vous permet d'avoir des options supplémentaires.