Jump to content

what's the different of SQL and MySQL


gongpex
 Share

Recommended Posts

MySQL & PostgreSQL are database programs. SQL is the langauage MySQL uses to manipulate the database. I haven't looked into PostgreSQL much, so I'm not sure if it uses SQL or what makes it different. MySQL is the most popular database program, and is often used alongside PHP and the Apache Web Server.

Link to comment
Share on other sites

MySQL & PostgreSQL are database programs. SQL is the langauage MySQL uses to manipulate the database. I haven't looked into PostgreSQL much, so I'm not sure if it uses SQL or what makes it different. MySQL is the most popular database program, and is often used alongside PHP and the Apache Web Server.
Mysql is most likely the most popular free database platform but in the enterprise your more likely to find Oracle or Microsoft databases. As far as I know there all just SQL database platforms and they more or less have the same basic commands and probably a few that are vendor specific (The more technical aspects will differ though, like maximum table sizes etc.). I was recently introduced to Oracle 10g Express as part of my schoolwork and looking at the SQL statements its pretty much the same as MySQL but the user interface is a lot more advanced than say a phpMyadmin or the built in mysqld executable.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...