Shulou(Shulou.com)06/01 Report--

Requirements: a SQL statement queries the associated results from multiple databases and outputs them to the client

Survey: spring framework can configure multiple data sources; sql can also attach multiple databases to a master database

Solution: add multiple libraries to the main library with ATTACH DATABASE statement to realize the function

Syntax:

ATTACH DATABASE 'DatabaseName' As' Alias-Name'

Example:

ATTACH DATABASE'C:\ Users\ Administrator\ Desktop\ sqlite_data.sq3' As' sd'

Summary

The above is a SQL statement introduced by the editor to query multiple databases. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.