i am a complete noob when it comes to mysql databases.
what i want to achieve - is this - i have a sap b1 database and i am going to be exporting data from the sql server out to a csv - from there i will send this csv through to my web server.
now what i want to do is to load up the csv into a mysql database on a scheduled basis.
here is the data that i will likely have in multiple csvs:
would i create a database for each within phpmyadmin?
also - let's take orders for example - would i create two tables - one for the order header information and another for order lines?
an example of the invoices csv would be the following format:
price ex tax,
price inc tax,
doc total inc tax
Any advice would be appreciated.