Hi, I can attach a database to the current session. But I have to explicitly specify the table name to refer to any tables in it (such 'create_index' in 'create_index.sqlite_master'). Is there a command similar to 'use database' (mysql) in sqlite3 so that I can make a particular database as default? (I don't find such command, but please let me know in case if I miss anything.)
sqlite> attach database 'create_index.db' as create_index; sqlite> select * from create_index.sqlite_master; -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
