Q
UU
A prepared SQL statement must contain only one statement
K; at the endUK' ' or '\n' then it'll reject it as it thinks there's more statements to come.KUUKKwrangler d1 execute ... --command?UKUwrangler d1 execute my-db --local --file=path/to/file.sqlKKK
LK
U
MMKL
C
CREATE TABLE IF NOT EXISTS Messages (id TEXT, userId TEXT, content TEXT); but when I try to select from Messages it says the table doesn't exist?ML
C
--local
Jposts in your case) and do the LIMIT there, and then do the joins in the outer table, if that makes sense.
JL
SS
IFor example, if the users table has an index on a timestamp columnFor https://developers.cloudflare.com/d1/platform/pricing/, I still cannot understand how rows read works at this moment. Rows reading measurement only shows example of full table scan, but not others such like partial read (filterable, join etc).created_at, the querySELECT * FROM users WHERE created_at > ?1would only need to read a subset of the table.
I
D
DD
B
wrangler pages dev bound to a local instance of D1 started up with something like pnpx wrangler -c wrangler.toml d1 execute DB --local --file=migrations/001.sql ? Just want to make sure this is a supported use case for D1 in the Beta stage @ the moment. Note: I already have a working D1 setup with pages on Cloudflare. I'm interesting in running locally. So my question essentially is just if whether this is already supported or not.
F
V
pnpx wrangler d1 execute db_name --local --file=./src/dump/dump.sql but it stayed the same for past 1h:
Mapping SQL input into an array of statementsB
IIVVIII
Request entity is too large [code: 7011] error from Wrangler, though.VA prepared SQL statement must contain only one statement;;' ''\n'wrangler d1 execute ... --commandwrangler d1 execute my-db --local --file=path/to/file.sql SELECT
posts.id,
posts.title,
posts.updatedOn,
substr(posts.body, 0, 20) as body,
users.firstName || ' ' || users.lastName as author,
count(comments.id) as commentCount,
categories.title as category,
COUNT() OVER() as total
FROM posts
left outer join users
on posts.userid = users.id
left outer join comments
on comments.postId = posts.id
left outer join categoriesToPosts
on categoriesToPosts.postId = posts.id
left outer join categories
on categoriesToPosts.categoryId = categories.id
group by posts.id
order by posts.updatedOn desc
limit 10
offset 0CREATE TABLE IF NOT EXISTS Messages (id TEXT, userId TEXT, content TEXT);--localpostscreated_atSELECT * FROM users WHERE created_at > ?1wrangler pages devD1D1D1pnpx wrangler -c wrangler.toml d1 execute DB --local --file=migrations/001.sqlpnpx wrangler d1 execute db_name --local --file=./src/dump/dump.sqlRequest entity is too large [code: 7011]INSERT INTO verification_keys (id, content, account_name) VALUES ('6de221d9-4546-4599-ae7a-956632c9f6c9', 'c9948fff-9da3-4713-a169-9c434dbb1681', 'user1');