Use of Firefox Plugin SQLite Manager

In the last few days, the high IOS database started to learn coredata from the very beginning. As a result, there was no progress in the previous day. No way, please be honest with the code first, but the operation of Visual Database using Firefox plug-in is also good.

I found the search usage on the Internet, but I really didn't find anything. I finally read the following article. Well, that's the usage on the interface.

 

Post address: http://www.it118.org/Specials/458ee903-6e5b-4a89-a9c4-b337f35e2496/8ea068a1-a174-41cc-af10-b3d74e4c8fd0.htm

 

Firefox Plugin: SQLite manager can manage any SQLite database on your computer. An intuitive directory tree is used to display database objects. You can manage tables, indexes, views, and triggers through prompt dialogs. You can browse and search these tables and add, modify, or delete records. Quickly execute any SQL query. A drop-down menu of SQL syntax help makes it easy to write SQL. You can easily perform the same operations by using menus, toolbar, buttons, and associated menus.

SQLite MANAGER: addons.mozilla.org/zh-cn/firefox/addon/5817

After this plug-in is installed, SQLite manager appears under the tool menu of Firefox.

Click to bring up a small window in the middle of the screen. The default size is 800 × 600.

1. Create and open the SQLite database.

Creating an SQLite database is particularly simple. Click the create button in the toolbar to create a local file for the database.

Use the toolbar button to open a local SQLite database file to open a database.

2. Manage table View index trigger in SQLite

The small window view on the Left does not have any content. You need to create a new data storage path. Then, the four small items table View index trigger appear in the left-side view. You can right-click to perform the create operation.

Test Table: After a table is created, it is automatically displayed in a tree chart under the table item. In this actual table, you can right-click Create, drop, empty, rename, copy, and export.

With the SQLite manager plug-in of Firefox, you do not need to install SQLite on the local machine. Using SQLite manager, you can create a small database on the local machine for common personal data management.

 

3. Select database-> export database, and select SQL as the file format.

4. Import the SQL file to MySQL.