Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to check which table has data in mysql

mysql> SELECT table_name, table_rows
   ->FROM INFORMATION_SCHEMA.TABLES
   ->WHERE TABLE_SCHEMA = 'business';
Source by www.tutorialspoint.com #
 
PREVIOUS NEXT
Tagged: #check #table #data #mysql
ADD COMMENT
Topic
Name
9+4 =