On 2019/04/08 3:03 PM, Mohsen Pahlevanzadeh wrote:
Hello,
I need to export some tables with dot command, How I do it?
That depends on what you mean by "export"?
Do you wish to export the table structure (schema)?
- in which case the dot commands can be used easily,
or do you wish to export the data?
- in which case the CSV export function which Gunter mentioned will work
perfectly,
or do you wish to export schema and data both to instate the copy of the
table into another database?
- in which case the .dump or .clone can help or perhaps another more
specific approach.
or do you simply want to understand how the dot commands work?
- in which case here you go:
https://www.w3resource.com/sqlite/sqlite-dot-commands.php
I'm guessing you probably need some variant of: .dump ?Table?
Are you using the sqlite CLI from Linux, Mac or Windows? How big is the
data you wish to export? What format do you wish the result to be in?
Different scenarios dictate different methods - telling us more would
help greatly.
Cheers,
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
