[問題] sqlite 語句
抱歉不知道可不可以問
在建立table的時候就掛了 也不知道怎debug
(exception的message有跟沒有一樣
建立index table:
"CREATE TABLE "+
"index( "+
"_id INTEGER PRIMARY KEY AUTOINCREMENT, "+
"table_name NVARCHAR(20) "+
");"
建立data table:
"CREATE TABLE "+
"data( "+
"_id INTEGER PRIMARY KEY AUTOINCREMENT, "+
"index_ INTEGER UNSIGNED, "+
"item NVARCHAR(20), "+
"weight INTEGER UNSIGNED DEFAULT 1, "+
"FOREIGN KEY(index_) "+
"REFERENCES index(_id) "+
");"
先謝謝各位大大了
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.232.22.73
推
02/27 23:00, , 1F
02/27 23:00, 1F
→
02/28 00:50, , 2F
02/28 00:50, 2F
→
02/28 00:52, , 3F
02/28 00:52, 3F
→
02/28 00:52, , 4F
02/28 00:52, 4F
→
02/28 00:55, , 5F
02/28 00:55, 5F
→
02/28 01:00, , 6F
02/28 01:00, 6F
→
02/28 01:01, , 7F
02/28 01:01, 7F
→
02/28 01:01, , 8F
02/28 01:01, 8F
→
02/28 09:20, , 9F
02/28 09:20, 9F