/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

2 votes202 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote200 views1 answer
Python mysql query to dataframe
SQL
9 votes218 views2 answers
Oracle all tables in schema
SQL
6 votes240 views2 answers
How to get last element sql
SQL
1 vote188 views2 answers
Grab part of a string sql
SQL
3 votes215 views1 answer
What is having
SQL
0 vote202 views1 answer
Compare if is null sql
SQL
0 vote215 views1 answer
For row in sql database python loop
SQL
2 votes186 views1 answer
Oracle number to percentage
SQL
1 vote167 views2 answers
Get date from datetime postgresql
SQL

Share