How many columns and rows store in a table in mysql?
Short Answer: Alot
There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact limit depends on several interacting factors.
There is no row limit.
If you find yourself with a lot of columns though you might have to post the database scheme here for review, it’s normally a sign you are doing something wrong.