MYSQL is used to store data permanently also MSACCESS is used. But both are different technology so today i will discuss about difference between both.
|
MYSQL
|
MSACCESS
|
|
Fully RDBMS
|
RDBMS
|
|
Large application
|
Small application
|
|
Multiple DB Engine
|
Single DB Engine
|
|
More ACID(Atomicity Consistency Integrity Durability) of transaction
|
Less ACID property of transaction
|
|
Easy referential Integrity
|
Hard Referential integrity
|
|
Open source
|
Product of Microsoft
|
|
License Free
|
License paid
|
|
Good Execution Speed
|
Poor Execution Speed
|
|
Good Performance
|
Poor performance
|
|
Platform Independent
|
Platform dependent
|
|
Hard Maintenance
|
Easy Maintenance
|