Some of the utilities for exporting data structure only declare the primary key in an ALTER TABLE at the end of the file. I never understood why. Not sure if it was phpmyadmin or mysql workbench.
Mysqdump declares it differently again On Wednesday 1 May 2024 at 2:39:14 pm UTC+10 Clay Jackson wrote: > I'm importing weewx data from a mariadb database to a percona xtradb and > it has strict primary key enforcement turned on. Is there a reason there's > a key but not a primary key defined for the archive table? -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/18390f85-9da0-4acf-9560-285b51a24e1an%40googlegroups.com.