title: Working with .sql file in android?
body: <p>I am working on android project. In my project I have a 'DatabaseFood <strong>.sql</strong> 'file(initially it was a .csv file), it looks like this</p>
  
  <pre><code>BEGIN TRANSACTION;
  CREATE TABLE "android_metadata" ("locale" TEXT DEFAULT 'en_US');
  INSERT INTO `android_metadata` VALUES ('en_US');
   CREATE TABLE "DBfood" (
  `SNo.`  INTEGER,
  `Food`  TEXT,
  `Calories`  INTEGER,
  `Protein`   INTEGER,
  `Fats`  INTEGER,
  `Carbs` INTEGER,
  `Fibers`    INTEGER);
   INSERT INTO `DBfood` VALUES (1,'Apple',120,50,40,30,20);
   INSERT INTO `DBfood` VALUES (2,'Banana',111,45,40,50,21);
   INSERT INTO `DBfood` VALUES (3,'Orange',91,31,33,19,21);
   INSERT INTO `DBfood` VALUES (4,'Grapes',110,41,11,14,13);
   INSERT INTO `DBfood` VALUES (5,'Mango',150,51,12,41,53);
   COMMIT;
  </code></pre>
  
  <p>Now my questions are -</p>
  
  <p>Where do i put this file if i plan to have about 20000 entries in it. In res/raw folder or res/assets folder or somewhere else.</p>
  
  <p>How I could use all the data in the file. For ex - If i want to get the calories of apple or If i want to get proteins of Orange.</p>
  
  <p>How could i perform arithmetic operations with the properties(Calorie, protein etc) of food.</p>
  
  <p>Please suggest me answers to my questions with sample code or references. Also, If you know how to match this file with 'DatabaseHelper.java'(for ex) class in which we create tables and perform CRUD operations and execute queries.</p>
  
  <p>But remember that it would always be happening with a very large amount of data. I have only put that code so that it becomes easy to answer with sample code.</p>