Welcome to the official Cloudflare Developers server. Here you can ask for help and stay updated with the latest news
83,498Members
View on DiscordResources
Similar Threads
Was this page helpful?
M
IM
M
AA
PPP
wrangler d1 execute DB --local --command "select * from company" return?APA
P
G
R
MM
DD
status text NOT NULL DEFAULT 'active' assuming that the status would default to active but it's not working, I could swear this worked in the past but I'm having issues right nowMMD
DDRMDDM
insert licenses (id) values (1); while the dash ui is trying to run this:MD
ISELECT * from test WHERE id=100 returns "rows_read": 1 from 150-row table at this moment.I
KEXPLAIN QUERY PLAN, you'll see that your index on idSEARCH being used which is only scanning a subset of tables, whereas other keys will show SCAN which is a full table scan.K
KI
QKQ
UU
A prepared SQL statement must contain only one statementK;' ' or '\n' then it'll reject it as it thinks there's more statements to come.KUUKwrangler d1 execute DB --local --command "select * from company"status text NOT NULL DEFAULT 'active'insert licenses (id) values (1);{"sql":"INSERT INTO [licenses] (\"id\", \"status\", \"plan\", \"created_at\", \"expires_at\") VALUES ($0,$1,$2,$3,$4)","params":["2",null,null,null,null]}SELECT * from test WHERE id=100"rows_read": 1EXPLAIN QUERY PLANSEARCHSCANA prepared SQL statement must contain only one statement' ''\n'CREATE TABLE IF NOT EXISTS licenses (
id integer PRIMARY KEY AUTOINCREMENT,
status text NOT NULL DEFAULT 'active',
plan text NOT NULL DEFAULT 'basic',
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
expires_at DATETIME DEFAULT CURRENT_TIMESTAMP
);INSERT INTO verification_keys (id, content, account_name) VALUES ('6de221d9-4546-4599-ae7a-956632c9f6c9', 'c9948fff-9da3-4713-a169-9c434dbb1681', 'user1');