/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 vote191 views1 answer
Pv mysql import
SQL
4 votes211 views3 answers
Sql drop primary key
SQL
0 vote259 views1 answer
How to rename a database in tsql
SQL
0 vote198 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote250 views1 answer
Install squirrel sql ubuntu
SQL
0 vote287 views1 answer
Sqlite display headers on columns
SQL
8 votes259 views3 answers
Postgres database sizes
SQL
0 vote245 views1 answer
Pl sql search in all packages
SQL
-2 votes208 views1 answer
Modify column name in tsql
SQL
1 vote219 views1 answer
Median mysql
SQL

Share