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

Editor to share with you a SQL statement to query different databases of the method, I believe that most people do not understand, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

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'; above is all the contents of the method of querying different databases with a SQL statement. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.