Am 17.4.06 um 10:58 schrieb 杰 张:
Hi,all
I just want to implement to download a sqlite table in a
sqlite db from IE browser , but I must first convert sqlite format
into text format for reading data information of the table. I want
to finish the conversion automatically through some shell
commands. Can I do it?
Thank you so much !
How about using the sqlite shell's '.dump' command? You can specify a
list of table names and it'll only dump those tables.
However, if you think about showing the data in an HTML table, you
could use something like
.mode html
select * from my_table;
to produce the HTML source for the table contents.
HTH,
</jum>