Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^4: from osm to mysql:: with insert-statement

by Perlbeginner1 (Scribe)
on May 29, 2014 at 15:05 UTC ( [id://1087818]=note: print w/replies, xml ) Need Help??


in reply to Re^3: from osm to mysql
in thread from osm to mysql

hello dear Poi

again many many thanks - well - very convincing


- since i want to put all the data ( that i have in a xml-file) into the mysql db - i need to have a INSERT-Statement.

where to place this INSERT-statement!?
look forward to hear from you
  • Comment on Re^4: from osm to mysql:: with insert-statement

Replies are listed 'Best First'.
Re^5: from osm to mysql:: with insert-statement
by poj (Abbot) on May 29, 2014 at 15:31 UTC

    REPLACE is same as INSERT except if the record already exists it updates it rather than failing with a duplicate record error. This is useful when testing and running the same data in many times. Change this line to INSERT if you want to.

    my $sql = 'REPLACE INTO pois VALUES (?,?,?,?,?,?)';
    poj
      good day - many many thanks great to hear from you - i am allready testin the script and it does work - it does store the data in the mysql db many many thanks

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1087818]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (3)
As of 2024-04-24 17:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found