我现在是这样...
$dbh = new PDO('sqlite:SQLITE.db');
$dbh->beginTransaction();
$Query = SELECT t.`ID`, t.`name`, t.`country`, t.`age` FROM data_query
t WHERE t.country LIKE '%北京市%' and ORDER BY age ASC LIMIT 0, 20 ;;
$sth = $dbh->prepare($Query);
$sth->execute();
$TopicsArray = $sth->fetchAll();
查询城市跟年龄,然后再由小到大...
但因为资料有点多,我想新增SQLITE2.db,SQLITE3.db,SQLITE4.db....
结构完全一样,只是数据内容不一样....
请问该怎么操作能分库同时搜索多个sqlite,然后排序出最前面的20笔...