mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 09:49:40 +00:00
ad79ef48a2
* add tests * add bench
37 lines
1016 B
Plaintext
37 lines
1016 B
Plaintext
|
|
INSERT INTO tclvar(fullname, value)
|
|
VALUES('vtabJ(4)',4),('vtabJ(five)',555);
|
|
SELECT fullname, value FROM tclvar WHERE name='vtabJ' ORDER BY fullname;
|
|
|
|
|
|
SELECT fullname FROM tclvar WHERE arrayname='two'
|
|
|
|
|
|
DELETE FROM tclvar WHERE arrayname='two';
|
|
SELECT fullname, value FROM tclvar WHERE name='vtabJ' ORDER BY fullname;
|
|
|
|
|
|
INSERT INTO tclvar(fullname, value) VALUES('xx', 'a');
|
|
SELECT name, value FROM tclvar where name = 'xx';
|
|
|
|
|
|
UPDATE tclvar SET value = value || 't'
|
|
WHERE name = 'xx' OR name = 'x'||'x';
|
|
SELECT name, value FROM tclvar where name = 'xx';
|
|
|
|
|
|
UPDATE tclvar SET value = value || 't'
|
|
WHERE name = 'xx' OR name BETWEEN 'xx' AND 'xx';
|
|
SELECT name, value FROM tclvar where name = 'xx';
|
|
|
|
|
|
DELETE FROM tclvar WHERE name BETWEEN 'xx' AND 'xx' OR name='xx';
|
|
SELECT name, value FROM tclvar where name = 'xx';
|
|
|
|
|
|
CREATE TABLE var(k TEXT, v TEXT);
|
|
INSERT INTO var VALUES('testvar1', 10);
|
|
INSERT INTO var VALUES('testvar2', 20);
|
|
INSERT INTO var VALUES('testvar3', 30);
|
|
|