Displaying 2 results from an estimated 2 matches for "stationsnummer".
2019 Apr 24
2
mariadb: How to delete foreign key constraint from non-existing table?
Hi,
somehow phpmyadmin messed things up when I was trying to modify a table.
The table disappeared, and now it's impossible to re-create it:
MariaDB [time]> create table etikettend_metainfo (userID integer(6)
unsigned, stationsnummer integer(4) unsigned, primary key (userID));
ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo`
(errno: 150 "Foreign key constraint is incorrectly formed")
MariaDB [time]> show tables like 'etikettend%';
+------------------------------+
| Tables_in_time (et...
2019 Apr 24
0
mariadb: How to delete foreign key constraint from non-existing table?
...gc-24.de> wrote:
>
> Hi,
>
> somehow phpmyadmin messed things up when I was trying to modify a table.
> The table disappeared, and now it's impossible to re-create it:
>
>
> MariaDB [time]> create table etikettend_metainfo (userID integer(6)
> unsigned, stationsnummer integer(4) unsigned, primary key (userID));
> ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo`
> (errno: 150 "Foreign key constraint is incorrectly formed")
> MariaDB [time]> show tables like 'etikettend%';
> +------------------------------+...