2009-10-02

Useful sqlite3 Commands

>sqlite3 $DB //create a db
>sqlite3 $DB < $sql_script //create a db using a sql script
>sqlite3 //enter sqlite3 sql shell
>.exit //leave the sqlite3 sql shell
>
.header ON //Column title is printed out by select

No comments:

Post a Comment