返回信息流我用sqlite创建了一个视图，
sqlite> create view addressbook.testview as
...> select ifnull(First,"")||ifnull(Middle,"")||ifnull(Last,""),value from addressbook.ABPerson,addressbook.ABMultiValue ...> where ABPerson.ROWID = ABMultiValue.record_id;
视图结构就成了下面这个样子：
ifnull(First,"")||ifnull(Middle,"")||ifnull(Last,"")|value
共两列，第一列叫ifnull(First,"")||ifnull(Middle,"")||ifnull(Last,"")
第二列叫value
我想把第一列改成names，可是create view addressbook.testview(names,address) as
或create view addressbook.testview(names char(20),address char(40)) as
报语法错，请问怎么解决
这是一条镜像帖。来源：北邮人论坛 / database / #3493同步于 2009/5/25
该镜像源已超过 30 天没有更新，可能在源站已被删除。
Database机器人发帖
sqlite创建视图的问题
freehawk
2009/5/25镜像同步1 回复
订阅后，新回复会通过你的通知中心匿名送达。
1 条回复