Problem executing SELECT on a table in phpmyadmin

0

I have several tables in my database, and until recently, there was no problem in any of them. I was able to quietly manage the whole bank by phpmyadmin. However, suddenly in one of the tables the query SELECT * stopped executing properly in phpmyadmin.

When executing the query SELECT * FROM Punctuation (or simply clicking on the table in the interface), phpmyadmin reports an error on the server, and gives no further details. The query returns the records, but only shows the contents of the first three columns of the table (the table has 14 columns).

Note that this is a problem exclusive to phpmyadmin. The SELECT query in the Scoring table typically works on both the Linux terminal and the MySQL Workbench.

Another important detail is that this table is the one with the largest number of records in my database. There are almost 200,000 records.

Has anyone ever had a similar problem? Would that be some restriction of phpmyadmin for tables with a large amount of record? Is there anything I can do to get around the problem?

    
asked by anonymous 01.09.2017 / 15:57

1 answer

0

"... but only showing the contents of the first three columns of the table ...", It may be a problem with phpmyadmin encoding, try using the "SELECT * FROM Score" command on the terminal and check for " ç ", some punctuation or any special character.

    
01.09.2017 / 16:22