create table中的语法错误代码1 [英] Syntax error code 1 in create table

问题描述

我收到以下语法错误代码（1）：

I get syntax error code(1) for the following:

private static  final  String TABLE_NAME="VIVZTABLE";
    private static  final  String UID="_id";
    private static  final  String NAME="name";
    private static  final  String CREATE_TABLE="CREATE TABLE" +TABLE_NAME+ " (" +UID+ "INTEGER PRIMARY KEY AUTOINCREMENT," +NAME+ "VARCHAR(255));";

推荐答案

从CREATE TABLE更改为CREATE TABLE（即附加空白）。

（以及将INTEGER PRIMARY KEY AUTOINCREMENT，更改为INTEGER PRIMARY KEY AUTOINCREMENT，和VARCHAR（255））;进入VARCHAR（255）） ;，即在字符串前面添加一个空格。）

Change from "CREATE TABLE" to "CREATE TABLE " (that is append a blank).
(as well change "INTEGER PRIMARY KEY AUTOINCREMENT," into " INTEGER PRIMARY KEY AUTOINCREMENT," and "VARCHAR(255));" into " VARCHAR(255));", that is add a blank in front of the strings).

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