/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

6 votes144 views1 answer
Oracle pl sql source
SQL
0 vote132 views1 answer
Fetch second word from a string in ms sql
SQL
5 votes154 views1 answer
Mysql count newlines in field
SQL
0 vote149 views1 answer
Ver usuarios mysql
SQL
0 vote146 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote144 views1 answer
Stored procedure function relation
SQL
0 vote159 views1 answer
On delete set default
SQL
3 votes150 views2 answers
See mysql users ubuntu
SQL
0 vote135 views1 answer
Equi joins in oracle
SQL
0 vote180 views1 answer
How to check event scheduler status mysql
SQL

Share