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

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 (?,?,?,?,?,?)';` [download] poj	[reply] [d/l]
Re^6: from osm to mysql:: with insert-statement by Perlbeginner1 (Scribe) on May 29, 2014 at 15:59 UTC
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	[reply]