No id returned (mysql2)

async function create(data: NewBusiness) {
  return client.insert(business).values(data)
}

async function create(data: NewBusiness) {
  return client.insert(business).values(data)
}

async function create(data: NewBusiness) {
  return client.insert(business).values(data)
}

async function create(data: NewBusiness) {
  return client.insert(business).values(data)
}

returns

     headers: [],
     types: {},
     fields: [],
     rows: [],
     rowsAffected: 1,
     insertId: '0',
     size: 0,
     statement: ...

     headers: [],
     types: {},
     fields: [],
     rows: [],
     rowsAffected: 1,
     insertId: '0',
     size: 0,
     statement: ...

     headers: [],
     types: {},
     fields: [],
     rows: [],
     rowsAffected: 1,
     insertId: '0',
     size: 0,
     statement: ...

     headers: [],
     types: {},
     fields: [],
     rows: [],
     rowsAffected: 1,
     insertId: '0',
     size: 0,
     statement: ...

I need Id. Tried to add

.execute()

.execute()

.execute()

.execute() a the end but same thing.

MAST•11/5/23, 8:58 AM

Did you try .returning().returning() after the insert?

But that depends on the db you are using.

Angelelz•11/5/23, 3:16 PM

MySql doesn't have the returning method.

Angelelz•11/5/23, 3:17 PM

But if you are using the .$default().$default() method, MySql will not return back the id because technically you provided it to the DB via your custom default

No id returned (mysql2)

Similar Threads

Similar Threads

Similar Threads