[DiscordArchive] `some tables have no primary key so my workbench refuse to make changes in it` - What? What did you
[DiscordArchive] `some tables have no primary key so my workbench refuse to make changes in it` - What? What did you
Original source
`some tables have no primary key so my workbench refuse to make changes in it` - What? What did you do to make it complain about that?
rektbyfaith
01-01-2024, 07:00 PM #1Archived author: Revision • Posted: 2024-01-01T19:00:15.470000+00:00
Original source
`some tables have no primary key so my workbench refuse to make changes in it` - What? What did you do to make it complain about that?
Original source
good question
![[Image: image.png?ex=690c581e&is=690b069e&hm=dd7...212f35bd9&]](https://cdn.discordapp.com/attachments/689803159086170250/1191473716463407115/image.png?ex=690c581e&is=690b069e&hm=dd71fa541414f10384ca3004d8d9f5b6f7e81bab17962f13dbed15a212f35bd9&)
rektbyfaith
01-01-2024, 08:11 PM #2Archived author: GvR Mr Mister • Posted: 2024-01-01T20:11:10.561000+00:00
Original source
good question
Original source
pretty much never touched this table yet
rektbyfaith
01-01-2024, 08:11 PM #3Archived author: GvR Mr Mister • Posted: 2024-01-01T20:11:30.899000+00:00
Original source
pretty much never touched this table yet
Original source
That is not an error
rektbyfaith
01-01-2024, 08:31 PM #4Archived author: Revision • Posted: 2024-01-01T20:31:54.840000+00:00
Original source
That is not an error
Original source
MySQL Workbench is also garbage, to be honest. It has certain limitations (and bugs) that it shouldn't have - like this one. Supposedly that's how Workbench works, you can't edit it without a primary key which is just silly. Go with another GUI editor.
rektbyfaith
01-01-2024, 08:35 PM #5Archived author: Revision • Posted: 2024-01-01T20:35:35.319000+00:00
Original source
MySQL Workbench is also garbage, to be honest. It has certain limitations (and bugs) that it shouldn't have - like this one. Supposedly that's how Workbench works, you can't edit it without a primary key which is just silly. Go with another GUI editor.
Original source
all right ty
rektbyfaith
01-01-2024, 09:50 PM #6Archived author: GvR Mr Mister • Posted: 2024-01-01T21:50:38.764000+00:00
Original source
all right ty
Original source
Why do you think this limitation is silly? It's quite the opposite, without a primary key you can't uniquely identify a row in the database. even if the generated query had all columns in its where, it would still be confusing because in case of multiple rows with the same values, all rows would be changed which wouldn't match the expected user experience (user modified just one row in the GUI). Generally speaking all tables should have a primary key.
rektbyfaith
01-02-2024, 01:40 AM #7Archived author: bandysc • Posted: 2024-01-02T01:40:13.937000+00:00
Original source
Why do you think this limitation is silly? It's quite the opposite, without a primary key you can't uniquely identify a row in the database. even if the generated query had all columns in its where, it would still be confusing because in case of multiple rows with the same values, all rows would be changed which wouldn't match the expected user experience (user modified just one row in the GUI). Generally speaking all tables should have a primary key.
1 Guest(s)
1 Guest(s)