I need to get the name of the table with the biggest number of rows, I can find the biggest number of rows with function count and than function max, but i don't know how to see from which table is that maximum, can anyone help? tnx
iv_jo
0
Newbie Poster
Recommended Answers
Jump to PostIf it is mysql driven application, there is
mysql_list_tables()
function.
When you check all table names and collect it with loop (probably should unsetinformation_schema
,mysql
andperformance_schema
) you can use comparation part …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.