/SQL/Check data in table mysql

Check data in table mysql

Check data in table mysql

SELECT * FROM TABLE_NAME;

3

How to check which table has data in mysql

mysql> SELECT table_name, table_rows
   ->FROM INFORMATION_SCHEMA.TABLES
   ->WHERE TABLE_SCHEMA = 'business';

0

Source: tutorialspoint.com

Similar codes

11 votes360 views2 answers
Mysql set safe mode off
SQL
11 votes359 views2 answers
Insert date sql
SQL
5 votes328 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote331 views1 answer
Sql right characters
SQL
0 vote353 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote363 views1 answer
Find usage of table in sql server
SQL
12 votes354 views6 answers
Between in sql
SQL
20 votes360 views6 answers
Creating a table in sql
SQL
0 vote335 views1 answer
Enable Rabbitmq management plugin
SQL
1 vote367 views1 answer
Sql dcl
SQL

Share