Cannot execute query on mysql ubuntu droplet.

May 6, 2015 1.4k views
MySQL

Cannot execute query on mysql ubuntu droplet.

i tried to execute this query :
select a.NAMAMAHASISWA,a.TAHUNMASUK,a.CKODEPRODI,b.*

from tmstmahasiswa a, smktlogtramhsnilai b
where a.C
NPM=b.CNPM
AND b.C
TAHUNAKADEMIK='2014-2015' AND b.CKODESEMESTER='1'
AND b.F
VERIFIED='0'
order by b.C_NPM ASC

but it return nothing. the query not excecuted.

i tried to execute the same query on my xampp localhost on windows and it was executed successfully.

anyone facing the same problem before?

3 Answers

How are you executing the query? What makes you think it's not executed?

executed the query on pypmyadmin,
also on mysql shell using : mysql -u root -p

it's not executed because it returns nothing,
both phpmyadmin and mysql shell.

the i run the same query on my xampp localhost on windows and it was executed successfully.

i follow this tutorial to build my webserver : http://www.servermom.org/build-ubuntu-server-a-complete-guide/

i'm sorry before, now the query was executed successfully.
the problem is mysql use 100% of cpu, and then i've tried to index my table and it works.
thanks for your help :)

Have another answer? Share your knowledge.