I m using D1 and trying to apply a
I'm using D1 and trying to apply a schema.sql file onto it. However, a few statements don't get read (
Parsing 3 statements -> Executed 1 command in 9.842563999816775ms), with no error messages. I've narrowed it down to the INSERT INTO command. The first one works, but the next ones don't. 😅 I don't know what to do1 Reply
I worked around it by just inserting multiple rows in one statement. Instead of
INSERT INTO x3, I did `INSERT INTO table (...) VALUES (data1, data2), (data1, data2), ... ;