Joke Collection Website - Blessing messages - How to extract data with suffix? 

How to extract data with suffix? 

1. First, download a Navicat advanced software.

2. Open the installed software, click the "Link" option, and select SQLite to fill in the name. Database files that need to be opened. Select the following types to open an existing database file. Finally, you need to click Link Test to find it. A db file in a database file. If the link is successful, it can be determined.

3. Then, you can choose to view and edit the opened database file in the option box on the left. In fact, this Navicat is a tool to visualize different database files.

Summary:

There are two kinds of databases with the same extension. Db, a product of two companies. One is Paradox, an old desktop database, which is a product of Borland Company. It was widely used in Dos period, but there are still products developed with Delphi, C++Builder and other tools that use this type of database, and Microsoft's desktop data engine JET has relatively complete support for it.

The other is Sybase's ASA database, whose full name is Adaptive Server Anywhere. This database used to be called Sql Anywhere. This database can be used not only at the desktop level, but also at the server level, because it supports stored procedures, triggers and so on. , generally common in products developed by PowerBuilder, because after all, they are products of the same company, and both databases can be accessed through Navicat Premium.