flutter - “列”附近：语法错误。在 sqflite 颤动中重命名或删除列时出现问题

Question

表

db.("CREATE TABLE if NOT EXISTS ayet ( id INTEGER, User_Name INTEGER DEFAULT(0),PRIMARY KEY(id AUTOINCREMENT))");

db.("CREATE TABLE if NOT EXISTS sure ( id INTEGER, User_Name INTEGER DEFAULT(0),PRIMARY KEY(id AUTOINCREMENT))");

当我重命名或删除列时

await db.execute("ALTER TABLE ayet RENAME COLUMN User_Name TO New_Name");
await db.execute("ALTER TABLE ayet DELETE COLUMN User_Name");

或者

await db.execute("ALTER TABLE ayet RENAME 'User_Name' TO 'New_Name'");
await db.execute("ALTER TABLE ayet DELETE COLUMN 'User_Name'");

我把这个问题

near "COLUMN": syntax error
I/flutter (22068): DatabaseException(near "COLUMN": syntax error (code 1 SQLITE_ERROR): , 
while compiling: ALTER TABLE ayet RENAME COLUMN User_Name TO New_Name) sql 'ALTER TABLE 
ayet RENAME COLUMN User_Name TO New_Name' args []

标签： flutterdartsqflite