Time Out When trying to run query in Mysql

Asked

Viewed 94 times

0

I’m running the following code:

SELECT e.*, e.CO_ESCOLA, es.CO_ENTIDADE 
FROM enem20162 e
INNER JOIN escolas es ON e.CO_ESCOLA = es.CO_ENTIDADE
#WHERE CO_ENTIDADE = 
ORDER BY e.CO_ESCOLA;

I want to return students who are connected to a school, but when I run the code in Mysql it cannot complete the execution. It keeps trying to run and never ends. I’ve changed the parameters to increase the running time but it didn’t work.

mysql join

  • goes into mycfg.ini and increases mysql timeout and memory usage and edits php.ini and increases the Execution time of it.

  • I’ve already done this... in reality I don’t use php, I’m using it locally. I’ve already taken the e.*, and it’s still only running.

No answers

Browser other questions tagged mysql join

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