I have to populate a MYSQL database with CSV files. The database exists, but I have no idea what it looks like or what tables are in the database or anything. Actually, I have no idea what the hell to do. I have many problems with this and I am looking for guidance. I need to get a listing of the tables in the database, with the field names. I need to know how to import CSV files into the database tables. And then, to top it off, I need to test it to see if the data is where it is supposed to be. I would love to pitch a fit about this software company, but that won't get the job done, so, any ideas?
Thanks in advance.