English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I'm still trying to establish all the terminology here:

Are MySQL and Access both used for database creation? What are the advantages/disadvantages of each?

2006-08-31 16:48:26 · 6 answers · asked by Anonymous in Computers & Internet Programming & Design

6 answers

Are MySQL and Access basically the same thing?
- they have in common which is in the field of database. And generally, those software using SQL have common in commands, like 'SELECT * FROM Table1'.
Are MySQL and Access both used for database creation?
- Yes.

Advantages (MySQL):
-Unlimited in records, new version (see link), have a partitions.
-Nowadays, the most popular database, almost beating other database competitors.
-Open source database.
-You can download the latest version from their website.
-Free (almost).
-Others (see MySQL website).

Disadvantages (MySQL):
-Maybe little hard to maintain.
-Needs good knowledge in database administration.

Advantages (Access):
-Easy and you can have database immediately.
-No programming (if you like).
-Samples databases.

Disadvantages (Access):
-Proprietary of Microsoft.
-Not suit for gigantic records.

You can go first Access, and then go on to MySQL.

2006-08-31 17:22:59 · answer #1 · answered by VBACCESSpert 5 · 0 0

I personally use MySQL. I guess the real advantage to MySQL is that it's free (there are plenty of free resources to obtain MySQL, Apache Web Server to create websites).

PHP is a programming language designed for MySQL. In fact, Yahoo! uses PHP to program this site in particular.

Access is awful unless you're using it for personal use. Once you introduce elements of networking, Access has terrible record locking features and space management. An 85MB Access database only takes up about 2MB in MySQL.

2006-08-31 17:37:04 · answer #2 · answered by mcfallsg 1 · 0 0

Access is a GUI that implements SQL

MySQL is a database language derived from SQL and Oracle.

They're both SQL based stuff... so the same advantages and disadvantages.

Access is nice because you don't have to remember all the small details of SQL statements.. they can be a pain

2006-08-31 16:51:26 · answer #3 · answered by Greg G 1 · 1 0

Not really the same but they are both frequently used for similar things. They are both placed on web servers for similar purposes, for example I could use either one to keep a list of login user names and passwords. MySQL is quite a bit more scaleable whereas Access is more limited.

2006-08-31 23:33:25 · answer #4 · answered by Michael Darnell 7 · 0 0

I would only use Access for home desktop database use... and stick with MySQL for server database programming.

2006-08-31 16:51:34 · answer #5 · answered by Anonymous · 1 0

no my sql and access not same thing.

as both are used for the database purpose only.

access easy to learn while my sql not so easy.

as security purpose my sql well and good.

2006-08-31 16:57:44 · answer #6 · answered by ketan patel 2 · 1 0

fedest.com, questions and answers