我写了一段sqlite3查询,如下所示:
CREATE TABLE appearances(
char_id int,
comic_id int
);
CREATE VIEW co-actors AS
SELECT a1.char_id,
a2.char_id
FROM appearances AS a1
LEFT JOIN appearances AS a2 ON a1.comic_id=a2.comic_id;
并且它不断在命令外壳中的"_"附近显示语法错误。任何人都可以帮我更正查询吗?谢谢~
还有一个问题,如果我想从刚刚创建的视图中选择,如何引用该列,例如a1.char_id?
将co-actors
更改为co_actors
您正在使用的-
应该使用_
.