problem related to query in mysql

[Sandeep Shah]

hello friends
I just want to know the query to find the number of table in one schema in MYSQL Database.

waiting for your rply

[r035198x]

hello friends
I just want to know the query to find the number of table in one schema in MYSQL Database.

waiting for your rply

Are you talking about

show tables;

?

[Sandeep Shah]

Are you talking about

show tables;

?

Thank's friend
But I want to find the number of table in one schema.
I got the name of table in one schema thrgh your query.

[r035198x]

Thank's friend
But I want to find the number of table in one schema.
I got the name of table in one schema thrgh your query.

select count(*) from information_schema.tables where table_schema = "Your_Schema";
 

[Sandeep Shah]

Are you talking about

show tables;

?

Thank's friend
But I want to find the number of table in one schema.
I got the name of table in one schema thrgh your query.
waiting for your reply

[Sandeep Shah]

select count(*) from information_schema.tables where table_schema = "Your_Schema";
 

SELECT count(*) FROM information_schema.tables WHERE table_schema = "Your_Schema";

example myschemaname=abc

I wrote my schema's name (abc) in place of Your_Schema and
when i execute this query i am getting the error like (Table abc.tables' doesn't exist )
so wht should i do....

[r035198x]

SELECT count(*) FROM information_schema.tables WHERE table_schema = "Your_Schema";

example myschemaname=abc

I wrote my schema's name (abc) in place of Your_Schema and
when i execute this query i am getting the error like (Table abc.tables' doesn't exist )
so wht should i do....

Post the exact query that you used.

[Sandeep Shah]

Post the exact query that you used.

Let say My database is "bufferabc_test"

SELECT count(*) FROM information_schema.tables WHERE table_schema = "bufferabc_test";

I am getting this error >>> Table 'information_schema.tables' doesn't exist

OR If i change the query in this way >>>>

SELECT count(*) FROM bufferabc_test.tables WHERE table_schema = "bufferabc_test";

Then I am getting this error >>> Table 'bufferabc_test.tables' doesn't exist

So wht should i do plz reply soon

[r035198x]

Let say My database is "bufferabc_test"

SELECT count(*) FROM information_schema.tables WHERE table_schema = "bufferabc_test";

I am getting this error >>> Table 'information_schema.tables' doesn't exist

OR If i change the query in this way >>>>

SELECT count(*) FROM bufferabc_test.tables WHERE table_schema = "bufferabc_test";

Then I am getting this error >>> Table 'bufferabc_test.tables' doesn't exist

So wht should i do plz reply soon

count(*) FROM information_schema.tables WHERE table_schema = "bufferabc_test";

should work. However, you need to be logged as a user sho has access to both the information_schema and bufferabc_test schema.

[Sandeep Shah]

count(*) FROM information_schema.tables WHERE table_schema = "bufferabc_test";

should work. However, you need to be logged as a user sho has access to both the information_schema and bufferabc_test schema.

Thank's Friend
Your given query is working....I got the result which i want.