/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 votes332 views4 answers
Mysql decimal
SQL
0 vote338 views1 answer
Sql server datetime
SQL
0 vote338 views1 answer
Mysql regex select
SQL
-1 vote358 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote346 views1 answer
Postgresql in vs any performance
SQL
2 votes435 views1 answer
Ssh mysql port forwarding
SQL
3 votes346 views1 answer
Sql is not like
SQL
0 vote327 views1 answer
Can sqldatareader be null
SQL
0 vote367 views3 answers
CONTACT FORM SQL
SQL
92 votes620 views6 answers
Substring
SQL

Share