无法在 Windows 7 64 位机器上创建 sqlite3 数据库 [英] Unable to create sqlite3 database on windows 7 64 bit machine

问题描述

我正在尝试在我的 Windows 7 64 位机器上创建一个 sqlite3 数据库.我已经从 http://www.sqlite.org/download 下载了 sqlite-shell-win32-x86-3071502.html .从安装的文件夹中运行 sqlite3.exe 后，我运行了以下内容:

I am trying to create a sqlite3 database on my windows 7 64 bit machine. I have downloaded sqlite-shell-win32-x86-3071502 from http://www.sqlite.org/download.html . After running the sqlite3.exe from the installed folder, I ran the following:

sqlite3 mytest.db;

sqlite3 mytest.db;

但我收到错误:靠近sqlite3":语法错误".

But I am getting "Error: near "sqlite3": syntax error".

非常感谢任何帮助.

谢谢

推荐答案

我猜你在 sqlite shell 中输入了命令(见下文)

I guess you input the command in a sqlite shell (see below)

sqlite> sqlite3 mytest.db;
Error: near "sqlite3": syntax error

您收到错误，因为它不是有效的 sqlite 命令.如果您正在创建名为 mytest.db 的数据库，请尝试在 Windows 命令提示符下输入命令，然后您将处于 sqlite shell 环境中.要找出所有支持的命令，请在 sqlite shell 中输入 .help.

You got the error because it is not a valid sqlite command. If you are creating a database called mytest.db, try input the command in a Windows command prompt, then you would be in the sqlite shell environment. To find out all the supported commands, input .help in the sqlite shell.

D:\sqlite> sqlite3 mytest.db
SQLite version 3.6.23
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help

这篇关于无法在 Windows 7 64 位机器上创建 sqlite3 数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！