LuxSci’s MySQL database hosting console now enables you to import data into MySQL database tables directly from a CSV (Comma Separated Variables) file, e.g. a simple and universal form that spreadsheets can be saved or exported to.
Why would you want to import data from CSV? Well, you could do the same thing by writing SQL code and importing this to your database or by connecting remotely to your database and issuing commands. But both of those methods take some time and expertise to set up. If you have a spreadsheet of data or a CSV of data created from some other system (e.g. customer information, contact lists, inventories, etc.), you can simply upload this file and populate your database with its new contents in a matter of seconds.
Read the rest of this post »