Our Training Programs

All contents are copyright of their authors.

My sql query Issue

My sql query Issue

vipin kumar

9yAsked Nov 18, 2016, 2:24 AM1.2kDatabases & DBA

I am facing an issue in mysql

I have created a table in mysql like hr.emp .Now when I am going to run this query

Select * from hr.emp .It gives error.

There is an alternate using tilled like `hr.emp` but I can not use in my scenario.

kindly help me.

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Milan Prajapati9y ago
Accepted answer
select * from `hr.emp`; will work.

If it doesn't then try adding Database name before table name like :

select * from `Databasename`.`hr.emp`;
Priyanka K S7y ago
It is not good practice using dot in any name like table, db,view,etc..
if want separator in name '_' (underscore) is the best separator and it will maintains readability ease.

Milan Prajapati answer will work.
Purvi Barot7y ago
please try
SELECT * FROM 'database'.'hr.emp';
may this will work
Thank you;
Nitin Sontakke9y ago
May be you should have shared the error as well. Just saying it gives error doesn't tell us much, does it?