to store this dataset into a database. Well - probably i can use MySQL
Results 1 to 1 of 1

Thread: to store this dataset into a database. Well - probably i can use MySQL

  1. #1
    Member
    Join Date
    Sep 2010
    Posts
    41

    to store this dataset into a database. Well - probably i can use MySQL

    howdy

    gotta have a dataset - derived from a retrieval at http://www.overpass-turbo.eu

    i want to store this dataset into a database. Well - probably i can use MySQL

    Code:
    2022037714	node	Spitex Malters	6102	Malters	Luzernstrasse	45		
    2032830906	node	Zahnarzt Mr. Dr.med.dent. Werner Hübscher	6102	Malters	Schwarzenbergstrasse	3	http://praxis-landegg.ch	
    2048956655	node	HUG - Hopitaux Universitaires de Genève	1205	Genève	Rue Gabrielle-Perret-Gentil	4	http://hug-ge.ch	
    2048958223	node	HUG - Ophtalmology Emergency	1205	Genève	Rue Alcide Jentzer	22	http://www.hug-ge.ch/ophtalmologie	
    2087691992	node	Gemeinschaftspraxis Reigoldswil	4418	Reigoldswil	Unterbiel	26		
    2095618277	node	Klinik am Rosenberg	9410	Heiden	Hasenbühlstrasse	11	https://www.hirslanden.ch/global/de/startseite/kliniken_zentren/klinik_am_rosenberg.html	
    2143742782	node	Kantonsspital Laufen	4242	Laufen	Lochbruggstrasse	39	http://ksbl.ch	
    2150551631	node	Spital und Altersheim Belp	3123	Belp	Seftigenstrasse	89/91	https://www.spitalbelp.ch	
    2156115530	node	HUG - Maternité	1205	Genève	Boulevard de la Cluse	30	http://www.hug-ge.ch/la-maternite	
    2156115531	node	Médecine Dentaire HUG	1205	Genève	Rue Barthélemy-Menn	19		
    2157985849	node	Fondation pour recherches médicales	1205	Genève	Avenue de la Roseraie	64		
    2162831565	node	La Fondation Clair Bois-Minoteries	1205	Genève	Rue des Minoteries	11	http://www.clairbois.ch/pages/25/clair-bois-minoteries	
    2272853428	node	Alterstagesklinik PZU	8610	Uster	Asylstrasse	30		
    2374939780	node	Kinder-Permanence Spital Zollikerberg	8125	Zollikerberg	Trichtenhauserstrasse	2		
    2387346670	node	EMS Résidence de Drize		Vessy	Route de Drize	61		
    2400956593	node	Spital Schiers	7220	Schiers	Tersierstrasse	7	http://www.flurystiftung.ch/Startseite.20.0.html	
    2402208629	node	Travel clinic - Médecine Internationale et Humanitaire	1211	Genève	Rue Gabrielle-Perret-Gentil	6	http://medecine-internationale.hug-ge.ch/eng/consultations_vaccinations/voyages.html	
    2457155610	node	Doktor Med. Urs Rimensberger	6024	Hildisrieden	Grossacher			
    2523291193	node	Permedico SA	1020	Renens	Avenue du Censuy	14	http://www.permedico.ch	
    2531898699	node	Gesundheitszentrum Jura Süd (SRO)	4704	Niederbipp	Anternstrasse	22		
    2531898700	node	Gesundheitszentrum Jura Süd (SRO)	4704	Niederbipp	Anternstrasse	24		
    2573546648	node	Centre médical Charpentiers	1110	Morges	Rue Centrale	24		
    2616596286	node	Apotheke	4056	Basel	Elsässerstrasse			
    2627941699	node	Podologie-Praxis Limmattal Gmbh	8142	Uitikon	Im Spilhöfler	2	http://www.podologie-limmattal.ch	
    2627944017	node	Podologie-Praxis Limmattal GmbH	6003	Luzern	Hirschengraben	52	http://www.podologie-limmattal.ch	
    2710603813	node	Klink Teufen	9053	Teufen	Landhausstrasse	1	http://klinikteufen.ch	
    2789880024	node	Dentist Abbas Hussain	6300	Zug	Bahnhofstrasse	28	http://www.zahnarzthussain.ch	
    2789960518	node	Zahnarztpraxis Rupperswil	5102	Rupperswil	Dorfstrasse	9		
    2812036712	node	Rehaklinik Hasliberg	6083	Hasliberg Hohfluh	Laueli	89B		
    2828630061	node	YIN YANG MEDI	3400	Burgdorf	Bahnhofstrasse	61	http://www.yinyangmedi.ch/tcm-zentrum-burgdorf	
    2828653814	node	Yin Yang Medi	3052	Zollikofen	Bernstrasse	162	http://www.yinyangmedi.ch/tcm-zentrum-zollikofen	
    2828712384	node	YIN YANG MEDI	4900	Langenthal	St. Urbanstrasse	3	http://www.yinyangmedi.ch/tcm-zentrum-langenthal


    again: gotta have a dataset - derived from a retrieval at http://www.overpass-turbo.eu


    Task; to store this dataset into a database. Well - probably i can use MySQL
    dilbert 2010 :: overwhelming wordpress-toolkits http://wpgear.org/

  2. #2
    High Energy Magic Dept. NogDog's Avatar
    Join Date
    Aug 2006
    Location
    Ankh-Morpork
    Posts
    14,909
    If it's in a file, search on something like "mysql load data infile"
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •