56,677
社区成员
发帖
与我相关
我的任务
分享
DROP TABLE IF EXISTS AutoMergeTable;
Create table IF NOT EXISTS AutoMergeTable
AS SELECT * FROM
(
SELECT
*
FROM
(
SELECT *FROM
(
SELECT SN, JobName FROM HSG1
UNION
SELECT SN, JobName FROM HSG2
UNION
SELECT SN, JobName FROM HSG3
) TempTable
LEFT JOIN HSG1 ON TempTable.SN = HSG1.SN
LEFT JOIN HSG2 ON TempTable.SN = HSG2.SN
LEFT JOIN HSG3 ON TempTable.SN = HSG3.SN
)
GROUP BY SN HAVING COUNT(SN)<2 ORDER BY TIME) ;
sqlite>select * from sqlite_master where type='table';
sqlite>select * from sqlite_master where type='table';
sqlite>select * from sqlite_master where type='table';
sqlite> CREATE TABLE "main"."test" (
"id" INTEGER NOT NULL,
"str1" integer,
"str2" TEXT,
"str3" XYZ,
PRIMARY KEY ("id")
);
Query OK (0.08 sec)
sqlite> insert into test(id, str1, str2, str3) values(1, 'a', 'b', 'c');
Query OK - 1 row affected (0.08 sec)
sqlite> select * from test;
+----+------+------+------+
| id | str1 | str2 | str3 |
+----+------+------+------+
| 1 | a | b | c |
+----+------+------+------+
1 row in set (0.01 sec)