Querying D1 database
Basic Query:
const result = await env.DB.prepare( 'SELECT * FROM news WHERE id = ?' ).bind(newsId).first()
Query Multiple Rows:
const result = await env.DB.prepare( 'SELECT * FROM news ORDER BY created_at DESC' ).all()
const prisma = new PrismaClient({ adapter: new PrismaD1(env.DB) }) const news = await prisma.news.findMany({ where: { published: 1 }, include: { tags: true } })
await env.DB.batch([ stmt1.bind(...), stmt2.bind(...) ])
On this page