Question

):SQL建表错误

SQL错误，求教 db.execSQL("CREATE TABLE person(personid integer primary key autoincrement,name varchar(20),phone varchar(12),check varchar(12))");
04-24 10:06:43.907: E/AndroidRuntime(26166): FATAL EXCEPTION: main
04-24 10:06:43.907: E/AndroidRuntime(26166): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.counting/com.example.counting.counting}: android.database.sqlite.SQLiteException: near "varchar": syntax error (code 1): , while compiling: CREATE TABLE person(personid integer primary key autoincrement,name varchar(20),phone varchar(12),check varchar(12))
04-24 10:06:43.907: E/AndroidRuntime(26166): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
04-24 10:06:43.907: E/AndroidRuntime(26166): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
04-24 10:06:43.907: E/AndroidRuntime(26166): at android.app.ActivityThread.access$600(ActivityThread.java:141)
04-24 10:06:43.907: E/AndroidRuntime(26166): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
04-24 10:06:43.907: E/AndroidRuntime(26166): at android.os.Handler.dispatchMessage(Handler.java:99)
04-24 10:06:43.907: E/AndroidRuntime(26166): at android.os.Looper.loop(Looper.java:137)
04-24 10:06:43.907: E/AndroidRuntime(26166): at android.app.ActivityThread.main(ActivityThread.java:5041)

Answer 1

mysql?

CREATE TABLE person(personid int not null primary key AUTO_INCREMENT,
`name` varchar(20),
phone varchar(12),
`check` varchar(12))

这样试试