I want to unlock the columns which appearing in the following pic:
https://i.sstatic.net/3F7cb.png
I know that the answer is make id a primary key. but the problem here is that I can't make id a primary key because there are two rows empty in id column and I can't delete these rows because the column locked! Please try to help me. Thank you very much
You cannot update or delete rows if you don't have primary key. That is the reason they're locked. It's impossible to identify rows uniquely for update/delete queries to run.
It happens when we have not turn on the primary key on our column of any which we want to make primary key . just go to the properties of the table and turn on the primary key of your column which you want to make primary key.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With