In phpMyAdmin, the results of some queries can be truncated, as shown below:
This isn’t due to the size of the browser window or any error on your part; phpMyAdmin simply truncates the text.
The solutions is very simple:
- Click on the + Options link above the results.
- In the options menu, select Full texts.
- Click on Go to re-execute your query.
Once you’ve done this, phpMyAdmin will display the complete results of your query:
The problem: You’re trying to use the Table Data Import Wizard in MySQL Workbench to import a CSV file into a database and it’s giving you the following error:
This file type is not supported, valid options are CSV, JSON
However, you are sure that the file is a CSV file.
The solution that worked for me (with MySQL Workbench 8.0): Renaming the CSV file from DATA.CSV to DATA.csv. Yes, MySQL Worbench did not like the capitalization of the file extension.