title: Insert or Replace Multiple Row with where condition in SQLite Query
body: <p>I need a single SQLite query to insert or update in SQLite table.</p>
  <p><strong>MyTable:</strong></p>
  <ol>
  <li><strong>Id</strong>(Primary key and not null)</li>
  <li><strong>Name</strong></li>
  <li><strong>PhoneNumber</strong></li>
  </ol>
  <p><img src="https://i.stack.imgur.com/UX4HI.png" alt="enter image description here" /></p>
  <blockquote>
  <p><strong>Expected Query</strong>: If the Id is not present then have to insert a new row
  and If the existing row value is changed then update the row when inserting multiple row.</p>
  </blockquote>
  <p><strong>EDIT 1:</strong></p>
  <p>I have posted INSERT query i have tried in <a href="https://stackoverflow.com/questions/15613377/insert-multiple-rows-in-sqlite-error-error-code-1">Insert Multiple Rows in SQLite Error (error code = 1)</a>. Like that i I have tried using &quot;INSERT OR REPLACE&quot;. But it is <code>working with Firfox SQLite Manager Not working with Android SQLite</code>.</p>
  <p>I have used <code>sDataBase.execSQL(query)</code> to execute this query.</p>