mysql error

You found a bug or have any issues? Please post them here!
Post Reply
fjb59
Posts: 92
Joined: 23 Jul 2022 09:02
mysql error

Post by fjb59 »

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,
User avatar
radio42
Site Admin
Posts: 8295
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: mysql error

Post by radio42 »

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.
fjb59
Posts: 92
Joined: 23 Jul 2022 09:02
Re: mysql error

Post by fjb59 »

ok thanks for your response.

Post Reply