update sqlite table from mysql

Here's a quick snippet to copy a mysql table into an sqlite database:

ssformat dbi:mysql:name_of_database:table=name_of_table:username=root sqlite_database.db

If the table already exists in the sqlite database, its schema is left untouched. Otherwise, a rough-and-ready schema is set up. Dbi syntax information here.

ssformat is from the coopy toolbox.