On May 12, rebornishard wrote:
i browse but didn't find it
there is 5 apps running sqlite and they will export it intoonline
mysql or online sqlite database
search from doc but still didn't get anything
thanks
Your question is unclear, which is likely why it has not been answered.
I am guessing that you wish to transfer the content of a SQLite DB to
some other DB. The shell that is included with the amalgamation release
has a command, ".dump", which writes to stdout a sequence of SQL
statements which will generate the open DB contents. Here is a sample
shell session that demonstrates creating a DB, using .dump to get its
generating SQL, and using that SQL to create a duplicate DB:
sqlite3 mydb.sldb
create table Silly (id int, what text);
create table Goofy (id int, how text);
insert into Silly values (1, 'silly one');
insert into Goofy values (2, 'goofy two');
.quit
echo .dump | sqlite3 mydb.sldb > mkdb.sql
sqlite3 dupe.sldb < mkdb.sql
With suitable DDL or a simple transformation of the DDL generated by
.dump, that SQL can be used to "export it into online mysql" or some such.
Cheers,
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
