Thursday, February 5, 2015

PhpMyAdmin cannot import sql.


I tried to run a simple sql select query to a mysql database through phpmyadmin interface. But I was getting this error message.

Can't import SQL into PHPMyAdmin.

But when I'm running the same query using mysql console command line it was ok. So found the solution and it was very simple. Just run use statement with the database name that you need to query.

use DB_College;
SELECT * FROM TBL_Students;

Thanks!