/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

3 votes360 views2 answers
WhereIn SQL
SQL
0 vote378 views1 answer
Suhaib
SQL
0 vote398 views1 answer
Doesn't have default value mysql
SQL
0 vote373 views1 answer
Oracle date winter time
SQL
0 vote343 views1 answer
Sql server select ignore dupplicates
SQL
1 vote385 views1 answer
What is in condition in sql
SQL
2 votes383 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote378 views1 answer
Delete * from where id = 1;
SQL
1 vote347 views1 answer
Show table columns
SQL
0 vote370 views1 answer
Mysql backup certain tables workbench
SQL

Share