sqlite删除字段办法 near 'drop':syntax error;
来源:互联网 发布:非凡淘宝客 编辑:程序博客网 时间:2024/06/18 04:05
sqlite删除字段时提示附近有语法错误,怎么解决呢?sqlite中ALTER TABLE语句不支持DROP COLUMN,只有RENAME 和ADD
解决办法:
create table _temp as select _id,name,age,balance from person;
select * from _temp;
2.删除原表
drop table person;
3.把临时表命名成原表
alter table _temp rename to person; 0 0
- sqlite删除字段办法 near 'drop':syntax error;
- sqlite(near "AUTO_INCREMENT": syntax error)
- sqlite3 near"?":syntax error 问题解决办法
- sqlite报错 near "group": syntax error
- SQLite中出现错误:Error: near ")": syntax error
- Android SQLite 错误 SQLiteException: near "group": syntax error
- android.database.sqlite.SQLiteException: near "where": syntax error (code 1): ,
- (1) near "limit": syntax error (sqlite报错)
- Syntax error near "£"
- “Error: near "sqlite3”: syntax error
- syntax error near unexpected token `
- syntax error near unexpected token `('
- “syntax error near unexpected token `”
- syntax error near unexpected token `
- sqlite数据库下载安装和初步操作和所遇到的问题near "sqlite3":syntax error
- Keil: error C141: syntax error near 'unsigned'
- error C141: syntax error near 'unsigned'
- libtool: syntax error near unexpected token `]*'
- 第六周工作总结——Gnuradio的属性窗口
- C#与.NET的关系
- UICollectionViewLayout
- vim 常用快捷键
- Java中类之间的关系
- sqlite删除字段办法 near 'drop':syntax error;
- DB2 SQLSTATE=42818
- 黑马程序员_Java异常
- c语言编程--字符串指针
- 的废品够狠风格和风格和苟富贵东方红荣誉奖的条规定是噶的
- Thrift使用指南
- UICollectionView详解
- Cocos2d-x 3.0中 物理碰撞检测中onContactBegin回调函数不响应问题
- AutoResetEvent 允许线程通过发信号互相通信