mardi 18 août 2015

How to select or copy data in tables of sqlite database

I am using eclipse ADT for android development, I have added the SqliteManagerPlugin for eclipse and I can view the data stored in sqlite db. But my question is that how to select data from sqlitedb table which is showed in the DDMS section of the eclipseADT IDE.

Say i have a table named in employee in sqlitedb in my application named EmployeeApp

To view the Tabe I do this

DDMS-> File Explorer tab-> data->data->com.package.EmployeeApp->database->employee.db

and click on the ble db icon on the tab to view the database, then i click on browse data to view the values stored in a table.

Say my employee table contains

id    name    salary
01    Don     10K

I can view this data but cannot copy it. Is there any way to do so, I this case its easy to look and type in text editor, but if there were some alphanumeric values in any other table say dve44r948ebdne8dnbc it will be really hard to retype it by changing windows.

I there any method for copying datas in table?

I searched a lot for this pleese help.

Aucun commentaire:

Enregistrer un commentaire