sqlite3 特别语法

创建临时表

【SQLite】select into 语句
sqlite不支持类似sqlserver中的select into 语法

在SQL Server中，我们要将一个表中的数据复制到一个新表中，可以这样写：

SELECT * INTO newtable FROM oldtable
SQLite不支持以上语法，替代的语句是这样：

CREATE TABLE newtable AS SELECT * FROM oldtable
 

select (CreateTime || '    ' || Message) from Message where ChatID=='xxxx@chatroom'

update hra set  hro =replace(hro,',','-');

CREATE UNIQUE INDEX t1b ON HGNode(index);
CREATE INDEX t1b ON HGNode(index);

CREATE INDEX index_name2
ON HGNode (oid);

CREATE INDEX index_name1
on HRArea (oid, type);

 like ('%'||cast(b.oid as text)||'%')

select group_concat(aa.oid),',','-') 
from aa
order by aa.id

CREATE TABLE something (
  column1 int,
  column2 int,
  column3 int,
  PRIMARY KEY (column1, column2)
);

CREATE TABLE t1(a, b UNIQUE);

CREATE TABLE t1(a, b PRIMARY KEY);

CREATE TABLE t1(a, b);
CREATE UNIQUE INDEX t1b ON t1(b);