sql - SQLite 中的向量/列表

Question

我是 SQL 新手，是否有列表或向量变量类型？我可以有一个类型是字符串列表的列吗？

也许是这样的:

CREATE TABLE myTbl(domain varchar PRIMARY KEY, linkList list<varchar>);

我可以附加这样的字符串吗(通过使用“+=”运算符):

UPDATE myTbl SET linkList += "www.test.com," WHERE domain="blah";
// Table is like so
CREATE TABLE myTbl(domain varchar PRIMARY KEY, linkList varchar);
// Column linkList is a string of links separated by comma's

Answer 1

No, there are no array/list/vector data types in SQLite . The string concatenation operator in SQLite is || .