Difference between ??SQl

[Santanu.Das]

What is difference between MySQl & MSSQL database storage limitation.
More descriptively, If I make databases using the above-mentioned database systems. How much data I can store in each of them, i.e. 1GB, 2GB, 10GB, 100Gb. What is the limitation?

[cereal]

MySQL can store up to 16TB per table, but it depends on OS/filesystem in use, with linux the limit is 4TB per table, source:

• http://dev.mysql.com/doc/refman/5.6/en/table-size-limit.html

MSSQL seems capable of 16TB:

• https://msdn.microsoft.com/en-us/library/ms143432.aspx

I will add PostgreSQL to the comparison, which can handle up to 32TB per table:

• http://www.postgresql.org/about/

[Reverend Jim]

If you are using SQLEXPRESS (free), the database size is 10GB.

[Santanu.Das]

Thanks everyone