lundi 6 juillet 2015

Sql table copy between databases

I am using following line as it want to copy table from one database to another database but it shows error

no such table DATABASE_NAME.TABLE_CONTACTSDUMMY & DATABASE_NAME.TABLE_CONTACTS

while both table are present.

String countQuery ="INSERT INTO '"+ DATABASE_NAME +"'.'"+ TABLE_CONTACTSDUMMY +"' SELECT * FROM '"+DATABASE_NAME +"'.'"+ TABLE_CONTACTS +"'";

Aucun commentaire:

Enregistrer un commentaire