SQLite database Download installation and initial operation and problems encountered near "Sqlite3": syntax error

Source: Internet
Author: User
Tags sqlite sqlite database win32

1. Download the SQLite database:http://www.sqlite.org/download.html

     < Span style= "font-size:14px" > If you are installing on a window you need to be in the  windows Zone to download the precompiled binaries. Download download   Sqlite-shell-win32-*.zip   and   sqlite-dll-win32-*.zip   compressed files.

2. Download and unzip   and   sqlite-dll-win32-*.zip sqlite3.def , Sqlite3.dll, and Sqlite3.exe files.

        can put them anywhere on my computer, where I put these three files in  c:\>sqlite (that is, a SQLite folder was built in the C drive)

add C:\>sqlite to the PATH environment variable, and finally at the command prompt (cmd command), using the Sqlite3 command, the following results are displayed.

Input. Help:

The SQLite database is installed successfully.

3. Problems encountered

If you build a database directly inside SQLite, the following situation will occur: near "sqlite3": syntax error


this happens because SQLite already represents the database and how it is in the database inside wearer database. If you want to create a database, you can do this: create it directly in the C drive.

Of course, you can also create in the D, F disk:



SQLite database Download installation and initial operation and problems encountered near "Sqlite3": syntax error

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.