Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench edit column without pk

How to edit columns if my table doesn't have aprimary key? My way truncate the table and insert a record again... but this is not right.

like image 200
Dmitry Kovalev Avatar asked Dec 13 '25 20:12

Dmitry Kovalev


1 Answers

Can you temporarily add a primary key instead, e.g. add an auto inc column? After editing you can remove it. Better would be of course to have a permanent primary key.

like image 200
Mike Lischke Avatar answered Dec 15 '25 10:12

Mike Lischke



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!