Timeline for How to rename a column name which has been created by a math function in mysql? Using ALTER TABLE is giving ERROR: 1064 (42000)
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 22, 2021 at 13:38 | vote | accept | Titiksha | ||
| Jul 22, 2021 at 13:37 | vote | accept | Titiksha | ||
| Jul 22, 2021 at 13:38 | |||||
| Jul 22, 2021 at 12:00 | comment | added | nbk | Don't forget to accept the answer | |
| Jul 22, 2021 at 11:57 | comment | added | Titiksha | Thanks, this worked | |
| Jul 22, 2021 at 11:34 | comment | added | nbk | @Titiksha i changed myanswer after testing it with mysql 8.0.25 | |
| Jul 22, 2021 at 11:34 | history | edited | nbk | CC BY-SA 4.0 |
added 17 characters in body
|
| Jul 22, 2021 at 11:16 | comment | added | Titiksha | Hi, I had already tried that. It adds another column "values" will NULL for each of the value. And the ST_DISTANCE column remains the same with same column name. | |
| Jul 22, 2021 at 11:12 | history | answered | nbk | CC BY-SA 4.0 |