MySQL Forums
Forum List  »  Newbie

Re: Is MYSQL what I need to read a text file into a database?
Posted by: Peter Brawley
Date: October 08, 2015 04:03PM

The answer's yes, but you're looking at a big job---create a database for the data, then ...

(i) write and debug scripts to create tables based on the data definition inputs of which you give an example

(ii) after all those tables are created, normalise the database for efficiency

(iii) write and debug scripts to input the data into those tables

Database design & use isn't like riding a bicycle. For jobs like yours, there's a semester or two of learning required. Consider hiring a MySQL DBA.

Options: ReplyQuote


Subject
Written By
Posted
Re: Is MYSQL what I need to read a text file into a database?
October 08, 2015 04:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.