mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
19 lines
461 B
Plaintext
19 lines
461 B
Plaintext
|
|
CREATE TABLE blobs(k INTEGER PRIMARY KEY, v BLOB);
|
|
INSERT INTO blobs VALUES(1, zeroblob(100));
|
|
INSERT INTO blobs VALUES(2, zeroblob(100));
|
|
|
|
|
|
INSERT INTO blobs VALUES(3, 42);
|
|
INSERT INTO blobs VALUES(4, 54.4);
|
|
INSERT INTO blobs VALUES(5, NULL);
|
|
|
|
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
|
|
ATTACH 'test.db2' AS aux;
|
|
CREATE TABLE aux.t1(a INTEGER PRIMARY KEY, b);
|
|
|
|
INSERT INTO t1 VALUES(4, 'hello');
|
|
INSERT INTO aux.t1 VALUES(4, 'world');
|
|
|