iddatabase_id. Which one is it?
database_id
C
database_id
C id SERIAL PRIMARY KEY seems not work, I follow the doc https://developers.cloudflare.com/workers/tutorials/postgres/#5-interact-with-the-products-database, I know the condition is own host PostgreSQL but the D1 should be the same, right?
VVid int primary key autoincrement
C
CC
TPRIMARY KEY need to be the last "field", so after createdAtC
C
D1_ERROR: Error: ERROR 9007: SQL execute error: UNIQUE constraint failed: User.emailD1_ERROR: Error so that I can't detect existed email 
CERROR 9015: SQL engine error: query error: Error code 2067: A UNIQUE constraint failed (UNIQUE constraint failed: User.email)Cerror.cause?.message 
MC
A
M
I
let me PR that 
I
M
U
M
wrangler d1 execute?UMA
M)M
BMB
CU
MM
env but instead context.env per the linked docsMM
CMMC
SELECT * from items where id=(SELECT item_id FROM parts WHERE ? in (name, id))? to 0
Cstrings to ints. Cvalue was '0' and not 0'Test_Entry' was 'test_entry' which is why nothing was working id SERIAL PRIMARY KEYid int primary key autoincrementERROR 9009: SQL prepare error: near "createdAt": syntax error in CREATE TABLE Love( uid integer NOT NULL, ideaId integer NOT NULL, PRIMARY KEY (uid, ideaId), createdAt datetime DEFAULT CURRENT_TIMESTAMP ); at offset 109PRIMARY KEYD1_ERROR: Error: ERROR 9007: SQL execute error: UNIQUE constraint failed: User.emailD1_ERROR: ErrorERROR 9015: SQL engine error: query error: Error code 2067: A UNIQUE constraint failed (UNIQUE constraint failed: User.email)error.cause?.messagewrangler d1 executeenvcontext.envinterface Env {
YOUR_DB: D1Database;
}
export const onRequest: PagesFunction<Env> = async (context) => {
// Create a prepared statement with our query
const ps = context.env.YOUR_DB.prepare('SELECT * from users');
const data = await ps.first();
return Response.json(data);
}SELECT * from items where id=(SELECT item_id FROM parts WHERE ? in (name, id))?stringsintvalue'0''Test_Entry''test_entry'CREATE TABLE Love(
uid integer NOT NULL,
ideaId integer NOT NULL,
PRIMARY KEY (uid, ideaId),
createdAt datetime DEFAULT CURRENT_TIMESTAMP
);console.log(query);
result = context.env.db.prepare(query).bind(value);
const res = await result.raw();
console.log("RESULT: "+res);export async function onRequestGet(context) {
const value = 0; // normally this is from the URL
var partialQuery = "SELECT item_id FROM ";
partialQuery+= 'categories';
partialQuery+=" WHERE ? in (name, id)";
var query = "SELECT * from items where id=("+partialQuery+")";
console.log(query);
var result = context.env.DB.
prepare(query).bind(value);
const res = await result.raw();
console.log("RESULT: "+res);
return new Response("");
}