turso> CREATE TABLE "MiXeD Name"(id INTEGER PRIMARY KEY AUTOINCREMENT, v);
INSERT INTO "MiXeD Name"(v) VALUES('x');
DROP TABLE "MiXeD Name";
CREATE TABLE "MiXeD Name"(id INTEGER PRIMARY KEY AUTOINCREMENT, v);
INSERT INTO "MiXeD Name"(v) VALUES('y');
SELECT id,v FROM "MiXeD Name";
SELECT name,seq FROM sqlite_sequence;
┌────┬───┐
│ id │ v │
├────┼───┤
│ 2 │ y │
└────┴───┘
┌────────────┬─────┐
│ name │ seq │
├────────────┼─────┤
│ mixed name │ 2 │
└────────────┴─────┘sqlite> CREATE TABLE "MiXeD Name"(id INTEGER PRIMARY KEY AUTOINCREMENT, v);
INSERT INTO "MiXeD Name"(v) VALUES('x');
DROP TABLE "MiXeD Name";
CREATE TABLE "MiXeD Name"(id INTEGER PRIMARY KEY AUTOINCREMENT, v);
INSERT INTO "MiXeD Name"(v) VALUES('y');
SELECT id,v FROM "MiXeD Name";
SELECT name,seq FROM sqlite_sequence;
1|y
MiXeD Name|1
