Is it true that MySql database has some limitation that can cause problem when a table is filled with over 200,000 records? Whether the question is true ? if yes What will be the solution for that ?
As alfasin said, there is no 200,000 fixed limit.
However there are limits based on available disk space and largest individual file size; both those depend on the MySQL storage engine you are using (single file / multiple files) and the size of the row multiplied by the number of rows. You'll need to work out the limit based on your OS - you really, really need a HUGE application to reach those limits, though, and if you do get there, you'll have other things to worry about :)
You will also get performance limits if you don't index tables correctly (or have too many indexes); again, no fixed limits and you'll just notice performance dive for some queries.
You can force a table to have limits with MAX ROWS: this is a guide that tells the storage engine how to optimise itself.
But for the purposes of your analysis, you can put millions and millions of rows in a table.