Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

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?

#171548
__
Participant

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;)