mysql error
Posted: 23 Jul 2022 09:06
I'm trying to create a mysql databes using the template in the manual. the sql creation fails as the colum nane "grouping" is a reserved would and so mysql won't allow it,
Then you need to modify the sql statement (ie. put it in quotes resp. back ticks or even remove those columns), as the statement is just a template.
But being honest, I don’t recommend using SQL tables at all, as they are not supported for maintaining meta data. Ie. they are basically used for migration scenarios. You need to provide maintenance functionality yourself.