create table中的语法错误代码1

本文介绍了create table中的语法错误代码1的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我收到以下语法错误代码（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).