I have got a peculiar problem. I am not able to query my tables without db username prefix like username.tablename. Worse, I have logged in as username.
Any ideas on what could be the problem?
Now I have to give queries like select * from celia.orders instead of just select * from orders.
Thank you.
Celiacan't u use the
use databasename
select * from table
if it was permission, you probably won't be able to see the tables.
No comments:
Post a Comment