A prepared SQL statement must contain only one statement
A prepared SQL statement must contain only one statement
K;
UK' ' 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);
C
--local
Jposts
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)., the querycreated_atwould only need to read a subset of the table.SELECT * FROM users WHERE created_at > ?1
I
D
DD
B
wrangler pages devD1pnpx wrangler -c wrangler.toml d1 execute DB --local --file=migrations/001.sqlD1D1
F
V
pnpx wrangler d1 execute db_name --local --file=./src/dump/dump.sql
Mapping SQL input into an array of statementsB
IIVVIII
Request entity is too large [code: 7011]
MD
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 0' ''\n'wrangler d1 execute ... --commandwrangler d1 execute my-db --local --file=path/to/file.sql