/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

1 vote295 views1 answer
Mysql select update same table
SQL
0 vote288 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
1 vote318 views1 answer
Size of all tables in a schema oracle
SQL
3 votes302 views2 answers
Sql random integer
SQL
2 votes328 views5 answers
Install postgresql 10 centos 7
SQL
0 vote343 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote299 views1 answer
Get week day name sql server
SQL
0 vote293 views1 answer
Mysql get 2nd value in comma separated list
SQL
1 vote310 views1 answer
Moodle query item quiz
SQL
0 vote325 views1 answer
Postgresql port 5432 not open
SQL

Share