correct syntax to copy from one table row to another (sqlite android)
<p>please, is this the correct syntax for copying a particular row from one table to another?</p>

<pre><code>db.execSQL("insert into Route select * from " + DATABASE_TABLE + " WHERE _id = rowId");
</code></pre>

<p>because for some reason, when i call the method that executes this statement, all the items from the first table are copied into the second table and not the specific row i want. thanks.</p>

<p>this is the method call for copy:</p>

<pre><code>public void copyData(long rowId){
db.execSQL("insert into Route select * from " + DATABASE_TABLE + " WHERE _id = rowId"); 
}
</code></pre>

<p>if not, could you please show me how?..</p>
