Timeline for MySQL: For every Column, create if not exists?
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 11, 2022 at 2:56 | comment | added | J.D. |
This alone doesn't tell them which columns don't exist yet though (as any combination of the 5 columns may exist), especially with their original COUNT(*) query. They could build off of your suggestion using dynamic SQL to create only the new columns, for example, or other solutions based off of it.
|
|
| S Aug 11, 2022 at 2:16 | review | First answers | |||
| Aug 11, 2022 at 4:05 | |||||
| S Aug 11, 2022 at 2:16 | history | answered | msbeast | CC BY-SA 4.0 |