Problem running SELECT in a phpmyadmin table

Asked

Viewed 302 times

0

I have several tables in my database, and until recently, there was no problem in any of them. I was able to manage the entire bank smoothly by Phpmyadmin. But suddenly in one of the tables the query SELECT * stopped running properly on Phpmyadmin.

When executing the query SELECT * FROM Score (or simply click on the table on the interface), Phpmyadmin accuses an error on the server, and gives no further detail. The query returns the records, but showing only the contents of the first three columns of the table (the table has 14 columns).

It is worth noting that this is a problem unique to Phpmyadmin. A query SELECT in the Score table works normally on the Linux terminal and Mysql Workbench.

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

Has anyone ever had a similar problem? Would this be some restriction of Phpmyadmin for tables with a large amount of record? There’s something I can do to get around the problem?

inserir a descrição da imagem aqui

php mysql sql phpmyadmin

  • could you provide print of what’s going on? Could you put your code in as well?

1 answer

-1

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

  • There are no strings with special characters in this table. Only dates, integers and strings encrypted with sha-512 (i.e., no special characters). I found that running a SELECT with more than three columns, phpmyadmin only returns the values of the first three columns in the query. For example, if I run the "SELECT query idCliente,numEstabelecimento,numLoja,timestampPontuacao FROM Pontuacao", phpmyadmin returns only the values of the columns idClient, numEstablishment and numLoja.

Browser other questions tagged php mysql sql phpmyadmin

You are not signed in. Login or sign up in order to post.