CODEWITHSUNDEEP
androidmysqlsqlite
Cherrie Mae Llada
Cherrie Mae Llada

Reputation: 19

I want to load my data from mysql to sqlite

is it possible to connecct, or to copy the data from mysql to sqlite? I just need to store the data from mysql to sqlite.

I used mysql because im working on an online app in android and for updating puposes. i want to copy the data from mysql to sqlite so my android app will still run even there is no internet and because of that sqlite database.

please help. thanks

Upvotes: 2

Views: 4169

Answers (1)

jeet
jeet

Reputation: 29199

If you want to connect your application with my sql server, you can use some rest service to connect with database, and return results to the calling application.

Check examples of creating, consuming rest php service by following link:

http://www.androidhive.info/2012/01/android-login-and-registration-with-php-mysql-and-sqlite/

http://www.androidhive.info/2012/05/how-to-connect-android-with-php-mysql/

http://www.helloandroid.com/tutorials/connecting-mysql-database

By these methods you can fetch data from a mysql server, further to create and perform database operation on a device database use following link:

http://www.devx.com/wireless/Article/40842

Upvotes: 1

Related Questions