AnsweredAssumed Answered

Update Record in MySql Database Table(no primary key) from LAC?

Question asked by rhythmarora on May 4, 2018
Latest reply on May 8, 2018 by rhythmarora

We are using a MySQL database and are trying to update a table with no primary key ( with PUT, POST) for particular columns using a condition in 'sys filter' in CA LIVE API Creator. However, it is not getting updated, showing an error stating " you cannot insert, update, or delete in table main: tableName because it has no primary key.

 

Kindly suggest, is it not possible to update a table without a primary key?

Outcomes