Home › Forums › Back End › How do i update the table that doesn't have primary key? › Reply To: How do i update the table that doesn't have primary key?
primary keys are for identifying records, so, without a primary key, it is not possible to identify specific records. If you need to, then you should change your DB design so it uses primary keys.
Otherwise, your updates would apply to any records that match your
where clause. In some cases, this might match the specific record you want; in others, it might match several.
If you need a more specific answer, you’ll need to share your DB schema (you can use
show create table your_table_name_goes_here;)