is there a max number of rows in a SQL Server 2008/2012 and MySQL table?
Microsoft has excellent documentation on the limitations of SQL Server

MySQL has a similar resource (warning - PDF) on their site.

As it stands, your question is far to broad and will likely be put on hold until you can narrow down your requirements.