I create a table in mysql using the following script: When I export the created table from phpMyAdmin, I obtain the following script So the question are: where is my foreign key constraints? does KEY refer to FK? Seems that the two tables utente and attivita are no longer referenced in the new generated script. where am I doing wrong?
Tag: phpmyadmin
Export table description in PHPMyAdmin/MySQL
DESC table_name Above SQL allows me to get the table description in PHPMyAdmin. I want to export it to a text file or word file for the documentation. Is there a possible way to do it. Thanks.
PhpMyAdmin does not show Query results operations at the bottom of Query Result
I can see Query results operations which gives me a way to export my query result for some queries but not for others where there is a query with bunch of joins. I feel its the type of Query. Is that the reason or is it the number of results? Snapshot of the actual query : Replaced the variables for
Exporting SQL table using phpMyAdmin gives no results for large data sets
When I open my table in phpMyAdmin and click Export (selecting .zip from the save-as options), I get an empty (0 byte) zip file. The table has ~200 000 records. This problem does not occur for smaller tables. This problem also does not occur when I export only the first 60 000 records. Is this a bandwidth limitation? Is this