/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

0 vote192 views1 answer
Object Information
SQL
3 votes215 views2 answers
Having in mysql
SQL
0 vote207 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
7 votes277 views2 answers
Phpmyadmin change password
SQL
2 votes218 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote208 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
4 votes215 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote197 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote216 views1 answer
Sql decode
SQL
2 votes201 views1 answer
Set username and password for postgresql database
SQL

Share