vendredi 16 octobre 2015

How to get SQLite to ignore the first 17 rows of .csv file?

I'm brand new to using SQL and I'm not quite sure where to begin. I have many .CSV files in a folder and I wanted to go about making a database in order to provide a way to search through the information stored in each .csv file. All of the files are identical in their parameters, meaning all of the files are set up the same way in terms of columns and rows. Due to the way everything is set up and how files are laid out identically, this should be easy to code in SQL. Currently I am using SQLite in order to store and organize all of the data AFTER the first 17 rows of information Deleting the first 17 rows is also acceptable. I am familiar with Java and C++, but I'm not quite sure I understand how to skip or delete the first 17 rows in SQL, I also do not know how to code for this in SQLite. I would think that this is a simple thing, but I can't find anything on how to achieve this, skipping or deleting the first 17 rows of each .csv file. How would I go about telling SQLite to delete the first 17 rows?

Aucun commentaire:

Enregistrer un commentaire