Octopus series of SQLite3 common commands

Source: Internet
Author: User


Export scripts
F:\b2cshop>sqlite3 b2cdb.db dump > Test.sql

Import Script
F:\b2cshop>sqlite3 B2cdb.db < B2c-sqlite.sql

F:\b2cshop>sqlite3 B2cdb.db < F:\B2CShop\B2C-SQLite.sql

Create a database
Sqlite3 Octopus.db < Octopus.sql

Import Data Script
Sqlite3 Octopus.db < Octopus2.0_demo.sql

Sqlite3 Octopus.db < Octopus.sql
Sqlite3 Octopuscommon.db < Octopuscommon.sql
Sqlite3 Octopusmember.db < Octopusmember.sql
Sqlite3 Octopusorders.db < Octopusorders.sql

If you use a script to create a database: Then I strongly recommend using the UltraEdit editor to create a UTF-8 BOM-free script

Use this editor, not easy error strongly recommended, what EditPlus notpad++ are weak

Octopus series of SQLite3 common commands

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: