Timeline for Mysql - Table structure to hold history log without any primary key
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 15 at 3:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 7 at 0:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 1 at 23:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 27, 2024 at 23:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 28, 2024 at 7:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 22, 2023 at 12:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 17, 2023 at 18:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 14, 2023 at 23:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 13, 2022 at 23:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 26, 2022 at 20:16 | comment | added | Rick James | @Kondybas - Minor detail: It's a 6-byte number that is pseudo-shared by all tables without a PK. | |
| May 26, 2022 at 20:15 | answer | added | Rick James | timeline score: 0 | |
| May 26, 2022 at 13:06 | comment | added | Kondybas | Anyway, for (default) InnoDB storage if no PK declared explicitly then a hidden column with autoincremented BIGINT value will be added to the table implicitly and will be used as PK. Therefore there are no advantages to omit PK column, at least for InnoDB tables. | |
| May 26, 2022 at 12:45 | comment | added | Akina | You do not need in unique row identifying. You don't perform any operations which needs in this.So i think that you may remove this column without unpleasant consequences. service delete all rows by product_id and dev_stage_id every 5 minutes and then new data is created Service deletes the rows and you cannot influence this? if you may effect this deletion then use not DELETE but TRUNCATE - it resets AUTOINCREMENT attribute for the table. | |
| S May 26, 2022 at 9:54 | review | First questions | |||
| May 26, 2022 at 20:18 | |||||
| S May 26, 2022 at 9:54 | history | asked | SilentRage47 | CC BY-SA 4.0 |