Birthday mySQL DB to SQLite

It's been a while. And I forgot exact steps. So I had to review by looking at my SQLite notes. In addition to the data (from my, mySQL database on my remote web server) I like to keep a local SQLite version on my computer. I have some useful views that allow me to easily query the database. Especially with SQLite's builtin date routines. So here are the key steps.

*   define the table if necessary
*   .separator |
*   .import Birthday.txt Birthday **\[.import much faster than .read\]**
2021-02-08 13:23:07
Index