我的 SQLite 语法错误 [英] Error in my SQLite syntax

问题描述

SQLite 新手，所以我不知道我做错了什么.我刚刚收到一条错误消息:

New to SQLite so I don't know what I'm doing wrong. I'm just getting an error saying:

SQLSTATE[HY000]: General error: 1 near "CREATE": syntax error

这是我的 SQL:

CREATE TABLE users (
  id INTEGER NOT NULL PRIMARY KEY,
  date_created DATETIME NOT NULL,
  date_updated DATETIME NOT NULL,
  username VARCHAR(32) NOT NULL,
  password VARCHAR(32) NOT NULL,
  role VARCHAR(32) NOT NULL DEFAULT 'member',
  first_name VARCHAR(50) NOT NULL,
  last_name VARCHAR(50) NOT NULL,
  email VARCHAR(128) NOT NULL
)

CREATE TABLE subscribers (
  id INTEGER NOT NULL PRIMARY KEY,
  name VARCHAR(40) DEFAULT NULL,
  email VARCHAR(255) NOT NULL UNIQUE
)

CREATE TABLE weekly_download (
  id INTEGER NOT NULL PRIMARY KEY,
  filename TEXT NOT NULL,
  download_date DATE NOT NULL,
  body TEXT
)

推荐答案

在每条语句后放一个分号.

put a semicolon after each statement.

CREATE TABLE ( ... ) ;
CREATE TABLE ( ... ) ;

这篇关于我的 SQLite 语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！