错误的SQLite [英] Error in SQLite

问题描述

我创建一个SQLite，我加4列到我的表，但添加第五列时，productadd不能没有找到。这里有什么问题吗？对不起，我真的很新的SQLite

下面是我DatabaseHelper类

  db.execSQL（CREATE TABLE如果不存在的productTable（ID INTEGER PRIMARY KEY AUTOINCREMENT
                +productidno
                +TEXT
                +产品名
                +TEXT
                +productSku，则
                +TEXT
                +productdest
                +TEXT
                +productadd
                +TEXT）;）;
 

我的logcat的：

  15 07-28：38：49.460：I /数据库（382）：sqlite的返回：错误code = 1，味精=表的productTable没有指定的列productadd
07-28 15：38：49.492：E /数据库（382）：错误插入productadd =希望productidno =这个productdest =和productSku，则=我的产品名称=是
07-28 15：38：49.492：E /数据库（382）：android.database.sqlite.SQLiteException：表中的productTable没有productadd指定的列：，在编译：INSERT INTO的productTable（productadd，productidno，productdest，productSku，则，产品名称） VALUES（？，？，？？？）;
07-28 15：38：55.401：E / AndroidRuntime（382）：在android.app.ActivityThread.performResumeActivity（ActivityThread.java:3118）
 

解决方案

  db.execSQL（CREATE TABLE如果不存在的productTable（ID INTEGER PRIMARY KEY AUTOINCREMENT
                +productidno
                +TEXT
                +产品名
                +TEXT
                +productSku，则
                +TEXT
                +productdest
                +文本））;
 

I'm creating a SQLite, I added 4 columns into my table, but when adding the fifth column "productadd" cannot not be found. What's the problem here? Sorry, I'm really new to sqlite

Below is my DatabaseHelper class

   db.execSQL("CREATE TABLE if not exists producttable(id INTEGER PRIMARY KEY AUTOINCREMENT,"
                + " productidno"
                + " TEXT ,"
                + " productname"
                + " TEXT,"
                + " productprice" 
                + " TEXT,"
                + " productdest" 
                + " TEXT,"
                + " productadd"
                +" TEXT);");

My logcat:

 07-28 15:38:49.460: I/Database(382): sqlite returned: error code = 1, msg = table producttable has no column named productadd
07-28 15:38:49.492: E/Database(382): Error inserting productadd=hope productidno=this productdest=and productprice=me productname=is
07-28 15:38:49.492: E/Database(382): android.database.sqlite.SQLiteException: table producttable has no column named productadd: , while compiling: INSERT INTO producttable(productadd, productidno, productdest, productprice, productname) VALUES(?, ?, ?, ?, ?);
07-28 15:38:55.401: E/AndroidRuntime(382):  at android.app.ActivityThread.performResumeActivity(ActivityThread.java:3118)

解决方案

 db.execSQL("CREATE TABLE if not exists producttable(id INTEGER PRIMARY KEY AUTOINCREMENT,"
                + " productidno"
                + " TEXT ,"
                + " productname"
                + " TEXT,"
                + " productprice" 
                + " TEXT,"
                + " productdest"
                +" TEXT)");

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