I'm trying to optimise a select statement, but from multiple attached databases. The general statement would be;
SELECT * FROM database0.table WHERE id = 1; Where i have a long list of ids to retrieve, which could be from any of the attached databases. With a single database i would prepare the statement and bind to the id value, but from what i understand i can't do this for the database name? Something like; SELECT * FROM :database.table WHERE id = :id; If that can't work is it worth creating some kind of view out of all the attached databases and running a prepared statement on the view? Or should i just leave it as multiple select statements! Thanks, Andrew _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
